6 Replies Latest reply: Jan 30, 2015 6:23 AM by Sunny Talwar RSS

    Accumulate diferents values

    dcd dcd

      hello

      I have a table with two fields date and user that have logged in an application to show a document, there is 6 diferents users, i need to show a line chart  with date as dimension and calculate how many diferents users day by day logon in the application to read the document but in accumulate way,

      i need to know when all diferents users had readed the document at least one time.

       

      i use the acumulate radio button of the expresion tab, but this sum all users and at the end the value is highest thant the max users.

      i have attached an example.

       

      Any body know how can i sum acumulate diferents users day by day.

       

      regards

      diego

        • Re: Accumulate diferents values
          Sunny Talwar

          Are you looking to plot individual lines for each user?

           

          Best,

          S

            • Re: Accumulate diferents values
              Sunny Talwar

              This might be what you are looking for. PFA

               

              Best,

              S

                • Re: Accumulate diferents values
                  dcd dcd

                  Hello

                  I need a chart line where i can show evolution of days and how many diferents users have readed the document yet,

                  for example whe first day only 50% of the total users have reded yet  the document, the second day 97% of the users have readed the document and so on, and i can see that in the 3 first day near 99% of the users have readed the document....

                  i think this line char like a line with acumulate difrents users, but if i only use the  accumulated radio button QV sum all values, day by day... and if a user 1 logon in the first day, but logon in the second day again the QV in the second day acumulate the value 1+1...

                  i need that the  first day count diferents users of the first day, second day count diferents users of the first day and second day together, not sum diferents users of the first day + diferents users of the second day...

                   

                  the file that i attached is only an example, in real i have mor than 2000 diferents users and 30 days....

                   

                  i don't know if i explain my problem right...

                   

                  thanks for your answers

                   

                  best regards

                  diego

              • Re: Accumulate diferents values
                Aaron Morgan

                You can use an Aggr statement against the Date to return the minimum date found for each user, which would be the "first" time they access it - then when you're accumulating this would only count each user the first time they accessed.

                 

                Change your dimension to be:

                 

                Aggr(Date(Min(Date)), User)

                 

                Otherwise if you want to do this in your script, create a new resident table that calculates the minimum date per user, like:

                 

                Left Join ([Your Table Name])
                Load
                User,
                Date(Min(Date)) as FirstAccessed
                Resident Records
                Group by User;

                 

                Then use "First Accessed" as your dimension, much as above.