Is there any way you can upload a sample set of anonymized data to show what you're working with? It will make it easier help you in shaping it to a useable format in Tableau which solves for what you need. Else, we are going to be suggesting things that will become trial and error.
Please find attached the spreadsheet I'm working with.
The POS Details for Tableau tab has the sites and the dates on which they have been created. The POS Reports for Tableau has all of the reports as they have come in. The initial Report for a site has the same date/time as the POS creation date.
Original data didn't break down the dates in to weeks or months, but I have used Excel formulas to get that information to make it easier for analysis in Tableau.
If you could have a look I'd be very grateful.
Many thanks... Shaun
POS Sites Data.xlsx 572.0 KB