NQL countif()

The countif() function counts the number of rows that match specified criteria. It accepts extra arguments, the conditions that determine which rows to include. Provide one or more conditions using bitwise operators.

The following query returns a ratio of poor calls. It includes two conditions that filter rows with either poor audio or poor video quality.

collaboration.sessions during past 24h
| summarize ratio_of_poor_calls = countif(session.audio.quality = poor or session.video.quality = poor) / count() by connection_type

Connection type	Ratio of poor calls
Ethernet	0
Wi-Fi	0.01
Cellular	0.13