Forum Discussion
Cumulative chart with empty dates
Hello, I'm trying to create a commulative graph where I would indicate the evolution of a process consisting in requesting an item, approve the item, and then execute the action. The idea would b...
When you say 'the result was not correct', do you mean the rows with no approved date were included in the count?
If so, you can add a clause :
&& NOT(ISBLANK(Data[Date approved])
Thanks! it works fine individually:
If I create a graphic for each measure (axis X date requested/approved/converted and Y number of items it shows correct data.
However, when I try to combine them into just one graph, the result is totally messed up. I think it's because of the dates, since some dates are existing in one column but not in others
If you follow the rules of dimensional design, you'll have no problems creating correct and simple measures. Your visuals will work correctly as well.
Please watch this for a start:
https://www.youtube.com/watch?v=78d6mwR8GtA&t=1247s
Best
D