I'd like to get a distinct count of the date for each different client, and then divide the data by that distinct count....
eg.
01/07/2018a_client10002/07/2018a_client8903/07/2018a_client504/07/2018a_client4405/07/2018a_client5506/07/2018a_client8507/07/2018a_client4208/07/2018a_client109/07/2018a_client77
For a_client we see 9 unique dates, so first row would be 100/9 = 11.11
and then so one for each client (bare in mind the # of dates will be different for each client).
I'm struggling to to get either a distinct row count or date count in the first instance :-(
Appreciate anyone's help, pretty please :-)
Nicky x
Good morning
see the attached
returns this
this is pretty basic to tableau - if yo haven't seen the online training try the link Tableau Training: View Training Courses
Jim
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.
