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

[simpkins1958]

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

[simpkins1958 · Accepted solution]

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)

[micahkemp]

Nice solution!

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