Dashboards & Visualizations

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

simpkins1958
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

simpkins1958
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

simpkins1958
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)
0 Karma

micahkemp
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
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) v3.54.0

The Splunk Threat Research Team (STRT) recently released Enterprise Security Content Update (ESCU) v3.54.0 and ...

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

New Learning Videos on Topics Most Requested by You! Plus This Month’s New Splunk ...

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...