Question

How to group three column values into one column value

Hi,

I have one chart and in this chart I do have one dimension which is showing countries. Also, I do have one metric which is showing Automation Rate.

Dimension/Country names are A-B-C-D

My need is that I need to combine A-B-C into A so in the end I need to see A-D with their Automation Rate.

How can I make it? What are the ways that I can follow into Studio?

+4

You can just concatenate the same into one KPI

i.e. A||'-'||B

It cannot work in my case because I am calling different countries into dimension and KPI

I believe you're referring to World Map chart.

If my understanding is correct, you should try custom data labelling.

Custom data labelling will allow you to concatenate the country names like Abhishek explain above.

Only caveat here is and that's totally up to your requirement that whether you want to report this 4 times on your map?

If yes - no further step is required.

If no - You might need to restrict data for 3 countries.

Hope this will helps.

Sign up