Use case:
We have a device table in this element which has a firmware column. We would like to display a pie chart showing the amount of devices with distinct firmware versions, where the firmware version is the label.
fw_001: 6
fw_002: 9
fw_003: 1
I found the Aggregate Count Distinct, which seems to be close what we need, but I can't get to the endresult we have invisioned. Is this possible with current features?
Jeroen,
I guess an Aggregate 'Count distinct' followed by a 'group by' should do the job. Feel free to share your specific use case in case this does not work for you.
I got it working when working with
– Get parameter table by ID
– Aggregate Model (method Count, Group by Firmware)
I’m now following the guidance to retrieve the same table from the element based on the specific element name, and tried adding the aggregate in the same way but it now throws an error.
– Get elements
– Filter Name (regex value ^element name$)
– Select Element ID Name
– Join Inner
– Get parameters for element where protocol and version and parameter
– Select Element ID, FW version, Name [IDX], Model
– On Element ID equals Element ID
– Aggregate on Model –> Error trapped: object reference not set to an instance of an object
Sounds like an issue, let’s follow up with a collaboration task Jeroen.
Actually, it can be a regular count instead of a distinct count. A distinct count will only count the unique values in the column, here we want to do a regular count while grouping on the firmware version.