I would like to create a report (or ultimately a dashboard) that looks at a particular value (a status for a particular record (e.g. "new", "in process", "completed")). There is no data of the status at any particular time so all I can query is how many records are in each status at any given snapshot in time, but I would like to know where we stand and how these are changing over time. Is there a way to automatically run the report (e.g. daily) and have all of the prior results be part of the most current report?
I hope I explained this well.