Bubble Chart - X, Y, Bubble size and category name

[niyaz006]

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

[DavidHourani]

Hi @niyaz006,

This is working for me :

| makeresults 
| eval A="North|10|1000|200###
South|20|2000|250###
East|15|1000|150###
West|15|1000|300###" 
| makemv delim="###" A 
| mvexpand A 
| rex field=A "^(?<Region>[^|]+)\|(?<ProductCount>[^|]+)\|(?<Sales>[^|]+)\|(?<Profit>[^|]+)"
| stats sum(ProductCount) as ProductCount, sum(Sales) as Sales, sum(Profit) as Profit by Region
| table Region, Sales, ProductCount, Profit

Could you try it and let me know if it works for you as well ?

Also you could replace stats with chart, still works the same way :

| makeresults 
| eval A="North|10|1000|200###
South|20|2000|250###
East|15|1000|150###
West|15|1000|300###" 
| makemv delim="###" A 
| mvexpand A 
| rex field=A "^(?<Region>[^|]+)\|(?<ProductCount>[^|]+)\|(?<Sales>[^|]+)\|(?<Profit>[^|]+)"
| chart sum(ProductCount) as ProductCount, sum(Sales) as Sales, sum(Profit) as Profit by Region
 | table Region, Sales, ProductCount, Profit

Cheers,
David