Total by color, grouping, chart

hatra
edited February 11, 2022 in Analytics #1

Hi all,
I have a requirement where I need to apply highlight to present data by color ie =1 and <80 red, = 81 and 130 yellow, =131 and 500 green
and count the color based on grouping ( city) , then count the each color ie red 2, yellow 4, Green 6 so I can show each city on the chart (x) and count of each color on (y) separably? if I apply aggregation if would just total all, what is the best approach please

Comments