Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in Date filed i have years from 2010 to 2040 but i want only from year(today()) to next five years.
i have tried
year( if("Date"<=AddYears(Today(),5),"Date")) as RequiredYear.
But this logic is giving years from 2010 to 2025.i am expecting 2020 to 2025.
Hi,
You can write this script
If(Date<=Year(Addyears(today(),5)) and Date>=Year(Today()),Date) //write this expression in filter expression
Hope this will help.
Regards,
Prashant
You could use a where clause on your load like this:
Where Year(Date) >= Year(Today()) and Year(Date) <= Year(Today()) + 5;
-Rob
Thank you Prashant, it is working fine. but some issue with pie chart when i use calculation in Filter Expression pie chart is not working. i load logic in script and used in fort end.
Thanks it is working.