Let's assume that i have something like that in elastic search
alarm_id sequence date alarm_text 1 1 2019-11-7 text of alarm1 2 1 2019-11-7 text of alarm2 2 2 2019-11-8 text of alarm2 2 3 2019-11-9 text of alarm2 3 1 2019-11-8 text of alarm3 3 2 2019-11-10 text of alarm3
and i want to group this information like that in kibana:
alarm_id count date alarm_text 1 1 2019-11-7 text of alarm1 2 3 2019-11-9 text of alarm2 3 2 2019-11-10 text of alarm3
which means that i want to have a grouping by alarm id, a column "count" which keeps the maximum number of "sequence" column for that alarm_id (or alternatively the number of occurrences of that alarm_id), the newest date and its alarm text
i managed to have only the first two columns using a data table visualization but i couldn't have the rest columns too. Is there any way (visualization or search) to do it in kibana or is not feasible?
Thanks in advance