Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
How to plot percentages on a line chart

Is there a way to plot percentages on a line chart considering the aggregate options available?  I have attached sample data with a plot using "averages" but that does not provide correct measures. I'm not sure how to create the proper formula to achieve proper results. 

  • 6729
    Verified Answer
    Offline posted

    To achieve this, you can use a “Post Pivot” calculated field. This calculation is performed on the result of the aggregation function, so if you aggregated (Sum) “Overtime” and “Total” by Period then added a “Post Pivot” calculated field (called “OT/Period” in the attached sample); you can then mark the Sum of Overtime and total as not visible so the Chart only show the % of over time per period.


    The attached file includes a sample dashboard and data file