Visualisation: from table to metric


(Ruthvik Sai) #1

Hi friends,

I am trying to find unique users who have used the app. For ex: outlook

I am able to get it in the form of table but struggling getting in the form of a visualisation: metric/ bar

In metric I want to get 3 as seen in the table.

Can you please help me how I can be able to do this?

Thanks in advance


(Aaron Caldwell) #2

Hello Ruthvik,

If you want to identify specific unique users, a table may be your best option. If you want a count of unique users, you could try a Unique Count. Here's an example using a different dataset:

Regards,
Aaron


(Bryan Stuhlsatz) #3

If you want a unique count... using a visualization other than a chart is going to be pretty boring. Why? because you want unique. A table works best. Otherwise you have a flat set of bars across the screen and that visualization doesnt help you consume the data easy.

  1. To create what you want. The metric section will be unique count and the field will be the user field in your data set.
  2. You will do a bucket agg on the field that contains outlook (maybe an app field).
  3. You can then do another filter agg, and create a filter for your field in step 2, and match the app you are looking for. ex. appfield:Outlook. for this last part, you can also apply a lucene filter at the top of the visualization to filter for Outlook instead of embedding the filter in the visualization form.