[Feat Req] Elasticsearch: Support for metric queries without group by #61167
Replies: 17 comments 1 reply
-
|
You can remove the group by if you want (if your using table panel, graph panel requires date histogram) |
Beta Was this translation helpful? Give feedback.
-
|
Sorry, forgot that you need a group by. You can change the interval to 1y or some big number to only get one value back |
Beta Was this translation helpful? Give feedback.
-
|
LoL. This is not a "resolution" for the issue. I did what you mentioned as a hack, and then I opened the ticket here. A GitHub ticket is for discussing the problem and reaching a proper resolution, not for hacking the problem around. The latter can be done on IRC! |
Beta Was this translation helpful? Give feedback.
-
|
Sorry, yes your right it's not an ideal solution. It's just so common that an ES query requires a group by that it has never come up as a feature request before. |
Beta Was this translation helpful? Give feedback.
-
|
Is there any follow-up for this? I have a simple use case where I just want to graph the value of one specific field for each document. |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
We need to do some research here. |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
+1 |
Beta Was this translation helpful? Give feedback.
-
|
For additional discussion, please use #77557 |
Beta Was this translation helpful? Give feedback.
-
|
What ?? That has nothing to do with the original request ?? |
Beta Was this translation helpful? Give feedback.
-
|
+1 more |
Beta Was this translation helpful? Give feedback.
-
|
Well, this explains why I can't get any single values queries to work for opensearch..... |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
Grouping is not always necessary. It took me like two hours to figure out that was my only problem.
Consider this example:
That's all what I wanted! Now, seeing that the results didn't make any sense, I opened the Network tab and saw the extra layer of aggregation coming from the obligatory "Group By". I just removed it and queried ElasticSearch myself, which produced the correct number!
Am I missing something too obvious?!
Beta Was this translation helpful? Give feedback.
All reactions