Forum Discussion
Item Status Monitoring Chart
Hi,
I have to create graph that shows the day by day evolution of the closed items vs the planned closure, so that every day when I refresh the dashboard I should see the amount of closed items vs the planned closure.
The dataset is something like this:
I was thinking to create one measure to calculate the amount of planned closed items over the time and one measure to calculate the sum of the day by day items closed, but I don't know if it is the right/easy way to do it.
Mind that in the dataset I don't have the real date when an item is closed.
Any idea or suggestions on how to do it?
Thanks,
Andrea
1 Reply
- lbendlinSuper User
read about USERELATIONSHIP. Have an active relationship between the calendar table and planned start data and an inactive relationship between calendar table and planned end date.