I have a Tableau report linked to our database. Based on the database data, I created a report that shows how many employees we have at the moment. I would like to create a monthly overview of the evolution of the employees. The problem is, that from the database I can get only the current situation, not historical data.
Every month, I have to copy the current number of employees to an Excel file and use this file as a data source for the monthly overview.
Is there any Tableau feature that can do this for me? I am basically trying to create a snapshot of current numbers and keep the snapshot somewhere for future use.