Date Filters - Page Level / Card Level
l have some data like below :
and so on till Nov 30th (Daily Data)
Card level : I have used all time data and trying to get the sum of count according to the page filter (filter card).
If the page filters is from Apr 10th - Sept 10th
I want to get the data from the month of August (last full month), July ( Last full month -1)
Some more cases: Page Filters: Dec 1st - Jan 13th - Need values of Dec and Nov
How to write a beast mode code to get the data according to the page level filter( another filter card )
(CASE WHEN MAX(MONTH(`Date 1`)) = 1 THEN (CASE WHEN MONTH(`Date 1`) = 12 AND YEAR(`Date 1`) = MAX(YEAR(`Date 1`)) -1 THEN 'Yes' ELSE 'No' END) ELSE (CASE WHEN YEAR(`Date 1`) = MAX(YEAR(`Date 1`)) AND MONTH(`Date 1`) = MAX(MONTH(`Date 1`)) -1 THEN 'DblYes' else 'DblNo' END )END)
The logic in the italic case condition is not working. Please help me out.