{ "abcdxyz" : { "transaction" : "abcdxyz", "sampleCount" : 60, "errorCount" : 13, "errorPct" : 21.666666, "meanResTime" : 418.71666666666664, "medianResTime" : 264.5, "minResTime" : 0.0, "maxResTime" : 4418.0, "pct1ResTime" : 368.4, "pct2ResTime" : 3728.049999999985, "pct3ResTime" : 4418.0, "throughput" : 0.25086548592644625, "receivedKBytesPerSec" : 0.16945669591340123, "sentKBytesPerSec" : 0.3197146692547623 }, "efghxyz" : { "transaction" : "efghxyz", "sampleCount" : 60, "errorCount" : 13, "errorPct" : 21.666666, "meanResTime" : 421.8, "medianResTime" : 32.0, "minResTime" : 0.0, "maxResTime" : 3566.0, "pct1ResTime" : 3258.5, "pct2ResTime" : 3497.6, "pct3ResTime" : 3566.0, "throughput" : 0.24752066797577596, "receivedKBytesPerSec" : 0.34477244084256037, "sentKBytesPerSec" : 0.08463804872238082 }, "ijklxyz" : { "transaction" : "ijklxyz", "sampleCount" : 60, "errorCount" : 13, "errorPct" : 21.666666, "meanResTime" : 27.733333333333338, "medianResTime" : 27.5, "minResTime" : 0.0, "maxResTime" : 241.0, "pct1ResTime" : 41.599999999999994, "pct2ResTime" : 52.699999999999974, "pct3ResTime" : 241.0, "throughput" : 0.25115636576738737, "receivedKBytesPerSec" : 0.3331214746541367, "sentKBytesPerSec" : 0.08588125143891667 }, "mnopxyz" : { "transaction" : "mnopxyz", "sampleCount" : 60, "errorCount" : 13, "errorPct" : 21.666666, "meanResTime" : 491.74999999999994, "medianResTime" : 279.5, "minResTime" : 0.0, "maxResTime" : 4270.0, "pct1ResTime" : 381.29999999999995, "pct2ResTime" : 4076.55, "pct3ResTime" : 4270.0, "throughput" : 0.2440254437195985, "receivedKBytesPerSec" : 0.16483632755942018, "sentKBytesPerSec" : 0.2839297997262848 } } I need to create a table view from the above log event which was captured as a single event, like the below table format: samples abcdxyz efghxyz ijklxyz mnopxyz "transaction" : "sampleCount" "errorCount" "errorPct" "meanResTime" "medianResTime" "minResTime" "maxResTime" "pct1ResTime" "pct2ResTime" "pct3ResTime" "throughput" "receivedKBytesPerSec" "sentKBytesPerSec"
... View more