I am trying to calculate the mean for two different fields in a log. I can calculate each mean separately, but when I try to include both in the same search I get an error message. Is there a way to calculate two means in the same search? Here is my query:
_collector= ds_jobs "emr_usage" |json auto "fulla.cost", "pyspark.cost" as fulla_cost, pyspark_cost nodrop |avg(fulla_cost) |avg(pyspark_cost)
Here is the error:
Unable to run query: _collector= ds_jobs "emr_usage" |json auto keys "fulla.cost","pyspark.cost","pyspark_cost" as %"fulla_cost",%"pyspark_cost" refonly |avg(fulla_cost) |avg(pyspark_cost). field pyspark_cost not found (1)
Please sign in to leave a comment.