I have an Object that contains KPI values by month (month represented by the date of the first day of the month). In a Dashboard, I'd like to show a widget that provides the value of a KPI from 4 months ago (which updates automatically every month). In date filters, however, "Last month" and "Last N months" is available, but not "N months ago".
The only workaround I can come up with for now, is adding a date field to the object that represents "month - 3" so I can filter on that one with "previous month" but I don't think that's very discoverable. Does anyone see a better solution?