Forum Discussion
Create a live case count line graph
Hi, I've got a table that collects info on cases. I'm trying to create a line graph chart showing the number of cases active per month by creating new columns for each month and trying to create ...
Thanks for the help and advice.
With this measure does it make a live count of cases per whatever calendar (day,month, year) you choose. Say for example will it show 10 cases open in June but in July 7 if the number has dropped?
Yes. Set it up as I've described and it will give you the open cases at each point in time based on the time period on the x-axis.
E.g. If you put calendar[Date] on the axis, it will tell you the number of open cases at the end of each date.
If you put calendar[Month] on the axis, it will tell you the number of cases that were open on June 30th, July 31st, August 31st etc.
Pete