Splunk Enterprise

Toggle column chart data On/Off by clicking on the corresponding Legend label

Steve_A200
Path Finder

Hi,

I am not sure if this is possible at all or not, but I figured best to ask the experts before I keep spinning in circles.

I have created a classic dashboard, and would like to add the ability to toggle the visibility of the column chart data by having the user click on any of the desired legend label of the data series, and the columns belonging to that data visibility gets toggled Off or On.  So in the below example, the column chart is displaying 2 labels in the legend, "Used" and "Discount" at the start, and I would like to have the user toggle that view.

I do not have access to the backend server and would like to do everything from the GUI.

I would like the user to be able to click on the legend "Used" listed entry, and the column chart would remove the "Used" columns, and only display the "Discount" columns preferably expanded to the width of the column chart.

I have seen it occur in one of the other column chart within the same dashboard, and  I have not added or modified anything to create that.

The Drilldown option is set to None for this panel, and all other panels, yet by some magic the other panels sometimes behave to toggle Off/On the data being display by clicking on the legend labels.

The section for this panel xml is below, and any help would be greatly appreciated:

<panel>
<chart id="chart1">
<title>Titte of the Dashboard</title>
<search base="base_search">
<query>| search merchant IN ($merchant$)
| chart sum(used) as Used sum(Discount) as Discount over _time by merchant
| addcoltotals row=f col=t label="Totals" labelfield=merchant fieldname="Totals" Used Discount</query>
</search>
<option name="charting.axisTitleX.visibility">visible</option>
<option name="charting.axisTitleY.visibility">visible</option>
<option name="charting.axisTitleY2.visibility">visible</option>
<option name="charting.axisY2.enabled">0</option>
<option name="charting.chart">column</option>
<option name="charting.chart.showDataLabels">none</option>
<option name="charting.drilldown">none</option>
<option name="charting.legend.placement">right</option>
<option name="refresh.display">progressbar</option>
<option name="trellis.enabled">0</option>
</chart>
</panel>
Labels (1)
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

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

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...