Dashboards & Visualizations

Dashboard Studio - Remove the _tc column in table

treinke
Builder

Trying to get a nice list of the top 10 countries a firewall is blocking.  If I run the search in the search app, it comes back with the columns of Country and count.  I use Dashboard Studio and I use the same search as a data source and I get Country, count, and _tc.  I am guessing I am missing a flag to not show the total count.

Splunk Search:

(index=netfw OR index=netproxy) (sourcetype="pan:threat" OR sourcetype="pan:traffic") action="dropped" (src_ip!=10.0.0.0/8 AND src_ip!=172.16.0.0/12 AND src_ip!=192.168.0.0/16) | iplocation src_ip | top limit=10 Country showperc=false
| fields Country,count

Studio Visualization:

{
"type": "splunk.table",
"options": {
"showRowNumbers": true
},
"dataSources": {
"primary": "ds_69PTFLxT"
},
"title": "Top 10 Blocked Countries",
"showProgressBar": true,
"context": {},
"showLastUpdated": false
}

There are no answer without questions
Labels (1)
0 Karma

liuweiwell
Explorer

You can use | fields - _tc

or you can use |table field1 field2 ... (just without _tc)

Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...