Balancing analysis of multiple years by filtering through the same month/day as today
Topics in this example
1) With a line chart, by placing Year(Order Date) on the Color shelf and Month(Date) on the columns, you can easily compare multiple years on the same pane of the graph. Just use Running Totals from the Quick Table Calculation dialog.
2) If this were real-world data, you would likely want to keep data through today; otherwise, prior years would likely be much higher since they are based on a full month while this year’s latest month is partially complete, unless it is the last day of the month!
3) By creating a calculated field that can check if the month/day is before today’s month/day and placing it on the filter shelf and selecting True, you can keep year-to-date data