Reporting

How to create pivot table containing some empty values?

Splunker2018
New Member

Hello. I've got a problem.

I have a logfile.
And I would like to create a pivot table (url, referer) and export it to csv.
But there is one problem: some refs are empty.
Then splunk.... exports only these rows where ref is not empty. So, instead of including all rows, the exported CSV contains only ~5%,

How to fix it?
Thank you in advance for your help

Tags (2)
0 Karma

DalJeanis
Legend

I don't think the term "pivot table" is relevant. You just need a cross reference table. Try this...

your search that returns the records 
| fields url referrer
| eval referrer=coalesce(referrer,"")
| stats count by url referrer
| fields - count
0 Karma
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...