Constrain by issue type without displaying

Hi. I’m a new EBI user so apologies if I’m missing the point here. I’m working in a cube where data from issues of many types has been imported. However, I am trying to create a simple pie chart to show time spent in “in progress” states against a custom field recording a sponsor, but for only tasks and stories. I’ve got the transition timing working and I can create the pie chart showing how time is divided against each of our suppliers. My problem is - I don’t know how to only perform this analysis for tasks and stories without ending up with a further divided pie chart. eg. sponsor 1+task, sponsor 1+story, sponsor 2+task, sponsor 2+story, etc.

Also, I have successfully used issue type as a page filter to achieve this, but I was hoping to use this for self-serve reporting so wanted to remove chance of users updating config they shouldn’t. Any suggestions?

Hi,

As you correctly mention, the most straightforward solution for this use case is to use dimensions in the report page filter.

You can use tuples in custom formulas to hide the page filters from users.
The following formula gives the days In Progress for tasks and stories:

([Measures].[Days in transition status],
[Issue Type].[Story])
+
([Measures].[Days in transition status],
[Issue Type].[Task])

Kindly,
Janis, eazyBI support