Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative Sum and Cumulative Sum Percentage

Hi, I have a dataset which contains a case number, opended date, response target, response deviation in minutes. I added a custom column called First Response Calc for calculating the response targe...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Anonymous ,

    Modify the measure to the following form:

    1. Create measure.

    Measure =
var _1=COUNTX(FILTER(ALL('Sheet1'),'Sheet1'[_Histo FRT]<=MAX('Sheet1'[_Histo FRT])),[CaseNumber])
var _2=COUNTX(ALL('Sheet1'),'Sheet1'[_Opened Cases])
return
DIVIDE(_1,_2)

    2. Result:

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Anonymous ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _1=COUNTX(FILTER(ALL('Sheet1'),'Sheet1'[_Histo FRT]=MAX('Sheet1'[_Histo FRT])),[CaseNumber])
var _2=COUNTX(ALL('Sheet1'),'Sheet1'[_Opened Cases])
return
DIVIDE(_1,_2)

2. Place [Measure] in Line values.

3. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Liu,

     

    The calculation you provided calculates the percentage of the total for each bar correctly (thank you).

     

    I am looking to see a culmulative percentage though. If the first bar is 40%, then the second bar which is 33% should be 73.33% since it's a culumative percentage. 

     

    The bars and percentages should show:

     

    Bar 1: 40%

    Bar 2: 73.33%

    Bar 3: 86.66

    Bar 4: 100%

     

    Is this something that can be done?

     

    Thanks,

    Kevin