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!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...