How do I show the last 7 days in a formula?

3

Hi @Joseph_Wood,
welcome to Coda Community :handshake:

If I correctly got your point, the formula could be something like this:
[YourTable].Filter([DateColumn]>= Today()-Days(7) && [DateColumn]<= Today()).[Step].Average()

However, if you could share your document - or a sample of it - (through “share” link on top-right) it would be easier to figure out a solution.

I hope it helps.
Cheers!

1 Like