How to create calculated member for Issue Type based on a field value?

[Manohar Kurapati]

Hi 

I am new to EazyBI and MDX syntax. I have an issue type 'Task' with a field 'Task Type' which specifies the type of the task (Eg: Architecture / Technical / Project Management etc).

I would like to create a Calculated member in Issue type so that I can segregate this Issue Type field by different Task types and use that calculated member for various measure.

1. Calculated Measure name: Architecture Tasks
   •  Sample JQL :   IssueType = Task AND 'Task Type' = 'Architecture'
2. Calculated Measure: Technical Tasks
   • Sample JQL: IssueType = Task AND 'Task Type' = 'Technical'

Please can you help with the MDX for the above calculated measures.

[Fabian Lim]

Hi @Manohar Kurapati

You could use the tuples from eazybi: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Tuples 

In your case something like: 

([issuetype].[Task],[Task Type].[Architecture]) 

[Lauma Cīrule]

@Fabian Lim is correct; tuples are the way to go!

Only, in addition, I would suggest you also add a measure you wish to see the totals for (eazyBI saying goes "Measure is a treasure!" ;)). So the complete new calculated member would be:

(
  [Measures].[Issues created],
  [Issue Type].[Task],
  [Task Type].[Architecture]
)

Or you can select the measures and use the Issue Type and Task Type dimensions as page filters.

Lauma / support@eazybi.com