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!

Security Highlights | November 2022 Newsletter

 November 2022 2022 Gartner Magic Quadrant for SIEM: Splunk Named a Leader for the 9th Year in a RowSplunk is ...

Platform Highlights | November 2022 Newsletter

 November 2022 Skill Up on Splunk with our New Builder Tech Talk SeriesCan you build it? Yes you can! *play ...

Splunk Education - Fast Start Program!

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