Time filter is not working

Elastic Stack Kibana
#1

Hello,

this is our Canvas workpad:

canvas
canvas1614×628 78.2 KB

As you can see time filter on top of the page does not work correctly regarding the elements presented in the data table.

This is the expression of the time filter:
timetable_expression

This is the expression of both data tables:
expression_syntax

Can it be that the time-stamp pattern is not correctly recognised?
We can order the rows according to the timespan in the Discover view:

discover
discover1145×558 34.7 KB

What can we do so that the data tables are working correctly according to the chosen time span?
Moreover, I would like to know if the Canvas view is refreshing automatically when changing the time filter element.

Let's say that we want to delete the time filter element.
However, we still want to present the correct elements for the timespan between 2020-01-20 and 2020-01-31 in the data tables.
How do we need to edit the code in the expression editor?

With best regards

ROW_NUMBER in ES SQL
Convert DateTime to integer
#2

You might have a syntax issue in the expression of the time filter?
colulmn="\@timstamp\"
Why the duplicate quotes?

Also, there is a bug with sorting, but with other visualisation than tables.
Can you sort it in the dashboard feature?

Bug - https://github.com/elastic/kibana/issues/62770#issuecomment-713733516

#3

You are right!
There was a syntax issue in the expression of the time filter.
I fixed it. Still, the problem is present.

In order to better explain what is going on, I recorded a video.

The data table does not automatically update when I change the time range.
The data tables update when I click on the "eye" symbol.
Is there a way how the tables automatically update when I change the time range?

Moreover, I would like to ask what I need to write in the expression editor of the data tables in order to filter the data tables between two given dates when I delete the time filter element?

#4

@AClerk

could you respond to my answer, please?

#5

@Treki
Not sure what you are trying to achieve.
The filters are not meant to be changed frequently.
If you want the user to interact with the filters, try creating a data table in the visualization feature and then import it to Canvas. You will have a user filter

image
image951×346 15.8 KB

In the ESQL statement you can add a where clause and date conditions.

Select
 ...
...
Where date >= <DATE> and date < <DATE>

You can also use NOW(), INTERVAL, etc.

#6

@AClerk

Thank you for your answer!

Have you watched the video?
The data table has not updated itself after I changed the timespan.
An update only occurs after I clicked on the "eye" symbol.
Is this a bug?

#7

Not sure.
Might be a bug.
Need to ask an Elastic team member.
Cheers

#8

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.