How to filter data by Previous Year Current date

[praveenAWS]

HI All,
Is there a way to filter the data by Previous Year current date (01/02/2023) . it has to pick the current date (Previous Year) automatically.

Thanks

[ErikG]

Hi @praveenAWS
Did you check out the relative filter?

BR

[praveenAWS]

HI ErikG,
Thanks for your reply. I am trying to show the client the total revenue for Current YTD and Previous YTD.
Previous Year filter condition shows the entire previous years value how to control that to YTD?

Thanks

[ErikG]

Hi @praveenAWS
did you checked out the post:

Previous Year YTD Aggregation functions

Hi ChenjingLyu, I hope below solutions will meet your requirements, kindly check these calculations Max Date: maxOver({your date field}, [ ], PRE_AGG) Between dateDiff(), addDateTime(), truncDate(), and extract() you can define whatever periods you want (and there are often multiple ways to do each one, these are just some proven examples). Please create Parameter ( Name it as AsOfDate ) by selecting fixed date option, then try below calculations Today: ifelse(dateDiff({order_date},${As…

BR

[ErikG]

Hi @praveenAWS
any update on your side?
BR