Forum Discussion
Cumulative line chart based on text
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.
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.
- HoangHugo
Yes, becasue you put "Intern Status" into matrix, so it will be a filter. To see right result, remove this column
- mangaus1111
Solution Sage
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.