I'm fairly proficient with Data Table visualizations, but have mostly kept them to 2-3 columns. E.G. |bucket|count| or something like |bucket|count|sibling aggregation|.
Now I'd like to do something a little more complicated. I'd like to bucket the data table as usual, but I'd like many columns. I don't mind if I have to define each one individually, but I want something like |bucket|count where 'result' field NEGATIVE|count where 'result' field POSITIVE|count where 'accepted' field is ACCEPTED|count where 'accepted' field is REJECTED|.
However, the only way I know to get counts for various fields being a specific value is the query and filters at the top (which would eliminate other values of result and/or accepted). Also, the only way I know how to add more columns is to add more metrics. Is it possible to add a filter to a specific metric? That's the only way I have thought of that might make this work.
Hey @cgmelastic this isn't possible currently using the Data Table visualization. If you could give https://github.com/elastic/kibana/issues/9507 a +1 or a comment with your requirements, it'll help us prioritize this appropriately.
However, you can use the TSVB Table visualization to do this:
But if I create a basic Metric and only apply that same filter (path: "*/reject") I can see that there are 11 documents out there that match the filter:
Would you mind creating a bug for this? Even without using the filter, I'm not seeing any results unless I adjust the interval to be larger than the timespan and then tell it to not drop the last bucket.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.
