I have been experimenting with visualizations and wanted to know if there is a way to divide the value of a field?
I would prefer not to have to write a script. I am looking for a simple "calculation" or "division" option in the tsvb/linechart visualizations but have not been able to find anything.
The closest I have come to success was doing a filter ratio in tsvb but somehow it always returns 0.
Any help is very much appreciated.
This is what I tried in tsvb so far. Maybe someone knows what I am doing wrong?
I want to divide the field index_stats.total.search.query_time_in_millis by the field index_stats.total.search.query_total.
I tried all kinds of values for the numerator/denominator fields, the current input in the picture is not the only thing I tried. I also tried the names of the fields I want to divide.