1 Reply Latest reply on Jun 29, 2018 3:33 PM by Mark Crabtree

    Combining 3 data sources on 1 Worksheet

    Teresa Wright

      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.

       

      screen shot 1.gif

       

      Ideally, I'd like to find a way to do a more traditional chart like the one below.

       

       

      screen shot 2.gif

       

      Thanks a lot for any suggestions you may have!