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!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

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