5 Replies Latest reply on Aug 24, 2016 10:55 AM by chris.moore.11

    Dual Axis graph benchmarking help

    Nick Foley

      A request came in where, they would like a benchmarking graph as shown in the image below.... Where the selected customers position is shown relative to all other custuomers for each product.

       

       

       

      They want all the bars for every product to be the same length.  The issue is in my source dataset, the number of customers and spend per product varies greatly, making the bars varying lengths.

       

      I guess some type of percentile calculation would help here, but i am having issues figuring this out and been stuck for a day or so on it.

       

       

      I have also attached a workbook, that shows how my i have my paramater and calculated fields set up, to calculate the suggested customer revenue.

       

      Capture.JPG