Show data only or last 35 days in straight table without any set expression

[Aspiring_Developer]

Hi All,

I have below straight table and it does not have any measures in it.

Dimension - EMS_Report_Date

I need to restrict the first column i.e EMS_Report_Date in order to show data only for last 30 days. I know the way to achieve it with expression but here I don't have any measure so I'll have to restrict the EMS_Report_Date dimension but not able to do that.

Can anyone please help ?

Thanks in advance

@sunny_talwar

[justISO]

Hi, maybe instead of just 'EMS_Report_Date' put simple

=if( EMS_Report_Date>=date(today()-30), EMS_Report_Date)

and uncheck 'Include null values' in this fields properties

[Aspiring_Developer]

Hello @justISO 

Thanks for your response.

My EMS Report date has data till December .

I wish to show data till current date only .

Thanks in advance

[justISO · Accepted solution]

just add additional condition

=if( EMS_Report_Date>=date(today()-30) and EMS_Report_Date<=today(), EMS_Report_Date)