Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

EazyBI : Can't create logic/query when theres "[ ]" symbol on the Status.

I have two statuses. 
1. Completed

2. [WBS01] Prepare WBS

 The question is, when we used this query, we success the process:

[Status].[Completed]

 

 

 

But, when we tried using this query:

[Status].[[WBS01]Prepare WBS]

undefined

We cant see the result of this query.


Can anyone help me solving this?? What should I do?

Especially, when trying to use status with the [ ] symbol on it.

1 comment

Hi @Rizky_Tuasikal,

You have indeed indentified a problem that is caused by a conflict in the standard syntax of MDX used in EazyBI on one side and your status naming in Jira. Those brackets have a function in MDX and you seem to break those with your naming convention.

An easy fix would be to update the name of your status and remove the square brackets there altogether. What you are doing there is also going against best practice in Jira, where it is way better to use more generic status names than going specific for each project / product / team. Using status names that are too specific, makes it really hard if you ever want to report across multiple projects and may even negatively impact performance of your system over time.

Having said that, I am not aware of a workaround that allows you to use names with brackets in EazyBI (MDX) formulas. Maybe the team can confirm if that is available somehow @eazybi ?

Comment

Log in or Sign up to comment
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you