Interval and timestamp does not work as expected

Redcxx · September 3, 2020, 8:40am

Hi currently it is Sep 03 09:38 here, the explore tab shows that there is data of timestamp Sep 02 10:03, I set the interval in TSVB for 1d but there is no data, in fact it shows nothing for 2d as well. The data appear when I set it to 3d. May I know what is going on?
Thanks!

The visualization:

The explore tab:

wylie · September 10, 2020, 11:11pm

The most likely thing that you're seeing here is that TSVB, by default, is picking the most recent bucket only. You can see this in your screenshot as "Data timerange mode". So for example when I choose an interval of 1d, TSVB might pick "30 minutes" and show only the most recent 30 minutes of data.

You might be expecting "entire time range" which is an option.

stephenb · September 11, 2020, 2:56am

Hi @Redcxx as @wylie it most likely has to do last bucket vs entire time range.

I just had a fairly extensive conversation on this / very similar topic here

You might find a deeper explanation there

Redcxx · September 15, 2020, 1:48pm

Hi @wylie and @stephenb, thanks for the reply!

In the link you send me I found that:

"This setting controls the timespan used for matching documents. "Entire timerange" will match all the documents selected in the timepicker. "Last value" will match only the documents for the specified interval from the end of the timerange."

So this means that my setting should match the last value of my given interval 1d which should capture all the data that I uploaded for the last 24 hours right? So why am I not seeing any data? Did I missed anything? Thanks

Redcxx · September 15, 2020, 1:51pm

Hi,

Thanks for the reply, I want to aggregate on the data from the last 24 hours, if I were to choose entire time range, this will not do what I want. I want the data from last 24 hours, is there a way to do that? Thanks

stephenb · September 15, 2020, 2:49pm

@Redcxx

Hi I am a little confused what you want. Can you please describe want you are looking for a bit in a bit more detail?

Do you want a Line or a Single Metric?

Say you collect metrics at 10s interval

Do you want a Single Number that Aggregates say Average CPU for the entire 24 Hours?

The following example give the CPU Avg over the entire 24 hours as a single Number

Redcxx · September 20, 2020, 8:49am

Thanks for replying
I mean can I have some kind of time filter without using the time filter on the top right hand corner?

stephenb · September 22, 2020, 3:59am

Hi @Redcxx

I am not quite clear what you are asking for.

For time series data the Time Picker in Top Right sets the time range for the visualization and / or dashboard.

Can you explain in a little more detail what you are looking for.

Example

I want to put a visualization on a Dashboard where the dashboard time range (Time Picker Top Right) is last 2 weeks but for a particular visualization I only want the last 24 hours.

Depending on what you are trying to accomplish you can save the Time Picker either relative or absolute as part of the visualization...

CORRECTION : Today on a dashboard you CAN set a different timepicker for each visualization See Below

BTW Have you tried Lens yet for visualizations?