Selecting multiple values with different conditions in the same table

, ,
1

image.png954×361 9.11 KB
this how metrics table in my nagflux database looks like.

time	host 	service	value	
1491488866000000000	ups01slvkonfw03bxilan	Check_BatterryStatus	1	
1491488866000000000	ups01slvkonfw03bxilan	Check_BatteryCapacity	46.93	
1491488866000000000	ups01slvkonfw03bxilan	Check-Load-Current	1612	
1491488866000000000	ups01slvkonfw03bxilan	Check-BatteryVoltage	55	
1491488866000000000	ups01slvkonfw03bxilan	Check-Batteryruntime	600

I am trying to query for hosts with batterysatus =1 and get other service values of that perticualr host into a table like this. Is it possible ?

host 	                Check_BatterryStatus	Check_BatteryCapacity	Check-BatteryVoltage	Check-Batteryruntime
ups01slvkonfw03bxilan	1	46.93	55	600