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!

Splunk Education - Fast Start Program!

Welcome to Splunk Education! Splunk training programs are designed to enable you to get started quickly and ...

Five Subtly Different Ways of Adding Manual Instrumentation in Java

You can find the code of this example on GitHub here. Please feel free to star the repository to keep in ...

New Splunk APM Enhancements Help Troubleshoot Your MySQL and NoSQL Databases Faster

Splunk Observability has two new enhancements to make it quicker and easier to troubleshoot slow or frequently ...