topic Re: Is it possible to hide, suppress or remove the column header row in a report? in Splunk Search

Is it possible to hide, suppress or remove the column header row in a report?

Gawker — Thu, 03 May 2018 21:04:44 GMT

I have a report that looks similar to this:

Is it possible to hide, suppress or remove the column header row in the report so that it looks like this:

I want to do this in the actual report, not in a dashboard.

BYA, this is not the solution: https://answers.splunk.com/answers/76860/is-it-possible-to-remove-coulumn-names.html

Thank you.

Re: Is it possible to hide, suppress or remove the column header row in a report?

cpetterborg — Fri, 04 May 2018 00:33:15 GMT

Try:

<your_base_search_in_all_its_glory> 
| rename <Location> as " " 
| rename <Data_Age> as "  "

It may not exactly NOT have column names, but they will at least be invisible.

Re: Is it possible to hide, suppress or remove the column header row in a report?

Gawker — Fri, 04 May 2018 16:38:18 GMT

Thank you for the info. I already tried that, but it looks a little odd having the blank row at the top when it's embedded in a web page. I was hoping that Splunk had some easy option to hide/unhide the column names (ex: table hideheader=y Location, Data_Age

Maybe they'll consider it an enhancement : )

Re: Is it possible to hide, suppress or remove the column header row in a report?

woodcock — Sat, 05 May 2018 00:37:01 GMT

This is the only option.

Re: Is it possible to hide, suppress or remove the column header row in a report?

niketn — Mon, 07 May 2018 16:31:05 GMT

@Gawker, can you try the following Run anywhere Search? The commands from first | makeresults till | table Location Data_Age generate dummy data similar to your question.

The query uses two transpose commands to make a row of Table Data as Column Header. In this case Germany. To ensure Germany is always present in the result dummy row with 0 Age has been appended to the results.

| makeresults 
| fields - _time 
| eval data="Location=Germany,Data_Age=3;Location=Switzerland,Data_Age=2000;Location=USA,Data_Age=1000;Location=USAHQ,Data_Age=200;" 
| makemv delim=";" data 
| mvexpand data 
| rename data as _raw 
| KV 
| table Location Data_Age
| sort Location
| append 
    [| makeresults 
    | fields - _time 
    | eval Location="Germany", Data_Age=0]
| dedup Location    
| transpose header_field=Location column_name=Location 
| transpose header_field=Germany column_name=Germany 
| search Germany!="Location"

Since the logic behind this approach is to use Table Row data as Table Header, the formatting of the Row will be same as Table Header and the same can not be overridden.

If this does not cater to your needs, can you please describe the need for Report and not Dashboard?