How to show the oldest issue and some specific info status, custom fields

Questions & Answers
1

Hi,
based on specific dimensions as pages, I need to retrieve info about the oldest unresolved issue, its status and some other fields.
How can I achieve that?

Thanks,
Fabio

2

Hi @fabio.racobaldo

You can select the Issues dimension in the Rows section, add the necessary filters to the Pages section, and use the “Average age days” measure from the Measures dimension.

Note that this measure only returns the age of issues that have a set due date, if you would like to return the age of all unresolved issues, you can define a new calculated measure with the following formula:

CASE WHEN
[Measures].[Issue resolution] = "(unresolved)"
THEN
DateDiffDays(
  [Measures].[Issue created date],
  Now()
)
END

You can also add the necessary Issue properties to your report from the Measures dimension.
Finally, to only display the oldest issues, click on the column header and select the “Top rows” option:

top-issues
top-issues2078×1164 288 KB

Best regards,
Nauris / eazyBI support