It is possible to obtain the resolved issues order by Days


Im trying to get a report similar like that

I need the resolved issues order by days since they were resolved.
It’s similar than “Week Day” Measure but order by days.

Thank you!

Hello @oscar.jareno,

Welcome to eazyBI community!
There are two options I would like to suggest for your report as I am interpreting your requirement in two ways.

Option 1: When counting issues in Resolution intervals (how many days it took to resolve the issue), I would advise using the dimension Resolution interval and Measure: Issues resolved. More about interval dimensions - Interval dimensions
To set up your required intervals, you can apply the below interval I created. Edit the default value in your Resolution interval and paste the below interval.

Option 2. If you want to see how many issues were resolved 1 day ago, 2 days ago, 3 days ago etc, I would advise you to add Time dimension in your rows and Measure - Issues resolved in your columns. Then you will need to define new calculated member. I have written an example that you can use to define your time members up to day 6 by just changing the number of days in the formula accordingly. More about relative dates - Date filters

[Time].[Day].DateMember('3 days ago'))

For days “more than 7 days”, please use the formula below:

'7 days ago')<=0))

This is the result you will see :

I hope this helps! Let us know if you have any additional questions
Elita from