Charts - Limit to the last 7 days

Hi there!

I would like to limit the number of days displayed in a bar chart to the last 7 days (including today).
Does anyone know know how to play with the filters to do that please?

Many thanks!

Add a math column in your data editor which calculates number of days between today and the date in your database.
Using this column add a filter in your chart data which says no of days is less than or equal to 7

4 Likes

Manu thanks!

1 Like