Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one column called Rank. I have values in this columns like "Agree", "Disagree", "NA". I can have one bar chart with % of occurrence of "Agree", "Disagree", "NA". I take "Rank" column as dimension and Count(Rank)/count(total(Rank) as measure.
How can I combine e.g "Disagree" and "NA" and display as one dimension Like "DisagreeAndNA" with % of total of them and Disagree as other dimension. Thanks
You can create a new field in the script
LOAD Rank,
If(Match(Rank, 'Disagree', 'NA'), 'DisagreeAndNA', Rank) as CombinedRank
FROM ....
And then use CombinedRank
Or use this as your calculated dimension
If(Match(Rank, 'Disagree', 'NA'), 'DisagreeAndNA', Rank)
in your script editor generate one more field like :
if (Rank=Match(Rank,'Disagree','NA'), 'DisagreeAndNA','Rank') As NewRank
Use NewRank as the dimensio in the chart
Thanks. You mean I have to make synthetic dimension an based on each have to add up the responses to group. I want some more efficient way to be used in formula in measure in chart
You cannot club dimension value using a measure... you will need to modify your dimension itself... the more efficient way would be to do this in the script (just as I mentioned above)