Hello, I have a table insight in my dashboard. I would like to filter its content with entries that has a date >= "2024-7-28" for example. How can I do it ? From what I see, I can only select a specific range with date filter, but not

From 2024-7-28 to Today

.

Hi Thibault, Unfortunately, we do not have this feature (explicit) but we can accomplish this by creating a Metric, for example:

SELECT SUM({fact/value})
WHERE {label/DATE.day} > "2024-7-28" AND {label/DATE.day}  <= THIS(DAY)

With this all the shown entries in the insight will show according to the specified date range in the metric. Please let me know this works for you.

Thank you Mauricio. It works, but the thing is that I don't want to show the metric in my table. I am only showing attributes, I just want to display a table view of what I have in a db table. What I will do is in my ETL pipeline add an extra attribute that indicate if the row date attribute is older than 2024-7-28 and filter the insight with this attributes.

Hi Thibault, it seems your date

2024-7-28

is fix. In that case, and if you have the chance to add an extra attribute previously. I would say is a good approach. Please, let us to know if you need further assitance