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)
@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())
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |