Forum Discussion
Charting Monthly Data from different tables
So every month I receive updated data in new tables. I am really struggling to layer those data points together so I can show trends on a month-to-month basis. Do I need to add a column to each month...
Epearson, you're on the right track.
At a high level:
1) Add a column representing the date and populate it. This can be at the source (recommended) or you can manually enter it each time you load new tables/data. In most cases you want this column's type as Date.
2) Import all tables/data into one big table/dataset.
3) Build Measures/KPIs/Visualizations off the big table/dataset.