Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Platform Analytics - Count Distinct

Tarbash2
Tera Contributor

3 weeks ago

I am trying to display the count operating systems using a single score data visualization type on a platform analytics dashboard. My data source is the cmdb_ci_server table but when I choose the 'count distinct' as the aggregation, I do not have a way to select 'operating system' anywhere in the menus or sub-menus.

0 Helpfuls
  • 322 Views
2 REPLIES 2

J Siva
Kilo Patron
Kilo Patron

3 weeks ago

Hi @Tarbash2 
Count Distinct is used to display unique values. Therefore, applying Count Distinct to the Operating System field does not make sense.
May I know what you are trying to achieve?
Regards,
Siva

0 Helpfuls

Tarbash2
Tera Contributor
In response to J Siva

2 weeks ago

Hello @J Siva ,

Thank you for the clarifying question. I would like to show how many unique operating systems are being used. For example, lets say there are 10 systems that are being use at a particular company. Out of which 5 are Windows Server 2022, 4 of which are Window Server 2016 and 1 of them is a Windows 11. The unique count of Operating Systems would be 3.

 

Hope this helps. Let me know if what I am trying to do is still not clear.

 

Thank you.

0 Helpfuls