Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Yes it is possible.
You can add another measure.
Kind regards,
Théo ATRAGIE.
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