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

Hi @praveenAWS did you checked out the post: [image] Previous Year YTD Aggregation functions Question & Answer Hi ChenjingLyu, I hope below solutions will meet your requirements, kindly check these calculations Max Date: maxOver({your date field}, [ ], PRE_AGG) Bet…

Hi @praveenAWS Did you check out the relative filter? [IMG_20240201_205138] BR

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

Hi @praveenAWS any update on your side? BR

How to filter data by Previous Year Current date

Q&A

ErikG February 21, 2024, 11:05am 4

Hi @praveenAWS
did you checked out the post:

Topic		Replies	Views
Get previous year value with additional filters applied Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer	5	127	December 14, 2024
Previous Year YTD Aggregation functions Q&A analysis , quick-sight , calculations	1	1716	April 28, 2023
Datefilter with last available date of previous year and current date Q&A filters , quick-sight	2	530	March 24, 2022
Filter dashboard by date field year values only Q&A developer , quick-sight , qls-community	4	258	December 2, 2024
Calculation of Full Sum of previous year Q&A calculations , Business-Intelligence-Engineer	2	27	November 11, 2025

How to filter data by Previous Year Current date

Related topics