The use metric as a threshold for another metric will allow us to create alerts for things that do not have hard coded values or limits.
Example: if Metric A is > Metric B ; Alert
Real world example: I have written two custom metric, one to query the total number of used SharePoint space in GB
drives.quota.used | sum(@)
And one to query the total Space provided by Microsoft. Using 1024 + (BusLics * 10)
[multiply(Licensing[?ProductFriendlyName == 'Microsoft 365 Business Premium' || ProductFriendlyName == 'Office 365 E3'].consumedUnits | min(@), `10`),`1024`] | sum (@)
I could compare the two numbers and trigger an alert if we are out of, or getting low on storage
|Last Reviewed Date||2022-08-05|