Hi,
Usecase: I have KPI (%) and KPI indicator (good, average, bad...) which are aggregations and two dimensions (country + city) involved in the bar chart.
I want to have country as rows and count distinct city as columns (vertical bar chart). I want a color split with KPI indicators by bar with the number of cities for each indicator (bar usa / good : 5 cities, average : 4 cities, bad : 3 cities).
Atm, I only have the indicator for each country (usa : good, uk : average...).
Do you have any idea ?
Thanks,
Pierre
2 answers
Hi Adrian,
See the twb attached. I would like to have sheet 2 bar chart but with color we have in sheet 1.
Pierre
