3 Replies Latest reply: Nov 29, 2017 3:52 AM by Shraddha Gajare RSS

    Counter that does not count repeated terms

    Moises Nunes Moreira

      Hello!

      I'm Trying to Generate a Function That Counts HOW many user registrations have occurred in a certain Establishment, yet ONE SAME User Appears on Different Dates. I CAN NOT COUNT Repeated users, (WITH SAME ID number).

       

      Thanks for the collaboration!

        • Re: Counter that does not count repeated terms
          Shraddha Gajare

          How do you want to show the data?

          Do you want to count Repeated Users or not?

          If you want to count then Count(UserID)

          Else for non repetitive Count(Distinct UserID)

            • Re: Counter that does not count repeated terms
              Moises Nunes Moreira

              Thank you for your attention!

               

              I'm a beginner in this tool and I'd like to ask for help.

              using the table above as a reference, I would like to extract this information and design it in the graph, what would the program line be like?

               

              1. sum of the value linked to the coo used by the user?
                  2.     how many "coo" per user?
              1. How many different users have been registered?
              1. What "Amount" acquired by each "USER" in  time espace?

              exemple chart data.JPG

                • Re: Counter that does not count repeated terms
                  Shraddha Gajare

                  1. sum of the value linked to the coo used by the user?          

                            Not so sure about it.. but Dimensions can be UserID and coo and Measure can be sum(Value)


                  2. how many "coo" per user?

                            Dimension can be UserID and Measure can be Count(Distinct coo)


                  3. How many different users have been registered?


                            Dimension can be Point of Sale and Measure can be Count(Distinct UserID)


                  4. What "Amount" acquired by each "USER" in  time espace?

                  not so sure about it.. but Dimensions can be Date, Time and UserID and Measure can be Sum(Value)