Splunk Search

Creating Bubble Chart with both X and Y axis as a category, and bubble size as a metric

ferenc0521
New Member
| 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...

Tags (4)
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...