Dashboards & Visualizations

addcoltotals - only want to show totals if more then one row in the table

Contributor

Is there a way to only shot totals from addcoltotals if there is more then a single row in the table?

0 Karma
1 Solution

Contributor

Figured out how to do this. Use streamstats and search.

| addcoltotals Connections,"Licensed Devices","Devices - Android","Devices - iOS","Devices - Windows","Device Licenses - Total","Device Licenses - Available" labelfield=Server label="Total"
| streamstats count as row
| where !(Server="Total" AND row=2)

View solution in original post

0 Karma

Contributor

Figured out how to do this. Use streamstats and search.

| addcoltotals Connections,"Licensed Devices","Devices - Android","Devices - iOS","Devices - Windows","Device Licenses - Total","Device Licenses - Available" labelfield=Server label="Total"
| streamstats count as row
| where !(Server="Total" AND row=2)

View solution in original post

0 Karma

Champion

Nice solution!

You may consider accepting your answer so the question no longer appears open, and others have an easier time finding the solution.

0 Karma