I have a graph showing 2 Elasticsearch queries “Attempted” and “Failure” as numerical data. Then I use “Add field from calculation” transformation to have a new graph line “Success”. How can I show the cumulative sum line of this “Success”?
I found a workaround, to add a metric “Cumulative sum” at the “Attempted” field, then the “Success” will also be influenced as a cumulative sum. The tradeoff is that I will lose the periodically “Attempted” line, but I can always have it again with another query.