How to calculate the average value of grouped data?

Question

css

Simple mapping:

player_id: int
stat_date: date
battles: int

You need to calculate the average number of fights among the players.
Apparently, you need to first use the term aggregation on the player_id field, but it is important to "select" the entry with the most recent date for each player. Then, based on the results, calculate avg for the battles field.
I've been struggling for a week now, I can't figure out how to make such an aggregation.

Answer 1

Play with shadow parameters and online generators
But the best option is to export css in photoshop

Answer 2

It seems to me that this is not a shadow, but a gradient.

Answer 3

Well, judging by the picture, there is also some kind of block on top - give it a larger z-index. Or position: relative/ Well, in general, so that it overlaps with other blocks above and below. Or make it a pseudo element with inner shadow or gradient

Answer 4

if it’s too lazy with your hands, then avocode to help, if the designer, of course, didn’t make a shadow with a picture

Answer 5

Make a request with a filter by date and stats aggregation by the battles field. Get and mean and min and max and median https://www.elastic.co/guide/en/elasticsearch/ref...