EazyBI - Days Blocked Vs. Not Blocked

[Nick Brown]

Hi folks.,

I'm trying to create a stacked bar chart that shows the no. of days blocked vs. not blocked of our In Progress statuses.

Taking this issue as an example:

I want to just have two columns, showing the time blocked and not blocked, kinda like this:

[Roberts Čāčus - eazyBI · Accepted solution]

Hi @Nick Brown ,

I recommend bookmarking the two members you want to display. You can approach that from two directions. The first, "Search and bookmark" from the specific dimension "Select individual members" section. See a picture below:

The other way is by clicking on the member and selecting "Bookmark". Again, a picture below:

After that, you can select the two options only in the "Select individual members" section of the particular dimension. You may have to select and deselect the "All" dimension member to remove the previous selection.

Best,

Roberts // support@eazybi.com

[Nick Brown]

Hi Robert,

Thanks for the quick response. I don't think that gives me what I want though, what I want is to sum all those that aren't blocked, so essentially add all these values together:

Would that be possible?

[Roberts Čāčus - eazyBI]

Hi @Nick Brown ,

Thanks for the update. That did not occur to me. In such a case, you can create a calculated member in the particular dimension that aggregates the desired "unblocked" members. See an example in the eazyBI documentation - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/aggregate.

As an example, to aggregate the desired Transition Status members, the calculated member formula in the Transition Status dimension would look similar to the one below:

Aggregate({
  [Transition Status].[In Progress],
  [Transition Status].[QA]
})

See a picture below:

Does that look more like it?

For details on creating calculated members in other dimensions, see the eazyBI documentation page - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Howtodefineanewcalculatedmember.

Best,

Roberts // support@eazybi.com

[Nick Brown]

Getting closer - I feel there is something I'm doing wrong :/ 

This is what I have currently:

Any thoughts?

[Nick Brown]

Actually don't worry, I found it :)