Solved
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 Dashb...
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.
