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
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