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?

Don't wait! Accept the Mission Possible: Splunk Adoption Challenge Now and Win ...

Unify Your SecOps with Splunk Mission Control

Data Preparation Made Easy: SPL2 for Edge Processor