My dataset is like below:
01/05/2013 23:58:00 -0800, search_name=foo, search_now=1357459200.000, info_min_time=1357459080.000, info_max_time=1357459200.000, info_search_time=1357459425.558, Count=1, apiName="footest", appName="bartest", clRT=70, status=401, svRT=68
01/05/2013 23:58:00 -0800, search_name=foo, search_now=1357459200.000, info_min_time=1357459080.000, info_max_time=1357459200.000, info_search_time=1357459425.558, Count=10, apiName="footest", appName="bartest1", clRT=50, status=200, svRT=52
Each "apiName" can have multiple "appNames".
Successful txn means any event with "status" between 200-400.
Total Txns mean sum(Count)
What I would like to get is for each apiName, the timechart for # of Successful txns over time for "appName"s for which the total throughput is in top 5.
Say there are 7 appName like foo1, foo2, foo3, so on... and their respective TotalTxns is 11,10,9,8,7,6,5. So I would like to show for each apiName, timechart of # of successful txns for appNames (foo1 to foo5 as their throughout is in Top 5)...
apiName can be chosen by the user from the dropdown in the view.
Thanks for your help.
... View more