Can i combine values from different rows into one based on aggregations?

Actual:

Expected:

I want to display it in a data table vis.

You can sort of get there, with scripts, but It's difficult and this not the right tool for what you want to do there.
Have a look at Painless scripts: https://www.elastic.co/guide/en/elasticsearch/reference/master/modules-scripting-painless.html and when creating your data table visualization, you can add your custom JSON in the "Advanced -> JSON input" field. The problem is mainly with getting ES to give you that aggregation that you want to display there, so maybe they can help you more on their Discuss forum.

@Marius_Dragomir i tried this approach but i was not able to get the desired results. i guess it is processed row by row if i am not wrong. Thanks for you suggestions :slight_smile:

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.