Removing yesterday data from ETL

A_Benincasa · 2024-01-05T13:56:24+00:00

There was an error rendering this rich post.

Good Morning,

I want to remove yesterday, so Day - 1, from our data due to over reporting on the previous day. What ETL tile should I use, I'm thinking there is a formula, but there is also a date tile

Find more posts tagged with

Accepted answers

marcel_luthi

You'll use a FILTER tile applying that to the date field you want to filter out. Another option is to use a FORMULA tile to create a column that will flag if the date field is yesterday or not CASE WHEN column = TODAY() - 1 THEN 'Yesterday' ELSE 'Not Yesterday' END(or something along that line) and filter at the card/dashboard level, so that way your data will always be complete and you're only narrowing down at the display level.

GrantSmith

You can use a filter tile with a formula and the CURRENT_DATE() function:

`Date` < CURRENT_DATE() - 1

All comments

marcel_luthi

GrantSmith

You can use a filter tile with a formula and the CURRENT_DATE() function:

`Date` < CURRENT_DATE() - 1