Hi,
I’m looking to create a cumulative line graph measuring cases closed over time in the month. Based on another Q&A (Cumulative months - #3 by andreab), I’ve created 3 calculated fields:
Day:
extract(‘DD’, {CLOSED_DATE})
Month:
extract(‘MM’, {CLOSED_DATE})
Cumulative Sum:
runningSum(distinct_count({case_id}),
[{Day} ASC],
[{Month}])
However, I’m getting breaks in the visual data and am unsure why. I’m assuming it may be to do with the fact I’m summing a count of IDs but would appreciate a solution.