Templating, query type variable, top 10 terms

Grafana Elasticsearch
1

Hi,

I want to use query type variable for choosing SystemCode, which can have one of over 200k values.
Limit of values is 500 in Grafana. Is it possible to create query which returns top 10 SystemCodes ?
Top 10 - i mean count of documents.
My current query:
{“find”: “terms”, “field”: “SystemCode.keyword”,“size”:10}

Thanks in advance !

2

Hi ^^
Can you tell me type of datasource you choose?
But I think you can select top 10 with any type datasource.

You can follow:
Add Select => Selectors => Top => Top(10).

image

3

Hi :slight_smile:
I forgot: it’s Elasticsearch 5.x
Please remember that i mean not metric query but query in Templating/Variable (query type variable)

image
image841×727 47.3 KB

Thanks !

4

There’s an open feature request with a submitted pull request that haven’t been merged yet that you can try out.

Marcus

5

Good to know.
Thanks Marcus !

6

Any update on this feature?