Need help in creating a refreshing date range filter for a line chart

1

I made a line chart with the horizontal axis representing Month within 1 year, and the vertical axis representing expense.
The problem is that the current line graph would display the expense in 2025 even it’s 2024, so i wanted to create a custom filter for the graph to only display the current year expense and will update automatically when it’s 2025 and display the relative expense set in 2025.

2

If your month is based on dates in your table and the date column is called (for example) ExpenseDate, the filter should look like this:

Expensedate.year() = today().year()

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.