Forum Discussion
Cumulative line chart based on text
I am just going to post this again...
How do I make this into a cumulative line chart? These "Intern status" should just be added together even though they are different categories.
Best regards,
Lisa
Hi Anonymous ,
I don´t know if I undestood well, but you can try with this measure
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
HoangHugoSolution Specialist
Hi
measure
cumulative_count =
var date_select = SELECTEDVALUE([Date])
var count_status = count([Intern Status])
return CALCULATE(count_status, [date]<=date_select)
then, create a line chart, put [date] in X axis and measure in Y axis
Hi HoangHugo
Thanks, but I think something is missing because I did the measure but it does not add them up as you can see. I would like it to be cumuative_count = 2 under 25/07, 3 under 06/09 etc.
- HoangHugo
Yes, becasue you put "Intern Status" into matrix, so it will be a filter. To see right result, remove this column