Hello,
I am trying to figure out the following using eazybi for a request by another co-worker. The data come from jira, but I can’t see to figure out how to make it “permanent”.
Goal: to display the unresolved issues from the week prior in the current week in a bar chart. So if there 58 issues opened for the previous and 13 were unresolved, we want to just show the count of 13 left alongside the current ticket count that is in a separate bar.
I have been able to get the number to display, but it degrades the prior week’s count as tickets are closed, so there is no permanent value. Is there a way to have the value stay permanent so we can see historically how many issues have been carried over?
Hi @Mark_Dellaquila,
In eazyBI, measures respond to the report context, including the selected Time period. A predefined measure relation to time is described in the documentation Jira Core measures and dimensions.
There are several approaches you can use depending on your needs and current report layout:
-
Use historical measures like “Issues history” with "Transition Status" dimension to see past status values (see documentation Import issue change history).
Then you can build reports like Unresolved issues by status over time: Unresolved issues by statuses over time - Issues - Jira Demo - eazyBI
-
Use standard calculations with Previous Period members to compare current value with value as it was in previous periods (see documentation Create reports)
-
Lastly, you can create a calculated measure to show a fixed point-in-time value. For the calculation, use a tuple expression of measures of interest and “Time” dimension with the specified date or period (see the documentation Calculated measures).
For example, to show the fixed value of open issues on the 1st of October 2024, the expression might look like this:
(
[Measures].[Open issues],
[Time].[Day].DateMember('Oct 01 2024')
)
Best,
Zane / support@eazyBI.com