Skip to main content
1 resposta
  1. 12 de fev. de 2022, 11:40

    Hi @Iestyn Humphreys​,

    Are you still looking for this - 6 months later?

    By cumulative cost curve, is this just a cumulative histogram? Though you could use anything as the x axis.

    Using Superstore, this only needs a single calculation for the cumulative, though the cumulative is expressed as a percentage, with the distributions also expressed as a percentage, so you'll need a calculation for this too.

     

    1/ Bin you measure, we'll use Sales, set Bins as 500

    2/ Perc total:

    Sum(Sales) / Total(Sum(Sales))

    3/ Cumulative perc total:

    Running_Sum(Sum(Sales)) / Total(Sum(Sales))

    4/ Format both calcs to percentage

    5/ Drag Sales(Bin) to Columns

    6/ Drag Perc Total and Cumulative perc total onto the rows

    7/ Dual axis, setting Perc total mark as bar, and the Cumulative perc total as a line

     

    Hi @Iestyn Humphreys​,Are you still looking for this - 6 months later?By cumulative cost curve, is this just a cumulative histogram? Though you could use anything as the x axis. 

    Does this help?

    Steve

0/9000