Splunk Search

Display data in a table based on fields.

nikita012
New Member

I have 3 fields in my table.
Store_id Minutes Date
1234 40 07/06
1232 50 07/07
1234 60 07/07
1232 70 07/06

I want to display the data in following manner:

Store_iD 07/06 07/07
1234 40 50
1232 70 60

Where the table has Minutes displayed based on the date for each store.

Can you please provide the query.

0 Karma
1 Solution

woodcock
Esteemed Legend

Like add this to the bottom:

... | xyseries Store_id Date Minutes

View solution in original post

0 Karma

woodcock
Esteemed Legend

Like add this to the bottom:

... | xyseries Store_id Date Minutes
0 Karma

jitendragupta
Path Finder

try this code:

<your base query> | table Store_id Minutes Date | chart values(Minutes) over Date by Store_id | transpose header_field=Date | rename column as Store_id
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

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

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...