Transform a JQL to a guage

project in (AA,BB) AND issuetype in (Story) AND status in (“In Progress”, “Under Review”) and sprint is EMPTY order by created DESC

How can I make it to gauge to show the total numbers of it?

Thanks

Hi @wing ,
To create this measure, your first need to create an aggregate in Project and Status dimensions.
Project “AA & BB”:

Aggregate({
  [Project].[AA],
  [Project].[BB]
})

Status “In Progress and Under Review”:

Aggregate({
  [Status].[In Progress],
  [Status].[Under Review]
})

Then use the above members to create a tuple in your Measure dimension:

(
  [Measures].[Issues created],
  [Project].[DEMO Alpha],
  [Issue Type].[Story]
  [Status].[Status],
  [Sprint].[(no board)].[(no sprint)]
)

See also this presentation on how to translate JQL to eazyBI: Training videos on specific topics

best,
Gerda // support@eazybi.com

1 Like