Is it possible to adapt the conditions of date filters, so that TODAY() is a dynamic field that changes when the visualisation is refreshed? Please see an example below:
- I have a list of appointments for different staff, that I want to see in a bar chart.
- I don’t want the bar chart to include appointments in the future, as I want the focus to be what has actually happened
- I can use a condition of appointment_date before TODAY
- When I refresh the data the following day, it will have previous date as the condition, rather than current date