Question about displaying current month data on dashboards
We have a sheet tracking monthly metrics and I would like to find a way to flow only current metrics onto a dashboard. My goal is to have the dashboard be a snapshot of the prior month metrics. So if I were viewing the dashboard in June, I'd see metrics for May for several different data points.
I'm thinking maybe the only way to do this would be to do a report and only bring in the prior month's column? And then each month have to go in and update which month that is?
Or is there some other way I could accomplish this goal?
If it is relevant, the sheet is set up with each metric as a row and the columns are the months.
TIA for your help!