I want to group fields with count less than 50 into a separate field called "Others"

Grafana Elasticsearch
,
1

Hi all , I am using grafana version 7.10 and want to group fields with count less than 50 into a separate field called “Others” . Please help.

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

2

What is your data source?

3

Dataasource : elasticsearch

4

Could you please post sample of what your data looks like?

5

column 1 column 2
A 200
B 190
C 131
D 81
E 41
F 11

I want it like this →
column 1 column 2
A 200
B 190
C 131
D 81
Others 52

6

ran into an issue with my grafana being http and my elastic search https. will post back if sorted out.

7

here you go something like this? @skandupadhyay

image
image2163×1049 196 KB

image
image517×677 52.7 KB

Under standard Options change Decimal to 0. On Alias field of first query add Others

image
image2699×1171 199 KB