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.
Thank you,
Bruce
You need to create a table and save the values each time you run the report with the date and time of the run.
Without the previous values and a value to trend by you can't build a trend report.
You could just save the run number.
mlmcc