I am a Tableau 10.5 desktop user (no access to Server), and I'd like to know if there is a way I can use data in 3 different Excel worksheets and combine them into one worksheet in Tableau. Essentially I'm just using the sum of records, but I'll also need to do a Count Distinct. Is there a better way to handle this? I'm trying to use the data files I'm being given without having to do a lot of manual reformatting.
Ideally, I'd like to find a way to do a more traditional chart like the one below.