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!

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...