EazyBI: Count issues in specific status on specific date

[Matti Ketonen]

I've tried to create a report that would list issues opened, closed, and show backlog out of those, and now to add how many are in "On Hold" status. I've succeeded creating all but this last calculated value.

My data set does have the status history as a dimension and as a property.

Essentially I would want this On Hold measure to look for the day of the row, and look how many issues were on hold on that specific day.

EDIT:

To follow up, I did reach out to EazyBI support and got an answer from them, that solved the problem.

Having those status history as dimension and so forth is a prerequisite, then use Transition Status dimension together with measure Issue history. That will retrieve you the historical status of the issues for each Time period, use this tuple in Measure dimension to create a calculated measure:

(
  [Measures].[Issues history],
  [Transition Status].[On Hold]
)

This is how my timeline chart looks now:

[Matti Ketonen · Accepted solution]

I did reach out to EazyBI support, and updated the original question to have the answer as well. For what so ever reason this thing didn't allow me to answer my own question earlier.

[Mariana_Pryshliak_SaaSJet]

Hello @Matti Ketonen 

I think you should contact the EazyBI support team here: https://eazybi.com/contact.  I'm sure they will help you find a solution if the application includes such functionality.

Take into account, that you can get the information you're looking for with another add-on - Time in Status for Jira Cloud. This app provides Status Count and Transition Count data.

I wish you find the best solution to your issue.