Query Details
Direct Report
Query
Heartbeat | project Computer , Category |where Category contains "Direct" |distinct Computer
Explanation
This query selects the "Computer" and "Category" columns from the Heartbeat table. It then filters the results to only include rows where the "Category" column contains the word "Direct". Finally, it returns only the unique values in the "Computer" column.
Details
Rod Trent
Released: March 26, 2020
Tables
Heartbeat
Keywords
Heartbeat,Computer,Category,Direct
Operators
projectwherecontainsdistinct