i am trying to create a graph in timelion that shows the average value of a field as long as the field is greater than 0.
For some reason i cannot do that.
writing the following command returns all points on the 0 graph scale: See TLQuery1.JPG
.es(index=eu-multitenant-01*,q='d.Elapsed > 0',metric=avg:d.Elapsed)
when i change it to the following: .es(index=eu-multitenant-01*,metric=avg:d.Elapsed) it works fine but the values take into consideration also the 0 amounts which is not what i need. See TLQuery2.JPG
also writing the following command works: .es(index=eu-multitenant-01*,q='d.Elapsed > 0') - but again this return the count of rows where Elapsed is greater than 0 - not what i need. See TLQuery3.JPG