James- What are these datasets? Excel spreadsheets? Database tables? Either case you should be able to JOIN them using a common field (eg: EmployeeID) right? Are dates the only dimensions that you have?
Hi there -
This is a mysql database, sorry I should have included that info. Each row has the EmployeeID already in it. There are more elements in the dataset than just those 7, but for all intents and purposes those are the only ones I'm using and I can filter the other ones out if need be.
So I have four dimensions - EmployeeID, DateWorked, DateBilled, DatePaid
I have three measures - AmountWorked, AmountBilled, AmountPaid
Okay, this is something I'd do- I'd code this up in SQL and flatten (de-normalize) this out in the database. JOIN those 3 tables ON EmployeeID, with whatever columns you'd like. Then in Tableau, using it's natural date aggregation, you can just roll this up into weeks. So, for example my week ending is a Sunday, which makes my week start Monday. From date properties I would make this change, then create a calc field 'Week End Date' - which rolls days into 7 day buckets. So I'd have Week End Dates - 10/14, 10/07, 09/30 and so on. You can create this using 'DateWorked'.
For these dates, I'd have amounts assigned.
If you don't have permissions to create a table in database, then JOIN these in Tableau and let Tableau take care of aggregation.
If nothing works, please mock some data and attach, we'd like to see how your data is structured.