EasyBI report members grouping support

Mohanraj Ragupathi_vte4fv

We have JIRA Cloud environment. Hence the out of the box JIRA dashboards NOT supporting color change , grouping , etc I have downloaded "EasyBI" in our test environment and try out few things.

One of our need is "grouping" the value under a new name.

For e.g. We have 8 different defect status. But customer want to see it as "OPEN" or "CLOSED" defects. 

i.e. All the defects in "Customer Test" or "Closed" state should be combined and shown as "CLOSED" defects and the rest of the states should be shown as "OPEN" defects. They want to have drill down in this "OPEN" or "CLOSED". 

 

How to do this in EasyBI report?

 

Status	Defect Count
New	425
Analysis	286
Implementation	12
Integration	50
Validation	121
CCB	63
Customer Test	18
Closed	472

 

regards,

MOhanraj

 

Roberts Čāčus - eazyBI

Hi @Mohanraj Ragupathi 

 

You can look into the Status dimension "Category" hierarchy, where all the statuses are grouped by their categories in Jira - "To Do", "In Progress", and "Done".

The other option is defining calculated members in the Status dimension, and aggregating the desired statuses in two calculated members. Don't use the names of any existing status for the calculated members. The Status dimension calculated member formula for the closed statuses could look similar to the one below:

Aggregate({
  [Status].[Customer Test],
  [Status].[Closed]
})

See more details on defining calculated members in other dimensions here - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members.

 

Best,

Roberts // support@eazybi.com