Choose the second Value in Query Table for Canvas

Elastic Stack Kibana
1

Hello all,

I am trying to display a top 3 ranking in a canvas. For this I need the highest score, the middle score and the lowest score.

The highest score is correctly queried but I am not able to determine the 2nd score.

Can you help me here?

This is the query I use to get the data:

SELECT
id,
score
FROM "logs-game*"
WHERE "data.type" = 'end'
GROUP BY id, score
ORDER BY score DESC
LIMIT 3

Many thanks in advance!

2

I don't follow the problem. Can you share some sample data to reproduce your query and what results you expect to get?