Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
HamJan
Contributor II
Contributor II

Total count over dates

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?

Labels (4)
1 Reply
Anil_Babu_Samineni

@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,0),Above(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,1,1000))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful