Splunk Search

Table Modify Structure

Contributor

I have a query which results in following data

alt text

But i need to generate a table in this format

alt text

Tags (3)
0 Karma
1 Solution

Contributor

You could use chart instead of table

... | chart sum(TxDuration) over ProductID by Tier

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Chart

View solution in original post

Contributor

You could use chart instead of table

... | chart sum(TxDuration) over ProductID by Tier

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Chart

View solution in original post

Contributor

productID, TxDuration, Tier are three fields

0 Karma

Contributor

sorry images not uploaded properly..

I have a query which results in following data

ProductID txnDuration Tier


1 0.12 Tier_1


1 0.14 Tier_2


1 1.25 Tier_3


2 0.56 Tier_1


2 0.89 Tier_2

But i need to generate a table in this format

productID Tier_1 Tier_2 Tier_3


1 0.12 0.14 1.25


2 0.56 0.89

Can any one help me here please.

0 Karma