| makeresults
| eval A=" North|WidgetA|1000###
South|WidgetA|2000###
East|WidgetA|1000###
West|WidgetA|300###
North|WidgetB|200###
South|WidgetC|20###
East|WidgetC|150###
West|WidgetB|300###"
| makemv delim="###" A
| mvexpand A
| rex field=A "^(?<Region>[^|]+)\|(?<Widget>[^|]+)\|(?<Sales>[^|]+)"
| stats sum(Sales) as Sales by Widget,Region
| table Widget, Region,Sales
Creates a table with unique widget, region pairs as rows, sum(sales) as a metric.
Expected X axis with widget names (WidgetA, WidgetB, WidgetC), Y axis as region names (North, South, East, West), bubble size as sum(Sales).
Observed all the bubbles at 0,0 and both X and Y axis is numeric.
One other answer suggested adding
<option name="charting.axisX">category</option>
<option name="charting.axisY">category</option>
Would specify the non-numeric option, but didn't work for me.
The few answers for Bubble (I guess Scatter will be the same) was from way back, tried them but didn't work.
In desperation I tried
<option name="charting.axisX">Widget</option>
<option name="charting.axisY">Region</option>
too, but to no avail...
... View more