I have the following response: aggregations" : { "a" : {...}, "b" : {...}, "c" : {...}, "d" : { "value" : 5 }, "e" : { "value" : 6 }, "f" : { "value" : 7 } } d, e and f are sum_bucket aggregations on a,b, and c respectively. I need to transform it into a format that …

Hi Shai, This one had me scratching my head, too. I think you can accomplish what you're describing by way of the Vega-Lite "fold" transform . Here's a <a href="https://vega.github.io/editor/#/url/vega-lite/N4IgJAzgxgFgpgWwIYgFwhgF0wBwqgegIDc4BzJAOjIEtMYBXAI0poHsDp5kTykBaADZ04JAKyUAVhDYA7EABoQmOoLhoQAUQAeSBDjUACAEJIAToYDCMc5kMAxM2wSGAynDVQ7AQTJkIiiAAJkiYKKigxEiCDHABESBIfmZ8KnLxoOGR0bFoAEwAvkpMaNkx6qgAzEUgUKUgUeVoACw1QfWNuahiNRVlXQBsNQBmHTkVAOwF00rDbGbImPU4TjhwZpgAnhpJZCkUabIBM8pmSEdzC2gA2qBzgu2o18GB6rMgALoFH0rIZgDWGiY5lesigbCCNFkZHq2nqwxoHkeIH+cG2Si2aw0smcUOigSQ2hoGWUqgqIAgDAQAH0mAwoKifMlUux5CdtgkEUiNJ04JReYFMeSAI4Mc4qMIqUgEokkiVqDQANXGIGm0yAA">working example . Let me know if I got this right!

Discuss the Elastic Stack

Issue transforming data for Vega visualization

Elastic Stack Kibana

shaigbdb (Shai Greenberg) March 17, 2022, 5:22pm 3

That was it!
Thanks Andrew!

Topic		Replies	Views
Transform Vega Data Kibana vega	3	472	December 8, 2022
Aggregation on Vega-LIte Kibana vega	3	2217	September 10, 2020
Vega visualisation Kibana vega	6	424	August 16, 2022
Transform Data - Vega Kibana Kibana vega	1	223	October 14, 2022
Is there a way to do a project transform in Vega-Lite? Kibana vega	2	561	February 20, 2021

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

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.

Issue transforming data for Vega visualization

Related topics