see the attached
this is pretty basic to tableau - if yo haven't seen the online training try the link Tableau Training: View Training Courses
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.
date count.twbx 33.2 KB
1 of 1 people found this helpful
Jim's post above works. Posting an alternative using table calcs in case you have a large dataset and want to avoid using LOD and going against the database.
Here's how I calculated number of dates per Client:
Or seen in the sheet:
Then I simply combined the new measures to create the new value desired and placed in the Text pane:
Attached a 10.3 twbx for your viewing. Hope this helps!
Thanks Bryce, Jim gave me answer first but I'll probably use your method as it's a huge Dataset.