Expression to show only The last 7 days

My Slices formula is showing items from the 7th day ago onwards, but I want it to show items from today to 7 days ago, where am I going wrong? Sorry for my english. 

([Data] <= (TODAY() - WEEKDAY(TODAY())) - 7)

0 1 202
1 REPLY 1


@Esmorais wrote:

WEEKDAY


I don't understand what you mean to accomplish by including this function.


@Esmorais wrote:

formula is showing items from the 7th day ago onwards, but I want it to show items from today to 7 days ago


I don't understand what distinction you're making.

Maybe you're saying that your slice includes items older than a certain date but you want items newer than that date? In case it's helpful:

([Data] >= (TODAY() - WEEKDAY(TODAY())) - 7)

Maybe you're saying that you have items with dates in the future that you want to exclude from the slice? In case it's helpful:

AND([Date] >= TODAY() - 7, [Date] <= TODAY())

  

Top Labels in this Space