Filter Out Current Week in WoW Card
Hi, I'm creating a Period Over Period card that displays number of tickets created as a week over week comparison. I'm running into an issue:
I don't want to include the current week since the results are incomplete.
- When I use Date Range = This Year, Graph by = Week, and Compare to = 1 Week ago: The Card includes all 52 weeks of the year, even though 14-52 are blank.
- When I use Date Range = YTD instead - it will include the current week. I tried filtering out the current week using a beast mode comparing YEARWEEK('date') and YEARWEEK('SYSDATE()), which get's rid of the current week in my YTD but not the comparison (1 week ago).
Is there a better way to exlucde the data from the incomplete current period from these PoP cards?