Running Total as % for Pareto Chart | Community
Skip to main content

Running Total as % for Pareto Chart

  • January 26, 2021
  • 6 replies
  • 0 views
O

Hi all,

I'm wondering if there's any way to represent data as a running total in terms of percentage of all items, like in the line section of a pareto chart.

The closest I've gotten is using result path calculation, but that lets me either do running total or percentage of total, not both.

If that's not clear, this might help: on the furthest right, the chart should read 100%.

Thanks!

    6 replies

    H
    • Hillary12
    • January 26, 2021

    Hey Owen, you can only show 1 result path calculation per metric.  If you want to show two on the same metric, you will have to first create a duplicate copy of the metric, then add that duplicate to the query.  Then you will have two metrics in result path calculation.

    O
    • Owen11
    • Author
    • January 26, 2021

    421033327594 Sorry, I may not have made it clear what I'm looking for: the thing I was having trouble with was not duplicating the metric, it's getting the duplicate to show as running total percentage. As far as I can tell, result path calculation lets me do running total (as total quantity, not as percent) or % of total (but not as a running total)... but I can't do running total as % of total like you would see in the line section of a pareto chart.

    I can't show my actual data, but I've made a Paint mockup, below: I can do A (running total, but not % of total) or B (% of total, but not running total), but I want C (running total).

    I also might be misunderstanding if you're saying I should add a third metric, but I'm not sure how that would help!

    H
    • Hillary12
    • January 28, 2021

    Hi Owen, after I wrote this original post, I did think of something.  Could you have two metrics, and have one display as %age: chart configuration > display format > %.  Then do a running sum on that metric - since it's in %age format already?

    If that doesn't work for you, I would recommend adding some feedback to request this type of result path calculation.  You can do that here: https://support.zendesk.com/hc/en-us/community/topics/360001200913

      O
      • Owen11
      • Author
      • January 28, 2021

      Thanks Hillary. I've submitted the feedback as requested here: https://support.zendesk.com/hc/en-us/community/posts/1260800893790-Result-Path-Calculation-Running-Total-Cumulative-Percentage-

      O
      • Owen11
      • Author
      • January 28, 2021

      421033327594: to address your edit, I seem to now be getting this problem. Can I somehow divide by the total in the formula of the metric to fix this, or is this as close as we're going to get?

      Thanks for all the help, by the way!

      H
      • Hillary12
      • January 30, 2021

      Oh, I see, it's not really displaying %ages, it's display the number as a %age.  So, that was bad advice from me.  You'd actually have to figure out how to display the %age based on the total - I can't quite figure out a way to do that (know what the total is while in the row for that calculation).

      Terms & ConditionsCookie settingsAccessibility statement