Forum Discussion

Iamadityarajput's avatar
Iamadityarajput
Frequent Visitor
2 years ago

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...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
2 years ago

Sounds good. What have you tried and where are you stuck?

Iamadityarajput's avatar
Iamadityarajput
Frequent Visitor
2 years ago

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.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
     I was trying to create a measure which will return distinct issues

    Measures can only return a scalar value.

    • Iamadityarajput's avatar
      Iamadityarajput
      Frequent Visitor
      2 years ago
      what I mean is distinct count
      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        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.