Hi,
I have a data table visualization in Kibana 7.10.2 where I am displaying No., Name, Status and Time. In my case, for the same 'No.' field, I have many 'Name' and for the same 'Name', I have many 'Status'. And I need to display only the TopHit for all three. The condition to be met is that if the TopHit is false, then the No., Name and Status for that false should not be displayed. But when I give a filter to exclude false values, it will discard the false and display the next true value. What I need is to completely remove the No., Name and Status.
To get the output I have used TopHit of Status and TopHit of Time in Metrics with size 1. In Buckets, I have added No. as the aggregation and Name as the sub-aggregation.
In the above image, I have given TopHit as 10 to show all the values in Status. My requirement is that when there is a false in the row, the whole row should be excluded even if it has a true later. But when I give a filter to exclude false from the visualization, it deletes only the false value from the row and true is displayed. The required output is as below.
123 abc true,true,true,true Aug 12, 2024 @ 11:05:33
123 ghi true,true,true,true Aug 12, 2024 @ 15:50:40
123 jkl true,true,true,true Aug 12, 2024 @ 16:30:39
Thanks.