Refine your search:

I have a search showing 288 results but the chart is not showing them all

I know timechart has a "limit" switch but it only works if you have a split-by-clause

Here is my code | timechart span=1d avg(field_Number)

this returns 288 days with a number for avg(field_Number) and a new number is added every day.
I would like a chart that shows all the days on the chart.

I am also trying to add a trend line with a look ahead to the timechart.

Thanks for any help.

Mike H.

asked 05 Mar '12, 08:48

hartfoml's gravatar image

hartfoml
2261219
accept rate: 36%


3 Answers:

OK Here is the actual search command

index=os sourcetype="df" | rex "T\s+(?<DiskUse>\d+)%" | timechart span=1d avg(DiskUse) AS "Historical % Disk Use" | convert timeformat="%Y%m%d" ctime(_time) AS Date | eval 25%_&_Filling=25 | eval Halfway=50 | eval DecisionPoint=70| table Date "Historical % Disk Use" 25%_&_Filling Halfway DecisionPoint

I run this once a week on a schedule

The results table is as is expected. I could not find a way to upload the tabke so i included several lines here but they are all the same. 281 results one for each day since i started monitoring disk use on the system.

I have attache a screen shot of the graph and it shows that the only thin i see in the graph is the start of recording up to about 40 days or 40 points. not all 281 points are shown.

Chart Table

link

answered 06 Mar '12, 08:05

hartfoml's gravatar image

hartfoml
2261219
accept rate: 36%

edited 06 Mar '12, 08:10

Sorry couldn't figure out the upload for this app

(06 Mar '12, 08:10) hartfoml

Ok I see, you're actually using 'table' to plot the results, since it's the last reporting command. In 4.3 there is a limit of 40 results plotted for commands like 'table'.

The good news is that in 4.3.1 we got rid of that limit (although with more than 80 results we hide the x-axis labels to prevent them from crowding), so upgrading to 4.3.1 should get the results you want.

(06 Mar '12, 21:28) Simon Fishel

OK great thanks for the help we are planing to upgrad this evening.

(07 Mar '12, 09:28) hartfoml

Would it be possible for you to post a screen-shot of this? It would help in reproducing if I could see the chart as well as the search results in table form, so I can tell what is not being plotted. Thanks!

link

answered 05 Mar '12, 10:38

Simon%20Fishel's gravatar image

Simon Fishel
30321
accept rate: 30%

Sorry I don't think the data like you asked would help but maybe i can explain better.

I have a search that reports one valy per day for 288 days. the days bucket is defined in the span=1d. so I have a tale with one collumb of 288 dates and one collumb of 288 asoceated numbers. when i put this on a graph i only get 100 dates and 100 assoceated numbers. as i understand it this is due to the default "limit" for the timechart function. the "limit" switch can be set to smaller or larger but only if you are useing the by clause like "count by something" or "this by that" so my problem is how to change the defult limit without useing the "by" clause or maybe i sould be useing the 'stats avg(field_number)' rather than the timechart

link

answered 05 Mar '12, 12:36

hartfoml's gravatar image

hartfoml
2261219
accept rate: 36%

I stil think the screenshots would be helpful.

I don't think the "limit" is the problem here. It should only apply when you are using a split-by to create multiple series, and then it limits the number of series not the number of points. With no split-bys you should be able to plot at least 500 points.

The best way to figure this out is going to be by looking at the chart and the corresponding results table so I can track down what's going wrong.

(05 Mar '12, 22:25) Simon Fishel

I tried as you said to upload but was unable to do so

(06 Mar '12, 08:11) hartfoml
Post your answer
toggle preview

Follow this question

Log In to enable email subscriptions

RSS:

Answers

Answers + Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×286
×34
×14

Asked: 05 Mar '12, 08:48

Seen: 1,087 times

Last updated: 07 Mar '12, 09:28

Copyright © 2005-2012 Splunk Inc. All rights reserved.