Skip to main content
Solved

stats or groupby

  • February 13, 2025
  • 2 replies
  • 30 views

Siva
Forum|alt.badge.img+12

Hello, is there a way in advanced analytics to find unique values of a field with count. Similar to stats in splunk? 

Best answer by Aaron_Zhang

Hi ​@Siva ,

Thanks for reaching out.

Yes, the “count distinct” and “list of unique values” features can help. For example, to find and count the unique apps used by every user, we can “count” and “list” the “application” field through “aggregate,” the visual will then shows the unique count of apps used by each user and list them all. 

 

Feel free to let us know if you have any other questions.

Best,

Aaron

This topic has been closed for replies.

2 replies

Aaron_Zhang
Netskope Employee
Forum|alt.badge.img+13
  • Netskope Employee
  • Answer
  • February 13, 2025

Hi ​@Siva ,

Thanks for reaching out.

Yes, the “count distinct” and “list of unique values” features can help. For example, to find and count the unique apps used by every user, we can “count” and “list” the “application” field through “aggregate,” the visual will then shows the unique count of apps used by each user and list them all. 

 

Feel free to let us know if you have any other questions.

Best,

Aaron


Siva
Forum|alt.badge.img+12
  • Author
  • Explorer III
  • February 14, 2025

Thanks Aaron.