Re: Y'Day,LastWeek, MTD,QTD,QTD-1,QTD-2,QTD-3,YTD,LYTD In Filter Pane
Not sure what is going wrong but that depends on the data.
But I dont believe you can do it this way with a single column. because date would fall into multiple categories not just one. e.g. Yesterdays date should also be in YTD . but if you do it like this approach it will included in just category.
In my opinion you will need to an approach like below.
1- The selection will be an island table
2- The measure you need create in such a way that a different set analysis is applied on each selection
you can either do full set analysis with date condition or create separate flags for each condition
e.g. if((Num(CASE_CREATEDDATE)= Num(Today()-1),1,0) as YesterdayFlag
, if(Year(CASE_CREATEDDATE)=Year(today),1,0) as YTDFlag