Bar Chart with user defined measure

[kaushi2020]

Hello Everyone, 

I have below dimension and measure.

Dimension:- Channel_Name

Measure:-

Num(count({$<Year=, Month=, Day=,AnswerType={'Main'},Score={'4','5'},QuestionType={'CSAT'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
distinct CONTRACT_ID)

/
count({$<Year=, Month=, Day=,AnswerType={'Main'},QuestionType={'CSAT'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
distinct Total<Channel_Name>CONTRACT_ID),'#,##0.0%')

Below is currently how the bar chart looks like. 

If i just add Channel Name as dimension and the measure expression by default above is the outcome. 

Here I want to show bar length based on 2 different measures. 

Measure 1 => default which I have shared above. It should bar length based on the measure calculation. 

Measure 2 => want to add 2 more conditions as a set expressions to the existing one to show the length of the bar. 

How I can do this ? 

Thanks in advance. 

[theoat]

Yes it is possible.
You can add another measure.



Kind regards,
Théo ATRAGIE.

[kaushi2020]

Thanks a lot for your approach. By adding 2 measure and 1 dimension, you will get 2 grouped charts based on the existing dimension. But in my case I want to show only 2 bars which should ideally show the custom calculation.

To show custom measure %, I just deleted the dimension and added 2 master items (using master items enables me to add custom colours for the bars)

With this approach, I will still show only 2 bars even when I have multiple values in Dimension. 

also the calculation for each bar is based on the Master item 🙂 

Thanks Again