You could use chart instead of table
... | chart sum(TxDuration) over ProductID by Tier
http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Chart
You could use chart instead of table
... | chart sum(TxDuration) over ProductID by Tier
http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Chart
productID, TxDuration, Tier are three fields
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.