Skip to main content
Skip table of contents

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.

CODE
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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.