8 Replies Latest reply on Jun 13, 2018 7:48 AM by Shinichiro Murakami

3 measures, need to compare 1 bar to (2&3) stacked bar chart

I have 3 measures, 1,2,3.

1. [max score]
2. [min score]
3. [change in score] = [min score] - [max score]

I would like 2 vertical bar chart where the first bar is avg([max score]) and the second bar is a stack of avg([min score]) and avg([change in score]).

I already have all 3 measures created and can display them as follows

Can any help me stack the orange and blue bars please?

• 1. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

HI Charles,

I understand what you need, but actually this is quite tricky.

To make this happen, you need to have "dimension" instead of "measure name" on x- axis.

I used "ID" as placeholder to show two measure names.

data I used.

Specify the position of ID, and calculate LOD max to ignore the each ID's score.

Table Calculation Functions

filter the ID from display.

Thanks,Shin

1 of 1 people found this helpful
• 2. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

Hi, sorry for the late response! Thank you so much for helping me.

This is starting to make sense, I already have the min and max scores and I am having trouble relating my scenario to your example when you use "ID" and "Score".

Can you help me relate this to my 3 measures. I have: min score, max score, delta?

Thank you again!

• 3. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

Thanks,

shin

• 4. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

Hi Shin,

I work for a hospital and cannot share/ upload any of the data or workbooks I work with.

Is there any way you can help?

• 5. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

I created a sample data set for us to work with.

I hope this helps

• 6. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

Hi Charles,

Thank you for the attachment.

The easiest way is to reshape the data.

From edit data source ==> Pivot

Pivot Data from Columns to Rows

End Image

Thanks,

Shin

• 7. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

Can I do this without reshaping the data source?

I have other views using this data and pivoting causes those views to break.

• 8. Re: 3 measures, need to compare 1 bar to (2&3) stacked bar chart

Hi Charles,

There are couple of ways TO re-shape the data.

But I don't have good idea without re-shaping.

Modifying the other view is one time task and once you decide that, it can be kept.

(I mean the Connection as "pivot" is saved as connection query for future)

Shin