i have a measurement with format as below:
time available hostname pri_cat product sub_cat type
1 1.1.1.1 pro x php web
1 1.1.1.1 pro x nginx web
i need to calculate my sla,now i can get the sla of each individual sub_cat .
the sla of php: select mean(“available”) from “os” where “hostname”=‘1.1.1.1’ and “product”=‘x’ and “subcat”=‘php’ and “type”=‘web’ and $timeFilter
the sla of nginx: select mean(“available”) from “os” where “hostname”=‘1.1.1.1’ and “product”=‘x’ and “subcat”=‘nginx’ and “type”=‘web’ and $timeFilter
but how can i get the minimum value of these two queries ?