Past 7 days data (change time stamp)

Hey, i need past 7 days data from โ€œchange time stampโ€ column.
Tried this but doesnt workโ€ฆTODAY() โ€“ 7

0 4 294
4 REPLIES 4

The column name is not enough
You should tell us the column type and also show some values.
Moreover, you should explain what โ€œdoesnt workโ€ means exactly.

in this picture is count (down) and name of student name (left blue rows).

When students participate to class, count is 1, She/he goes same class second time, count is 2โ€ฆ and so on, and it works.
But, now count calculated is from january 1. 2021, toooo long way back and too many counts. So I need only week (7 days) data. For example this day - 7 or something like that. So i think we need -7 data from colums โ€œchangetimestampโ€โ€ฆ
slicecolums are very simple: name, changetimestamp, and class (enum list).

Heres where i put code for this rule filter โ€” ImgBB

Oh dear.
If this added โ€œ[Date] = TODAY()โ€ ill get data from today, and its better than ALL data from 1.1.2021โ€ฆ
But how can i get previous last 7 dayzโ€ฆ

There are several examples in the Date and Time Expressions document referenced above that address your need.

Top Labels in this Space