Set analysis - filter only records from the last 30 days

[EliGohar]

Hi

I'm trying to build a table which will filter only records from the last 30 days.

Here's a screenshot of what I'm trying to get (from left - the raw data, right - the desired table after filtering):

I tried this measure's expression:

max({<TIMESTAMP={">=$(Date(Today()-30,'DD/MM/YYYY'))"}>}Timestamp("TIMESTAMP",'DD/MM/YY hh:mm'))

but it seems to ignore the -30 part, it actually brings me all the records no matter what I'm defining after the "-" minus sign.

Any idea why?

[David_Capan]

When using set analysis, the date fields in your set expression need to have the same format.  Try this:

max({<TIMESTAMP={">=$(=Timestamp(Today()-30,'DD/MM/YY hh:mm'))"}>}Timestamp("TIMESTAMP",'DD/MM/YY hh:mm'))

[EliGohar]

Thanks @David_Capan , however, when trying your expression on my environment I got no results in the table.

Also tried to return all the timestamp which is lower than today using this expression:

max({<TIMESTAMP={"<$(=Timestamp(Today(),'DD/MM/YYYY hh:mm'))"}>}Timestamp("TIMESTAMP",'DD/MM/YYYY hh:mm'))

Thanks,

Eli.