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

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

Aspiring_Developer — Thu, 26 May 2022 07:53:24 GMT

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

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

justISO — Thu, 26 May 2022 08:26:26 GMT

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

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

Aspiring_Developer — Thu, 26 May 2022 09:23:35 GMT

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

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

justISO — Thu, 26 May 2022 09:42:19 GMT

just add additional condition

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