This sections has information about the advanced reporting using KQL.
Optimizing KQL reports
KQL matrix reports are broken after an upgrade
KQL condition & operator reference
KQL query to pull tickets created by staff with 'As a user' or 'Send an email' option