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

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?

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

Join the Conversation

Is it possibile to display zero value label on chart?

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey