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

Leandro Pachega_0jkqhi

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

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!