topic Re: last 30 days in App Development

last 30 days

Anonymous — Sun, 07 Jan 2018 05:49:01 GMT

Hi All,

How to filter last 30 days sales using set analysts.

Thanks,

Krishna.

Re: last 30 days

pradosh_thakur — Sun, 07 Jan 2018 06:38:47 GMT

something like

please check your date format and apply accordingly

sum({<datefiled={"=datefield>=max(datefield)-30"}>}sales)

sum({<datefiled={">=$(=max(datefield)-30)<=$(=max(datefield))"}>}sales)

Re: last 30 days

luismadriz — Sun, 07 Jan 2018 11:31:58 GMT

As Pradosh says, just change max(datefield)-30 to date(max(datefield)-30). If you need to, force the date format to suit, for example date(max(datefield)-30,'M/D/YYYY')

I hope this helps,

Regards,

Luis

Re: last 30 days

luismadriz — Tue, 09 Jan 2018 10:30:24 GMT

Hi Krishna,

Please remember to close the thread by marking the correct and helpful replies,

Many thanks,

Luis

Re: last 30 days

satheshreddy — Tue, 09 Jan 2018 10:34:13 GMT

Hi Krishna,

you can use below exp

count({<Date={=date(Max(Date)-30,'DD-MM-YYYY')}>}id)

Regards

Sathish

Re: last 30 days

Chori — Mon, 20 Jul 2020 15:52:27 GMT

Creo que todas las propuestas fallan si no hay registros en el último o últimos días.
Es decir, toman 30 días a partir del último registro. Lo que pide entiendo que es: 30 días para atrás desde hoy o ayer.