How to get unique user logins?

Hello all. I’m trying to get a query to show unique visitors login in our system. But I get the summed logins regardless if a user has logged in multiple times. If user A has logged in 4 times during the period and user B has logged in 1 time, I get a result of 5 in “Single number” aggregation. I want the number 2. I have the METRICS set to count(username). How could I configure this in another way to get the results I’m looking for?

Thank you

Try to use function card(your_field) in widget’s METRICS and remove ROWS field at all.

1 Like

Thank you very much shoothub! Seems to be working perfectly :grinning: :+1: :+1:

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.