Hopefully you can help me with this question I have about visualizing timelion calculation result.
Let's say there is a command A that runs and takes certain time to run. Later command B was introduced that does the same thing but faster. For each command I post into elastic search document with
command fields. What I want to accomplish is to display amount of time saved by introducing command B, given that A and B will be used in parallel for some time.
It looks like that in order to calculate this I have to do:
(AvgA - AvgB) * CountB
AvgA - is average duration of command A
AvgB - is average duration of command B
CountB - count of home many times command B were ran.
So I came up with this timelion script to calculate it
$A = 'command:"A"', $B = 'command:"B"', $ACount = .es(index='index', q=$A, metric=count).aggregate(sum), $BCount = .es(index='index', q=$B, metric=count).aggregate(sum), .es(index='index', q=$A, metric=sum:duration).aggregate(sum) .divide($ACount) .subtract( .es(index='index', q=$B, metric=sum:duration).aggregate(sum) .divide($BCount)) .multiply($BCount)
As a result of this I'm getting graph with steady horizontal line where Y axis represents result of this calculation. What I would want is to show this in form of a number instead. It looks like timelion has
.points() which will represent it in form of bars or points. It doesn't seem like there is a way to represent this in form of a number.
The other question I have. Is there a way to do this calculation that I'm doing in
metric field, so that I can draw graph where X axis will be time and Y axis will be result of this aggregation for the specified aggregation interval. So that, this way I can build cumulative graph for example.