How can I group the last 7 days to compare it to the 7 days before that? I am trying to get the rolling 7 days and compare it to the previous 7.
Can you try using this formula? This will make it so you have two separate groups for each week!
If([Date] > DateAdd(“day”, -7, Today()), “L7D”, DateAdd(“day”, -7, Today()) > [Date], “L14D”)