I am using A managed AWS Grafana V8.4.7 and Opensearch as my Datasource.
I am trying to achieve a time series visualization that will show split results of the same metric according to another metric, similar to “Split Series” in Kibana.
Allow me to elaborate - My monitor sends a JSON to Opensearch (which is my datasource) that has many different values, one of the values is “speed”. The thing about “Speed” result is that it cannot be explained without “power” which is another metric. I have four different power values that results in different speeds. What I am trying to achieve is one speed time series visualization that shows 4 different speed graphs, color coded according to the power value. In Kibana this is done by choose the “Split series” → term → and then choosing the metric to split by.
What I did so far is created a time series visualization → chose data source → Metric → Average → Chose “speed” metric.
Apologies for my newbie question, I am creating my first graph and couldn’t find an answer for this topic.
As you can see I have the actual result I am after which is “speed” but I cannot look at speed without considering “power”. Each power delivers different speed so I need to be able to split my graph according to the different number of power numbers that I have (I could have up to 16 different power levels). So I am looking for a way to display many results in one graph, each result color coded according to the different power. Here is what this graph looks like in Kibana:
