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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...