charting customization

Question

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?

Answer 1

0

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.

link

answered 21 May '12, 10:56

lguinn ♦
10.9k●5●7●23
accept rate: 28%

charting customization

Follow this question

Splunk Resources

Related questions