Unique Count of a Count

[QuestBevan (Bevan)]

Hi All,

I am trying to figure out a way to build this visualisation.

Our use case is, we have X amount of devices_serial_numbers (string field) that we want to monitor. Each device send up a result (string field) on whether is passes or fails a test.

The test can be completed multiple times and a new event/document is generated every time the test is completed.

I want to represent "How many "devices_serial_numbers" have a count of X number of "result=failed"". So if within the timeframe there is

• 5 failed test for serial number 1234
• 4 failed test for serial number 2345
• 4 failed test for serial number 3456
• 2 failed tests for serial number 4321

I would see 3 bars, in a bar-chart.
1st bar would be a value of 1, as the unique count is 1.
2nd bar would be a value of 2, as there are 2 serial numbers where the count if 4.
3rd bar would be a value of 1, as the unique count is 1.

[Stratoula_Kalafateli]

Hey! If I understand correctly what you want to do, you could so something like that (this is a Lens example)

Add on a horizontal bar the top values of the serial number (vertical axis) and then the unique count of result and use a filter result: failed