Is there a way to create a bar chart in Kibana with both column grouping and stack aggregations? Namely, I would like something like this
where different columns in a given time period separate records broadly, while the stack colors give more fine-grained information about them.
Yes, this is possible. When setting up the visualization you need to end up with a configuration like this (specifically note the boxed area):
To achieve this, first choose "Split Chart" under "Select buckets type". Then make sure the "columns" button is clicked. Then setup the aggregation for the broader grouping (months, in your example).
Next, click "Add sub-buckets" and choose "X-Axis". Then setup the aggregation for the narrower grouping within each broader grouping (i.e. each of the bars within each month, in your example).
Finally, click "Add sub-buckets" again and choose "Split Bars" (the only option). Then setup the aggregation for the stack colors (group A, B, C, in your example).
© 2020. All Rights Reserved - Elasticsearch
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.
