there are couple of scenarios that i wanted to discuss:
If we run aggregations (on large data sets) during REST API calls? How expensive it is experienced to be?
If we store pre-aggregated data(which runs during insertion of data in elastic search)? and we run queries to fetch them during API calls, can this be a great solution?