Getting a Unique Count of Entries in ControlUp’s Grid Layout

A user asked about using the Grid layout to deduplicate entries in a custom index, and specified that the end goal was to see unique computer names and their total count. Another user suggested using a Table Widget and selecting Device ID as the field, with an aggregation of Total and grouping by Device Name. The user was able to achieve their desired result, but brought up the limit of 50 unique entries and questioned its necessity. It was clarified that this limitation is due to technical restrictions, but it may be expanded in the future.

Read the entire ‘Getting a Unique Count of Entries in ControlUp’s Grid Layout’ thread below:

I have a custom index that contains entries including computer names, usernames, and other data. By design, there are multiple entries for the same computer name. I need to use the Grid layout to deduplicate the computer names, as I only need to know the total count of unique computer entries. I haven’t been able to figure out how to do this.

What is the end goal? Group by computer name + count _device_id? Do you want to see any other metrics?

I think unique computer names is really all I need.

Select a Table Widget

• Set Field to Device ID

• Set Aggregation to Total

• Enable Grouping and Group By Device Name

Is that what you’re looking for?

Sorry use Count instead

We will only be able to pull first 50 this way though

That did work. Than you.

The max of 50. That I don’t understand. Why is there a limitation? I have more than 50 unique computer names in the index.

At this point, we dont support pagination on the CU4D aggregation queries. Enabling Grouping changes from a simple select to using Term aggregation on the Opensearch side.

Its not impossible but requires some changes on our side.

Grid is a select with pagination supported.

@member @member

We have talked about allowing up to 200 when it’s a table. The limit of 50 is because when doing a time serie get 30 points and a top 50 per day can endup to 6000 datapoints which is the max we can do before we bring down ES. But in a table 200

Should be possible. I’ll at it too our todo list

Continue reading and comment on the thread ‘Getting a Unique Count of Entries in ControlUp’s Grid Layout’.  Not a member? Join Here!