topic Counter that does not count repeated terms in Visualization and Usability

Counter that does not count repeated terms

poupeinvista — Thu, 16 Nov 2017 01:14:02 GMT

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_g — Thu, 16 Nov 2017 08:45:14 GMT

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

poupeinvista — Wed, 29 Nov 2017 02:33:44 GMT

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?

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

2. how many "coo" per user?

How many different users have been registered?

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

Re: Counter that does not count repeated terms

shraddha_g — Wed, 29 Nov 2017 08:52:26 GMT

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)