Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I am counting the percentage of the difference of good answers minus bad answers of whole answer pool with the expression
count({<Field1={'X'},Field2={'1','2'}>}distinct ID) //Good
-
count({<Field1={'X'},Field2={'3','4','5'}>}distinct ID) //Bad
/
count({<Field1={'X'}>}distinct ID)
*100
This works, just fine and i have it on line chart and on KPI.
What i am trying to get is the count for cumulative days so it would give the total of prevoius days for each day and put that on same line chart. What would be the correct syntax for that?
@HamJan Perhaps this in a way to get Accumulation?
Rangesum(Below(count({<Field1={'X'},Field2={'1','2'}>}distinct ID) //Good
-
count({<Field1={'X'},Field2={'3','4','5'}>}distinct ID) //Bad
/
count({<Field1={'X'}>}distinct ID)
*100,
-
count({<Field1={'X'},Field2={'3','4','5'}>}distinct ID) //Bad
/
count({<Field1={'X'}>}distinct ID)
*100,1,1000))