eazyBI - Created vs. resolved with additional information (e.g. status)

[Klaus Fröhlich]

In eazyBI there is the default chart for created vs. resolved. The resulting chart is quite OK but we have on problem:

The open issues is growing since there are some tickets which are moved to 2nd level and are handled in a different application.

Therefore we set the to status "2nd level". Now it would be nice to have a second line below open issues which shows the "open issues with status 2nd level". However I do not know how to make this measuring function.

Required result (graphics done with Excel):

[Zane eazyBI Support · Accepted solution]

You may define a new calculated measure to count open issues in a particular status "2nd line" for each period based on issue change history data.

First, in import options, set "Import issue change history" and import data. After data import, new dimension "Transition Status" and history measures will be available for your reports.

Then, in a report, define a new calculated measure using a tuple. Your formula may look like this:

([Measures].[Issues history],
[Transition Status].[2nd level])

Regards,
Zane / support@eazybi.com

[Zane eazyBI Support]

You may define a new calculated measure to count open issues in a particular status "2nd line" for each period based on issue change history data.

First, in import options, set "Import issue change history" and import data. After data import, new dimension "Transition Status" and history measures will be available for your reports.

Then, in a report, define a new calculated measure using a tuple. Your formula may look like this:

([Measures].[Issues history],
[Transition Status].[2nd level])

Regards,

Zane / support@eazybi.com