I have an executive dasboard where we display our main KPIs in a reportlet as well as a MTD trend chart. In the stoplight reportlet I have to put in the low / high set points based on last month and last year performance for that metric. I also have to set a note at the top of each page of the dashboard that displays the set point date and value from the previous period. It would be nice to have a way to do this in the reportlet.
So, below, it would be great to have a way to set the thresholds based on last yesterday, last week, last month or last year's performance for both high and low thresholds. And to surface those values and date ranges either in the reportlet or in the header or footer of the dashboard page it is being displayed on with a footnote reference.