Please see the attached
using your data the way it is structured the only common field is Date
so I joined the data on that field
that makes the calculation a little messy
to avoid double counting visits this is the min count by day
and this becomes the %
the first mart puts the correct value in the total - the last is the day by day percent
they return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
dogs and cats.twbx 39.4 KB
As Jim points out - when you are joining data like this you need to find a common field. Simply drag each sheet into Tableau, and set the join calculation (so Day = Date). I would also encourage you to think about how you label the data headings before you import it to Tableau. If you were to set both columns in both sheets to "Date" lets say, Tableau would recognise these as the common field, and make the join automatically.
Please mark Jim's response as correct. I've marked as helpful.
many thanks jim for your thoughtful response - much appreciated.
i also got it to work on the full data - think i also have some homework to do in terms of understanding some more basic nuts and bolts in tableu - need to watch some more intro videos
The training videos on the Tableau support site ( Tableau Training: View Training Courses ) are very good and organized by category and topic within category
they ar 3-5 min each and build on one another
One of the issues with your data is that one of the files is aggregated at the day level the other is disaggregated at the day level - not the best practice but it may be what you have
Glad to help out