Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to filter last 30 days sales using set analysts.
Thanks,
Krishna.
something like
please check your date format and apply accordingly
sum({<datefiled={"=datefield>=max(datefield)-30"}>}sales)
or
sum({<datefiled={">=$(=max(datefield)-30)<=$(=max(datefield))"}>}sales)
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
Hi Krishna,
Please remember to close the thread by marking the correct and helpful replies,
Many thanks,
Luis
Hi Krishna,
you can use below exp
count({<Date={=date(Max(Date)-30,'DD-MM-YYYY')}>}id)
Regards
Sathish
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.