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