Hello Everyone!!!
I want to include a summary table in my dashboard that compares data for current year with prev YTD.
So far I am able to include only YTD as I am filtering the data using relative YTD filter.
I am looking for something like this:
CategoryCurrent Yearprev YTDNo of Requests1000015000% of deliveries made on time9395% of deliveries marked late57
It would be great if somebody had an idea about how can I proceed.
Thanks in anticipation!!!
5 answers
Previous YTD
IF [Order Date] >= DATE(DATETRUNC('year',DATEADD('year',-1,TODAY()))) AND [Order Date] <= DATEADD('year',-1,TODAY()) Then Whatever END
Current Year YTD (any one of below should work)
- IF [Order Date] <= TODAY() AND
DATETRUNC( "year", [Order Date]) = DATETRUNC("year", TODAY() ) THEN Whatever END
- IF [Order Date] <= {MAX(order date)} AND (Year ([Order Date])=Year({MAX(order date)}) Then Whatever end
