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

    Hi Guys,

    nawazuddin mohammed

      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.

        • 1. Re: Hi Guys,
          Norbert Maijoor

          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

            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

              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