Hi Joseph, some of this is built in I think.
Count Distinct is an option in Tableau as long as you have a data extract.
For the date, if you make a calculated field with this text:
- As long as you have accountID or userID on the view, it should pick up the correct date.
Could there be multiple accounts per user? Or multiple users per account? This could make it a bit trickier, but still possible.
There are multiple accounts for each user which is why it's a little tricky. Each user has a series of "activities" for each account in this dataset which get a date associated with them. I'm trying to get a distinct count of Accounts by user, and then associate that count to the max date of all the activities.
Thanks again for the help!
Okay, still shouldn't be too bad.
If you have an extract, you should be able to use something resembling this for the count of accounts per user.
str(countd([AccountID])) + " Accounts"
the max([Date]) should work fine as long as you have a user on the view.
Basically, I put User, Count Distinct AccountID, Max Date, and Sum(End Result) onto the view, and it displays more or less what you have in your example above. If you're meticulous, you can do some if statements based on the count distinct to determine whether there is one or more than one, and add or drop the 's' from accounts accordingly.