Skip to content

    • Charting

    Charting

    Chart properties subtotals and weighted averages

    Contributor
    in Charting

    Hello,

     

    Hope you all are having a great week.  I have a question about one of the new analyzer additions(which I Love) and in particular chart properties Total Row sub-totalling.  It works great for summing up values but when it comes to showing total %, to let's say % to plan, it totals all the %'s and doesn't use a weighted average that the beastmode used.  Here is an example:

    Currently with Sum
    RepsShippedShipped Plan% to Plan
    Rep 1105200%
    Rep 2101567%
    Rep 35045111%
    Rep 4607580%
    Rep 54540113%
    Rep 6101191%
    Total185191661%
        
    Currently with Average
    RepsShippedShipped Plan% to Plan
    Rep 1105200%
    Rep 2101567%
    Rep 35045111%
    Rep 4607580%
    Rep 54540113%
    Rep 6101191%
    Total185191110%
        
    How it should be /w Weighted Avg.
    RepsShippedShipped Plan% to Plan
    Rep 1105200%
    Rep 2101567%
    Rep 35045111%
    Rep 4607580%
    Rep 54540113%
    Rep 6101191%
    Total18519197%

     

    I hope that this is easy and that I'm not missing a field/checkbox on the chart properties but hoping I can get some direction.

     

    Thank you,

     

    Jerry Heard

     

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Member
      Answer ✓

      On my cards, if a column is a beast mode then the subtotal and grand total calculate based on the Beast Mode rather than a straight sum.  I remember talk about making other functions available on Subtotal/Total rows (like average, max, min, etc) but haven't see that yet.  Not sure why this wouldn't be working in your instance.

    Answers

    • Member

      Is anyone able to help out with this request?

    • Member
      Answer ✓

      On my cards, if a column is a beast mode then the subtotal and grand total calculate based on the Beast Mode rather than a straight sum.  I remember talk about making other functions available on Subtotal/Total rows (like average, max, min, etc) but haven't see that yet.  Not sure why this wouldn't be working in your instance.

    • Contributor

      The funny is that it is working now.  Thanks for the input.

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories