Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,076
Community Members
 
Community Events
176
Community Groups

eazyBI - Filter "returned" issues

Hello!

I am very new to eazyBI and MDX. Recently I have been trying to accomplish a task but have had little to no progress.

I wish to create a report that has the following columns:

1. Total number of inactive issues ("Rejected", "Backlog" or "Classified")

2. Total number of active issues (not "Rejected", "Backlog" or "Classified")

3. Total number of times the active issues have transitioned backwards from "In Check" or "In Correction"

4. Total number of times the active issues have transitioned backwards from "Approved"

As these transitions may also go forward down the workflow, I am unable to use the Transition from status measure. 

My goal is to have two stacked bar charts. The first showing me the proportion of inactive to active issues which should total to the number of issues created. And the second showing me the number of "returns" from each category which should total to the total number of transitions backwards.

 

1 answer

1 vote
Fabian Lim Community Leader Dec 08, 2021

Hi @Lucas Yap

For 1 and 2 you can use the aggregate function to group statuses together. Have the measures issues created and status in the columns. Issues will tenon rows. Link: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/aggregate

For 3 and 4, you can use the transition to dimensions: https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/issue-transitions-by-users

Regards

Hi @Lucas Yap ,

The first two points are addressed by @Fabian Lim . Hint - aggregating all statuses without the three mentioned could be tedious work. Look into the Except() function to make it easier - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/except.

I  want to chip in for the last two points. You can use a combination (tuple) of the measure "Transitions from status", Transition Status dimension member (or calculated member) and the Status dimension calculated member to retrieve the number of transitions from specific statuses for issues currently in a different status.

As an example, active issues have transitioned backwards from "In Check" or "In Correction". See the formula below:

(
[Measures].[Transitions from status],
[Transition Status].[Check and Correction], -- <== Transition Status calculated member
[Status].[Active] -- <== Status calculated member
)

See more details on defining calculated members and measures on the eazyBI documentation page - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members.

Best,

Roberts // support@eazybi.com

Like Fabian Lim likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events