I have created a bubble chart with X-axis value, Y-axis value and Bubble size. Each row is unique and they have a category name. Now I want to display the category name as the legend for each of the bubble.
Sample Data:
Region|ProductCount|Sales|Profit
North|10|1000|200
South|20|2000|250
East|15|1000|150
West|15|1000|300
X-axis = ProductCount
Y-axis = Sales
Bubble Size = Profit
I got until this. But I am not able to get Region as legend/color. The below code works without 'Region' in the table.
index=foo
| stats sum(ProductCount) as ProductCount, sum(Sales) as Sales, sum(Profit) as Profit by Region
| table Region, ProductCount, Sales, Profit
... View more