Splunk Search

Help on flash chart, chart overlay in max, min column and mean line

sbnoobbb
Path Finder

I need help with this advance XML for chart overlaying and flash chart. I need to display a mean line over the columns of max and min temperature. Who can help or give advise, thanks in advance !


sourcetype="CurrentWeatherSG" | timechart span=1hour max(current_temperature) as Max, min(current_temperature) as Min

<param name="groupLabel">Overall Temperature</param>
  <module name="HiddenFieldPicker">
    <param name="strictMode">True</param>
    <module name="JobProgressIndicator">
      <module name="EnablePreview">
        <param name="enable">True</param>
        <param name="display">False</param>
        <module name="HiddenChartFormatter">
          <param name="charting.chart.useAbsoluteSpacing">True</param>
          <param name="charting.chart.columnAlignment">0.5</param>
          <param name="charting.axisY.maximumNumber">36</param>
          <param name="charting.axisY">numeric</param>
          <param name="charting.chart.nullValueMode">connect</param>
          <param name="charting.axisTitleX.text">Hourly</param>
          <param name="charting.axisTitleY.text">Celsius (°C)</param>
          <param name="charting.transparentBrushPalette">solidFill</param>
          <param name="charting.chart">column</param>
          <param name="charting.axisY.minimumNumber">20</param>
          <param name="charting.transparentBrushPalette.alpha">0.7</param>
          <module name="JSChart">
            <param name="width">100%</param>
            <param name="height">100%</param>
            <module name="Gimp"/>
            <module name="ConvertToDrilldownSearch">
              <module name="ViewRedirector">
                <param name="viewTarget">flashtimeline</param>
              </module>
            </module>
          </module>
          <module name="ViewRedirectorLink">
            <param name="viewTarget">flashtimeline</param>
          </module>
        </module>
      </module>
    </module>
  </module>
</module>
1 Solution

sowings
Splunk Employee
Splunk Employee

1) Check this answer to handle the charting.* parameters to handle the overlay (your may have to adjust your search as well to include a calculation of the average in order to plot the mean line. Your 'timechart' invocation currently produces only min and max).

2) I don't think that JSChart will support overlays like this; your advanced XML shows a <module name="JSChart" ...>, you'll have to change that to FlashChart.

View solution in original post

sowings
Splunk Employee
Splunk Employee

1) Check this answer to handle the charting.* parameters to handle the overlay (your may have to adjust your search as well to include a calculation of the average in order to plot the mean line. Your 'timechart' invocation currently produces only min and max).

2) I don't think that JSChart will support overlays like this; your advanced XML shows a <module name="JSChart" ...>, you'll have to change that to FlashChart.

sbnoobbb
Path Finder

Thanks !!!

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...