Hi,
The DB has 2 fields: dates (from Jan 2017) and Income.
There is a variable of max_month (for instance - "Sep").
There is A Bar Chart: A bar of summarized income for each year.
I would like to place a Button that switches between 2 Bar layouts:
1. No Filters: A Bar for every year - previous years gets full year income, current year - only until the last month in DB. The comparison between full Year and Partial Year is something Not Fair...
2. A filterd Bars to the Range off month between months Jan and the variable month (max month in DB <> max calendar month). To show the same period every Year.
Unfortunately I could only put "=" to allow the user to pick the last month itself.
Is there A solution for my problem?