How to track the time of flagged issues in JIRA using eazyBI

Nuria Llobera Vila

Hi,

I am currently using eazyBI for JIRA and I would like to track the time that an Issue has been flagged. How can I do it?

 

Thank you!

Núria

Martins Vanags_eazyBI

Hi,

In this case, you may want to use the following approach:

First, you should ensure that you have selected to import changes for custom field "Flagged" via eazyBI import settings.

1) issue change history - https://docs.eazybi.com/display/EAZYBIJIRA/Import+issue+change+history 

2) custom field "Flagged" as dimensions, property and value changes
https://docs.eazybi.com/display/EAZYBIJIRA/JIRA+Issues+Import#JiraIssuesImport-JiraCustomFields 


After this is done, try the following MDX code when you create a new calculated member (with correct formatting) in "Measures" dimension

 

CASE WHEN
[Issue].CurrentHierarchyMember.get('Flagged') = "(none)"
AND
(
[Measures].[Transitions to],
[Flagged].[Impediment],
[Time].CurrentHierarchy.DefaultMember
)>0
Then
DateDiffDays(
TimestamptoDate((
[Measures].[Transition to first timestamp],
[Flagged].[Impediment]
)),
TimestamptoDate((
[Measures].[Transition from last timestamp],
[Flagged].[Impediment]
))
)*24*60
when
[Measures].[Issue Flagged] = "Impediment"
Then
DateDiffDays(
TimestamptoDate(
(
[Measures].[Transition to first timestamp],
[Flagged].[Impediment]
)
),
now()
)*24*60
END

It will calculate the difference (in days, hours and minutes) between issue was flagged first time until now (if it is still flagged) or until it was un-flagged (if currently not flagged)

 

 

Best regards,

Martins / eazyBI team