Running Rate

Hi folks,

hoping someone can help me with a Running Rate.

I have pasted an example of how I have accomplished this in Looker, but I cant seem to figure it out in Sisense.

To Level set, in my Dashboard I have a Date Filter called Placement Dates.

I then want to calculate the Running Cure Rate by DE Length

to calculate the running cure, in Looker I would do a running sum of accounts that have cured/total placements(for the time period selected in the filters)

this is what it looks like.

DE_Length	Champion Running Cure Percentage	Challenger Running Cure Percentage
0	0.12%	0.12%
1	17.97%	17.58%
2	23.96%	24.80%
3	30.42%	30.85%
4	36.05%	36.47%
5	41.33%	40.71%
6	44.51%	43.84%
7	49.15%	47.80%

I cant seem to do the same in Sisense.

MikeG

Posted 1 year ago·Last reply 1 year ago

6 comments

david-h

·1 year ago

Thanks DRay to tag me !

MikeG , you can see each row as an individual calculation. For each of them, the engine applies a filter on DE_LENGTH. So the cells on first row are calculated with DE_LENGTH=0, second row DE_LENGTH=1, and so on.

In order to have a calculation not being influenced by this filter (Power BI would call it context) you need to add a filter to your measure : , all([DE_Length]) )

So in your pivot : [Running Cures] / ([Total Placements] , all ([DE_Length]) )

Be careful, if you use explicitly SUM, it would be :

[Running Cures] / (SUM ([Placements]) , all ([DE_Length]) )

Hope this helps.

Best,David.

MikeG

OP1 year ago

david-h Thank you, works perfectly

DRay

·1 year ago

Hi MikeG,

Let's tag david-h so he can see that you responded.

DRay

·1 year ago

Hello MikeG,

I’m following up to see if the solution offered by david-h worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post, that way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

MikeG

OP1 year ago

so it didnt work.
here is what it looks like when I do this in Looker. Notice the total placements is static, and only changes when I apply a filter on a date range.

DE_LENGTH	Running Cures	Total Placements	Running Cure Rate
0	10	10000	0.10%
1	25	10000	0.25%
2	45	10000	0.45%
3	100	10000	1.00%
4	300	10000	3.00%
5	450	10000	4.50%
6	556	10000	5.56%
7	685	10000	6.85%
8	978	10000	9.78%
9	1056	10000	10.56%
10	2500	10000	25.00%

when I try to replicate, Total Placements, is being influenced by DE_Length and it looks like this
Need to figure out how to get the Total Placements to be the actual Total of the date range Im looking at and not be based on the DE_Length, Hope this makes sense

david-h

·1 year ago

Hi MikeG,

Not sure how you do it in Looker, or what your tries look like in Sisense. But it looks like you have the right method.

The complete formula should looks like :

RSUM([Total of Number of accounts cured]) / ( [Total of Number of accounts cured] , all([DE_Length]) )

Best, David.