3 Replies Latest reply on May 14, 2017 7:05 AM by Norbert Maijoor

    Hi Guys,

    nawazuddin mohammed
    nawazuddin mohammed May 13, 2017 10:10 AM

      I have data in two different excel files,first file has four columns they are user name, user id, role and which project name. Second file contains date, user id, project.Every time tableau user access tableau server,new record created in Second file with date time and their respective user id.My question is how do i know % usage of each user when compare to other users in tableau server.

      • 136 Views
      • Tags:
        • 1. Re: Hi Guys,
          Norbert Maijoor
          Norbert Maijoor Ambassador May 13, 2017 11:02 AM (in response to nawazuddin mohammed)

          Hi nawazuddin,

           

          Find my approach based on count & "Quick Table Calculations" as reference below and stored in attached workbook version 9.3 located in the original thread

           

           

          1. Count(count([UserID_Usage])

           

          2. Count > right click> textmenu > Quick table calculation > Percent of total

           

           

           

          Regards,

          Norbert

          • 2. Re: Hi Guys,
            nawazuddin mohammed
            nawazuddin mohammed May 13, 2017 1:32 PM (in response to Norbert Maijoor)

            Thanks for instant respond Norbert, my requirement here is what is %usage of each user when compare to other users for a given project.In the below tableau work i joined two data sets on common column called project,my number are correct when i just look at project called Drive train. However, when i look at numbers for two projects it doesn't seem to give right answer.

            Can you please go through the below twbx.

            • 3. Re: Hi Guys,
              Norbert Maijoor
              Norbert Maijoor Ambassador May 14, 2017 7:05 AM (in response to nawazuddin mohammed)

              Hi Nawazuddin,

               

              The figures reflect the data sources.

               

               

               

              The question is. e.g. Why does Jn have 3 entries for Project Drivetrain for one date?

              I assume an User_ID can only have one role in a project on one day.

               

              Regards,

              Norbert