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!

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...