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- · Accepted solution]

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

[Nuria Llobera Vila]

Hi Martins,

that works, thank you very much!

I have an additional question: how do you add the "Time in flagged >0"?

Right now I can see a long list of issues that has been never flagged (see image below) and I do no manage to add the filter.

Best regards,

Núria

[GeoHan]

Hi Mārtiņš Vanags,

Could you please help me with an eazyBI report which shows the count of issues flagged as Impediment by each user.

Thanks.

Geo Han

[Martins Vanags -eazyBI-]

Hi Nuria,

You could filter any measure in columns by clicking on the name and enabling the filter for rows

See attached gif.

Best regards,

Martins / eazyBI team

[Martins Vanags -eazyBI-]

Hi Geo,

In this case, you may want to import the following report definition (see below)

Assignee dimension can be added to rows, Flagged dimension can go to page filter where you select value "Impediment" and then you choose measure "Issues created" in columns.

 

N.B. Make sure that you have selected to import custom field "Flagged" via eazyBI import settings

Best regards,

Martins / eazyBI team

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Impediment issues by users (eazyBI sample report)",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Issues created]"],"members":[]}]},"rows":{"dimensions":[{"name":"Assignee","selected_set":["[Assignee].[All Assignees]"],"members":[{"depth":0,"name":"All Assignees","full_name":"[Assignee].[All Assignees]","drillable":true,"type":"all","expanded":true,"drilled_into":false}],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Flagged","selected_set":["[Flagged].[All Flaggeds]"],"members":[{"depth":0,"name":"All Flaggeds","full_name":"[Flagged].[All Flaggeds]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Impediment","full_name":"[Flagged].[Impediment]","parent_full_name":"[Flagged].[All Flaggeds]"}],"bookmarked_members":[],"current_page_members":["[Flagged].[Impediment]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{}}}
} ],
"calculated_members": []
}

[Fabio Vintorin]

Hi guys

I replicated this report, using the Flag as Dimension and it shows the issues with flag but in the column of days it doesn't show the time with the flag. I created the MDX as described but this zero.

[Martins Vanags -eazyBI-]

@Fabio Vintorin 

Your calculated is prepared for "Issue" level calculation, but you don't use issue level members in your report.

You would need a different approach by creating a calculated measure that can iterate through issues in each period and then calculate the same for your report (without using "Issue" dimension in the report layout).

Please reach out to support@eazybi with your current code and also export and share the definition of your report.

https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions

Martins / eazyBI team