Getting Data In

suppressing underscore prefixed columns from report

RVDowning
Contributor

I have a report:
blah, blah, blah
| stats count as NbrSaves, dc(UserId) as DistinctUserIds
by _date_numericyear, _date_numericmonth, date_year, date_month, date_mday, date_hour, _date_numericminute
| sort 0 + _date_numericyear, _date_numericmonth, date_mday, date_hour, _date_numericminute
| rename date_year as Year, date_month as Month, date_mday as Day, date_hour as Hour, _date_numericminute as Minute
| outputcsv AffinityPlanSaveRate.csv

It outputs too many items for the screen and is instead sent to a report, but _date_numericyear and _date_numericmonth (which are computed fields just used for ordering purposes) also appear in the saved file, although not on the display. I thought the underscore would suppress them from both. How can I also suppress them from the generated report?

0 Karma

sdaniels
Splunk Employee
Splunk Employee
0 Karma

RVDowning
Contributor

Ah, didn't know about the + and - signs. Thanks much.

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

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