Hi Anyone can help me, I am trying to get the Total count of a certain value(usernames) and disregarding its duplicate log for the day.
I am using the Singlestat panel, and currently my log sources come from a Graylog (parsed OpenVPN logs), now the logs get to “log” the username and ip every hour as this is the behaviour of the VPN server, for example:
06/08/2020 9:30:AM user1 192.168.10.1
06/08/2020 9:30 AM user2 192.168.10.2
06/08/2020 10:30:AM user1 192.168.10.1
06/08/2020 10:30 AM user2 192.168.10.2
The singlestat panel, returns me a total of 4 counts(whereas I only want the the total unique counts, so should be only 2), however been trying to use the unique count but no to avail.
Appreciate your help thanks!