I am using ELK GA 5.0.0. I have an elasticsearch index, having a string field
datax. That field has values like
I have created a line chart, In Y-Axis, I selected Count. In X axis, I added aggregation of date Histogram. Then I did Split Lines -> Sub Aggregation -> Filters and added
DataC so that I get count of logs containing these values only. Then I made another filter and added
DataE, so that the line shows count of these 2 fields only.
The graph looked similar to the image below;
What I am trying to achieve is not this. I want a single line chart. The value of line should be (
DataC) / (
DataE) . For example, at time T, if the first line has a count of 20, and second line has a count of 2, I want my line to show 20 / 2, which is 10.
Is this possible, or is there any workaround?
Thanks in advance.