Splunk Search

charting customization

splunkatl
Path Finder

In our search the values of transaction duration field comes in Milliseconds those could be like 41,42,50,300,500 and goes upto to 10500,12000

I need to create the chart by allocating bins_array like in excel

0-50 --I want show transactions took only between 0-50 secs
50-100--I want show transactions took only between 50-100 secs
until to all 10,000 ,20,000

Here is search

index="xyz" | chart count by TRANSACTION_DURATION span=500

<?xml version='1.0' encoding='utf-8'?>

<dashboard>
  <label>TRANSACTION_DURATION</label>
  <row>
    <chart>
      <searchName>TRANSACTION DURATION</searchName>
      <title>TRANSACTION DURATION</title>
      <option name="charting.axisTitleX.text">DURATION(MS)</option>
      <option name="charting.axisTitleY.text">TRANSACTIONS</option>
      <option name="charting.chart">bar</option>
      <option name="drilldown">none</option>
    </chart>
  </row>
</dashboard>

can some one give suggestions how can i create bar chart to show my results in the span 0-50?

Tags (2)
0 Karma

lguinn2
Legend

May I suggest that you re-scale the field, since you are looking for results in seconds?

index="xyz" | 
eval duration = round(TRANSACTION_DURATION/1000,0) | 
chart count by duration span=50

You would also need to update the axisTitleX.text in the XML to DURATION(SEC)

BTW, if you want to show it in MS, then I think your span needs to be 50000 not 500.

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...