Question:need to combine two values in as one in a dimension

[Anonymous]

I have one dimension with category like "new,win,repeat".i want to combine New and win as dymanic and repeat as static in stacked bar chart .how can i do it? please help

[sunny_talwar · Accepted solution]

May be using a calculated dimension

If(Match(category, 'new', 'win'), 'dynamic', 'static')

[Anonymous]

Hi Sunny,

thanks you. its working but I am getting the whole calculated expression at the top along with the dynamic and static values.

also  what if I have more values apart from new win and repeat like switch ,restart and i want static to be only dynamic.

please guide.

thanks & regards,

Anuradha

[sunny_talwar]

Hi Anuradha, I don't think I completely follow your question... do you mind sharing some raw data and explain what you are looking to get out of it?