EazyBI - How can I get a measures not considering issues cancelled in Jira?

[Leandro Pachega]

I've created a measure within a specific transition, but I got a lot os issues resolved, including cancelled ones. 

I want to not consider the cancelled, but when I calculate in this way:

([Measures].[Itens_Concluidos_com_GMUD]
-
[Measures].[ItensCancelados])

The second part is returning issues that not belongs to the first part. Help me people! Tks ; )

[Walter Buggenhout · Accepted solution]

Hi @Leandro Pachega and welcome to the Community!

It's a bit difficult to answer your question without any more context than what you are providing here. What a measure returns as result is most of the time related to the dimension it relates to in your report. Make sure you understand the main concepts (one of which is the dimension) before diving into further complex scenarios.

I am referring to those because the statement "I've created a measure within a specific transition" is open for a lot of interpretation.

You can use tuples to isolate a set of issues in your report. A bit of context to what they are is available in the EazyBI documentation. Basically, it just returns a fixed set of issues from your entire data cube. Assuming that your cancelled issues are issues with a resolution named resolved, the following tuple would return just those cancelled issues:

([Measures].[issues resolved], [resolution].[cancelled])

Note the syntax: the parentheses are essential for EazyBI to understand what you mean: all resolved issues, with resolution resolved.

Note that when you add this measure to a report and add the time dimension to your report's rows, you will see all cancelled issues for each selected row in time (year > quarter > month > day). And the same happens when you use other dimensions than time.

Note that these issues will be displayed in relation to the moment in time when they were actually resolved. The resolution date is key here to link the measure to the time dimension. Your transition you refer to will use the date of that actual transition to plot the issues against the time dimension. As these are different dates, you may see different issues appear in your report.

Hope this helps!

[Leandro Pachega]

Tks for your support @Walter Buggenhout ! But let me try to be more clear:

1) I have one first measure that results the count of issue that was transitioned from status "Aprovação".

([Measures].[Transitions from status issues count],
[Transition Status.By name].[APROVAÇÃO],
[Status.Category].[Done])

2) But in this result I got issues with status Cancelled and I'd like to not consider them. I'm using that measure:

([Measures].[Transitions from status issues count],
[Transition Status.By name].[APROVAÇÃO],
[Status.Category].[Done])

-

Aggregate({
[Status].[CANCELADO],
[Status].[CANCELLED]
})

But the second query isn't belongs to the first one. For example I got 100 issues as result of the first query, but I've got -20 issues as a result for the second. For me the result is incorrect, because I just want to filter the results of the Aggregate filter that belongs to the first measure.

[Walter Buggenhout]

Hi @Leandro Pachega,

You are using different dimensions in your measures. In the first one, you are using [Transition Status] and in your second you are using [status]. As similar as they may seem, these are different things.