Duplicate Dashboard but with Date Filter
I am looking for ideas on creating a filter for date ranges in a dashboard. I want users to view the available data in a dashboard by quarter (three months of data).
I have a dashboard built that contains all of the data for 2021 that is fed from a single sheet. I intended to continue adding rows to the same sheet for 2022.
I believe that there is NOT an option to filter by date within the dashboard itself, but is there an easy way to create secondary dashboards (by quarter) that are identical to the original but only display data for a specific date range?
I think I would have to create a new sheet that feeds from the original sheet but only includes data for my specific time frame - I'm not sure how to do that (or if it's possible).
Any suggestions would be much appreciated!
John Stanik RN, BSN