I know Tableau doesn't create data and this is more of a reporting type question than analytics, but is there a good way to go about saving workbooks to reference later for historical purposes? I've attached a workbook showing generally what I'm trying to accomplish, using random excel file data as a test. I'm trying to summarize multiple workbooks and then plot those out on a line graph by customer, issue category, and time, with the ability to drill-down into by customer / issue category, and then within those categories, show the tables of data so each item can be resolved individually later. But for past reports I only care about showing the totals & subtotals of records for each type of issue.
For example, if I want to keep track of all system issues, I could do queries to error logs to pull issues by type within a set date range and then total those up. So say there were a total of 100 API failures, 50 database locks, and 2 hours of server downtime in November. For the current report, I'm trying to set it up where you could see an overall summary of issues by category with historical trends, then you could click into "System" and see the categories of "API, "Database", and "Server" and see the subtotals of issues by each (100, 50, and 2 for the past month). Then if you wanted more detail on the server outages you could click that subcategory and see the 2 records for the downtime in the current month and a trend of server downtime over the last X months. And then if you clicked into the current month you'd see the logs showing downtime start/stop, affected servers, and anything else pertinent. Doing this with current data seems very doable, but the historical aspect of it is troublesome.
Here's what I've come up with as potential options:
1.) Create history summary tables in each data warehouse of each report and schedule jobs to update them monthly
2.) Export the workbook summary data only into an excel file or something and reference a folder containing those
Option #1 seems the most consistent and least maintenance, but maybe more work to get setup. It also seems like I'd need to recreate all my Tableau joins in SQL to get the summary numbers, which could lead to mismatches in the calculations. On the other hand, option number 2 seems manual and that has its own issues, especially since I'm trying to compile the same types of data across multiple databases. Any suggestions?
I've attached a rough example workbook of what I'm trying to show.
Summary Mockup.twbx 87.0 KB