Alternative State on Y-Axis in Distribution Chart

[car3489]

Hello,

I am trying to have 2 alternative states to be plotted similarly to how a bar chart does with 2 calculated measures using the set expressions i.e. Avg({[Sample-A]}[x]). What i am looking to do is have Sample-A & Sample-B on the Y-axis (Chart rotated) if that is at all possible?

My thinking would be a Dimension simply with "A" and "B" for example if the field is in either of the states but i am not sure how to proceed.

Thanks

[BenjaminT · Accepted solution]

Hi,

You could create a dummy dimension 'sample' in your data load with values 'A' and 'B' and use this as the dimension for the distribution chart.

Then use an if statement such as this one in the measure: 

=if(only(sample) = 'A', Avg({[Sample-A]} x), Avg({[Sample-B]} x))

Does that help?

Ben

[car3489]

That works great thank you!

I am hoping to reuse it in a T-test as well but have not tried it yet.