SWQL Query for combining different custom properties average

makecrazy

Hi,

Need help to get average availability of specific word in 3 different custom properties

for reference , mentioned is average availability  of custom properties ( Media_Type_1 , Media_Type_2 , Media_Type_3 ) need to have all "DSL" average availability

Availability	Timestamp	Media_Type_1	Media_Type_2	Media_Type_3
97.51%	12/1/2023			DSL
99.05%	12/1/2023		DRS
97.08%	12/1/2023		DSL
99.25%	12/1/2023		Fiber
99.96%	12/1/2023		LTE
97.86%	12/1/2023		VSAT
99.60%	12/1/2023	DRS
96.47%	12/1/2023	DSL
96.50%	12/1/2023	Fiber
92.31%	12/1/2023	LTE
96.73%	12/1/2023	VSAT
100.00%	12/4/2023			DSL
99.31%	12/4/2023		DRS
96.80%	12/4/2023		DSL
97.91%	12/4/2023		Fiber
97.00%	12/4/2023		LTE
98.40%	12/4/2023		VSAT
99.74%	12/4/2023	DRS
95.30%	12/4/2023	DSL
97.69%	12/4/2023	Fiber
92.31%	12/4/2023	LTE
97.23%	12/4/2023	VSAT
100.00%	12/5/2023			DSL
98.49%	12/5/2023		DRS
95.85%	12/5/2023		DSL
97.04%	12/5/2023		Fiber
97.79%	12/5/2023		LTE
97.21%	12/5/2023		VSAT
99.80%	12/5/2023	DRS
96.19%	12/5/2023	DSL
98.03%	12/5/2023	Fiber
92.25%	12/5/2023	LTE
97.41%	12/5/2023	VSAT