Hello,
I’m trying to use Opensearch to monitor my solar panels at home. I have uploaded some sample data from which I want to create some statistics.
I have 2 values I want to display: the injected power (from my solar panels) and the consumed power (from the grid)
The problems that I have are:
- the initial values are in kWh, and I wan to have them in Wh (x1000)
- I want to display the consumed power as negative in my graph.
- My timestamp (x-axis) does not contain the date, only the time, while my field has them both
I am using Elastic search at work, and I’m looking for similar features in opensearch, meaning that in this case I am looking to apply a formula to the metrics that I want to graph.
In elastic Stack, I edit the lens, and when I edit the vertical axis, I have a formula tab next to the quick functions.
In Opensearch however, I cannot find such tabs. I have been looking under “data”, “metrix & axes” and “panel settings”.
I’ve also been looking in the documentation, but I could not find much help on the Visualization topic.
Also to be said is that I’m not a black belt in Elastic neither, I’m just starting to learn
Can you please help me with:
- Applying the formulas to my graphs
- Fixing the timestamp format in the X-axis
- Finding some good documentation on the visualization of my data
Thanks a lot!
Wim