Forum Discussion
Status count over time
I am trying to visualize Jira issues count over time by status. Jira issues can be in three status category: 1. new / to do 2. In Progress 3. Done I want to visualize it in such a way that it sh...
I have created a calculated column which contains the date at which the issue was moved to next status and for the current status it contains now() . I was trying to create a measure which will return distinct issues where selectedvalue of x axis i.e., a date is between those two columns which contains the date at which the issue entered a status category and at which it left. I'm not sure if it's a correct approach and measure was giving a straight horizontal line.
I was trying to create a measure which will return distinct issuesMeasures can only return a scalar value.
- what I mean is distinct count
ok, that is possible with a disconnected dates table.
By the way, here's a graphical representation of your sample data. Not very useful
There are also typos where the timestamps for new status entries don't match.