Combining Responses from One field

[#1]

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

[sunny_talwar]

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)

[Anonymous]

‌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

[#4]

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

[sunny_talwar]

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)