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. ...
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.
HoangHugo
Solution Specialist
Solution SpecialistHi
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.