Custom filter dataset - custom sql

Question & Answer
, ,
1

HI

I should set up a dataset in sql that always gets the data from the previous day (yesterday).

I need to do it on the dataset and not on the analysis

Andrea

2

Hi @andreab,
are you looking for an custom SQL or dataset filter?

In the dataset you cant apply “relativ” filter so you need to got to SQL
grafik

SQL should be something like.

Select * from whatevertable where data = now()-1

BG

3

Hi @ErikG
thanks for solution,
I needed the custom sql