Comparing Last 7 Days to the 7 Days Before That

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.

Hey Zachary!

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”)