Solved: Is it possibile to display zero value label on cha...

andrewtrobec · ‎05-04-2020

Hello,
I've seen similar questions like this one, but not exactly what I'm looking for. I've managed to create buckets in the chart where those buckets don't have values, but what I'd like to do is add the zero label as well (the "Show Data Values" option). Here is an image showing what I mean:

Is this possible? Is there some CSS code that will allow me to do it?

Thanks!

Andrew

vnravikumar · ‎05-04-2020

Hi

Try this

<dashboard>
  <label>chart data</label>
  <row depends="$hide$">
    <html>
      <style>
      #rk  g [class="highcharts-label highcharts-data-label highcharts-data-label-color-undefined "]{
        display: block;

        }
      </style>
    </html>
  </row>
  <row>
    <panel>
      <chart id="rk">
        <search>
          <query>| makeresults 
| eval a=45,b=0,c=0,d=9 |table a,b,c,d | transpose 0</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.chart">column</option>
        <option name="charting.chart.showDataLabels">all</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.axisY.includeZero">true</option>
      </chart>
    </panel>
  </row>
   <row>
    <panel>
      <chart>
        <search>
          <query>| makeresults 
| eval a=45,b=0,c=0,d=9 |table a,b,c,d | transpose 0</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.chart">column</option>
        <option name="charting.chart.showDataLabels">all</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.axisY.includeZero">true</option>
      </chart>
    </panel>
  </row>
</dashboard>

View solution in original post

vnravikumar · ‎05-04-2020

Hi

Try this

<dashboard>
  <label>chart data</label>
  <row depends="$hide$">
    <html>
      <style>
      #rk  g [class="highcharts-label highcharts-data-label highcharts-data-label-color-undefined "]{
        display: block;

        }
      </style>
    </html>
  </row>
  <row>
    <panel>
      <chart id="rk">
        <search>
          <query>| makeresults 
| eval a=45,b=0,c=0,d=9 |table a,b,c,d | transpose 0</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.chart">column</option>
        <option name="charting.chart.showDataLabels">all</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.axisY.includeZero">true</option>
      </chart>
    </panel>
  </row>
   <row>
    <panel>
      <chart>
        <search>
          <query>| makeresults 
| eval a=45,b=0,c=0,d=9 |table a,b,c,d | transpose 0</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.chart">column</option>
        <option name="charting.chart.showDataLabels">all</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.axisY.includeZero">true</option>
      </chart>
    </panel>
  </row>
</dashboard>

andrewtrobec · ‎05-04-2020

@vnravikumar amazing, this works perfectly, thank you so much! Follow-up question: is there a way to have this work on all charts on a dashboard without have to assign ids to all of them?

vnravikumar · ‎05-04-2020

Welcome, you can apply to all chart by removing the id in the CSS

Is it possibile to display zero value label on chart?

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

Design, Compete, Win: Submit Your Best Splunk Dashboards for a .conf26 Pass

May 2026 Splunk Expert Sessions: Security & Observability

Join the Conversation