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!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...