Is there a way to only shot totals from addcoltotals if there is more then a single row in the table?
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)
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)
Nice solution!
You may consider accepting your answer so the question no longer appears open, and others have an easier time finding the solution.