We are migrating from ElasticSearch to OpenSearch Service and we have to recreate all the dashboards. In one of the dashboards we have a visualization that MUST only show the data/graphic if a condition is met.
In ElasticSearch, I am able to “filter” the data in the visualization while using a formula. Unfortunately, this feature doesn´t exist in OpenSearch Dashboards.
Do you have any idea of how I can create such a “filter” for the visualization?
More context to this question:
we have docs containing the stock information of different bicycles.
The bicycles are owned by different dealers.
Each dealer can set their own price for each bicycle.
I want a visualization that shows the average price of a bicycle model within the stock, BUT this information can only be shown if at least 5 dealers have the same bicycle model in stock .
The amount of available dealers and bicycle models will be dynamic since they will depend on the Date range selected.
Is this possible?
If yes, could you please give me a hint.
Thank you in advance.