Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
Opensearch Dashboard V1.19
Browser: Brave
Operating System: Windows 10
Describe the issue:
Hi, I’m configuring an Opensearch dashboard and it loads all the json files correctly.
What I’m trying to do is to display a gauge which is based on 2 different fields.
Let’s simplify it:
- There are 4 json files each of them carrying the fields Errors and Events.
I want a gauge that displays the sum(Errors) over the sum(Events).
So, I select “Gauge” from my dashboard, I select Metric, Aggregation: Sum and I select the Field I need, in this case Errors.
The screenshot attached shows the sum(Errors) which is correct but I want to normalized it over the total event numbers which should be given by sum(Events). How can I perform this latter operation?
I tried playing around with Advanced: JSON input but it seems this can only operate within the boundary of 1 field and not both of them.
Any suggestion is appreciated, thank you.
Configuration:
Relevant Logs or Screenshots:
