How to show two slices of ticket totals based on two criteria

Questions & Answers
,
1

I’ve managed to come up with a measure that shows all the JIRA tickets in a specific set of states:

Aggregate(
  {
    [Status].[In Progress],
    [Status].[Ready for Review],
    [Status].[Awaiting IT Completion of Security Controls & Activities],
    [Status].[Awaiting Questionnaire from IT],
    [Status].[Awaiting Information/Documentation from IT]
  }
)

But, I can’t find a way now to slice those tickets into two different sets based on if a specific label (Dormant) has been added to the JIRA tickets. Based on the documentation this should work but it is producing JQL errors.

Active Issues that are NOT Dormant:

Aggregate(
  Filter(
    {
      [Status].[In Progress],
      [Status].[Ready for Review],
      [Status].[Awaiting IT Completion of Security Controls & Activities],
      [Status].[Awaiting Questionnaire from IT],
      [Status].[Awaiting Information/Documentation from IT]
    },
    [Label] != "Dormant"
  )
)

And Dormant Issues:

Aggregate(
  Filter(
    {
      [Status].[In Progress],
      [Status].[Ready for Review],
      [Status].[Awaiting IT Completion of Security Controls & Activities],
      [Status].[Awaiting Questionnaire from IT],
      [Status].[Awaiting Information/Documentation from IT]
    },
    [Label] = "Dormant"
  )
)

Every variation I try from Google and the docs either ends up with ALL the issues or none of the issues.

Thanks in advance!

2

Hi @lartra,

Do you have a screenshot of the report you are expecting to see? It will help us visualize and create the correct report for you.

Thanks,

Eli Solutions

3

Sure here is what I’ve managed to make:

Screen Shot 2021-08-26 at 4.10.08 PM
Screen Shot 2021-08-26 at 4.10.08 PM1682×1578 313 KB

4

Hi @lartra,
First, you should create an aggregate member in the Status dimension (not in the Measure dimension):

eazybi_status_member
eazybi_status_member1544×1050 137 KB

To slice tickets into two different sets, you can use tuples.
The first would be a tuple with the label ‘Dormant’:

(
  [Measures].[Issues created],
  [Label].[Dormant]
)

To get issues without this label - subtract from all issues the first measure that contains issues with label ‘Dormat’.

[Measures].[Issues created]-[Measures].[Dormant label]

In the report it would look like this:

eazyBI_report_labels
eazyBI_report_labels1756×1060 144 KB

You may want to check training videos here about MDX: Training videos on specific topics - eazyBI for Jira

Kind regards,
Gerda // support@eazyBI.com