topic Timechart cuts off last time value in Dashboards & Visualizations

Timechart cuts off last time value

A_VA — Wed, 30 Oct 2024 16:33:46 GMT

Afternoon, Splunkers! Timechart is really frothing my coffee today.

When putting in the parameters for a timechart, it always cuts off the latest time value.

For example, if I give it a time window of four hours with a span of 1h, I get a total of four data points:

12:00:00
13:00:00
14:00:00
15:00:00

I didn't ask for four data points, I asked for the data points from 12:00 to 16:00. And in this particular example, no, 16:00 isn't a time that hasn't arrived yet or only has partial data; it does this with any time range I pick, at any span setting.

Now, I can work around this by programming the dashboard to add 1 second to the <latest> time for the time range. Not that huge of a deal.

However, I'm left with a large void on the right-hand side of the time range. Is there anyway I can fix this, either by forcing the timechart to show me the whole range or by hiding the empty range?

Re: Timechart cuts off last time value

ITWhisperer — Wed, 30 Oct 2024 17:08:18 GMT

The time range 12:00 to 16:00 is for timestamps greater than or equal to 12:00 and less than 16:00 i.e. you don't get times beginning 16:00, so you are getting what you asked for. When timestamps are binned by the timechart command, all timestamps are taken back to the beginning time slot they are binned in.

What would you expect to be in the 16:00 data point (as your earliest and latest values have not included any events beyond 16:00)?

Re: Timechart cuts off last time value

A_VA — Wed, 30 Oct 2024 17:14:21 GMT

Well, the chart takes up the space needed for data points from 12:00 to 16:00, but since there isn't any data in the 16:00 bin the graphic stops at 15:00 and leaves a void where 15:00 to 16:00 would normally be (if you cut a chunk of time out of a larger graph, that is). That space is 1/4th of the time chart panel with a four-hour window. It's a third with a three-hour window.

Is there any way to eliminate that void and stretch the chart across to fill the space?

Re: Timechart cuts off last time value

ITWhisperer — Wed, 30 Oct 2024 17:29:07 GMT

Essentially, it is a matter of interpretation of the chart - it could be argued that the "space" between 15:00 and 16:00 represents the events in this time (hence the space in the chart graphic). You could use a column chart to show the space "occupied" with a graphic.

Re: Timechart cuts off last time value

A_VA — Wed, 30 Oct 2024 17:53:39 GMT

You know? You're right, I hadn't looked at it that way. Still don't like it.

Thanks.