I have requirement to visualize data in the below format in Kibana
I have series of log events loaded from csv. Here the log events can be segregated using trace id for the particular transaction which as an action name attached to it.
Using aggregate filter in logstash I have calculated the timetaken for the particular transaction with trace id as task id and included action field to it. How can I use this fields to calculate the average time taken for the transaction pertaining to the action. For example if I have an action named "ABC" which has 20 events in the index and each event has time taken field attached to it. How can make a data table similar to the above attached image:
Please let me know if we have a way to achieve this. Any help here is much appreciated.