How to reorganize a table - Splunk Community

Splunk Search

Hello,

I have a table like that :

customer	prod_1	prod_2	prod_3
customer_1		green
customer_2	red		orange

and I would like to count customer by product to get a table like this :

product	count	custumer
prod_1	1	customer_2
prod_2	1	customer_1
prod_3	1	customer_2

Is it possible ?

Hi @mah,

please try something like this:

your_search
| stats count BY product customer
| table product count customer

Ciao.

Giuseppe

What search produced the first table?

---
If this reply helps you, Karma would be appreciated.

Get Updates on the Splunk Community!

A Four-Part Event Series: Full Stack Observability For the AI Era

As AI reshapes applications, infrastructure, and the way teams operate, the traditional boundaries of ...

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Event Series: Level up your SOC: Advancing with Splunk Enterprise Security

AI has fundamentally raised the stakes for security operations, and this three-part series is your guide to ...