Hello Vineeth Vijay
Can you check if the below Q&A Post helps out to you? Check the detailed answer from prmanhas-MSFT
You just need to tweak the query based upon your alert threshold %
After going through that post, kindly let us know if you have any additional questions.
Happy to help out further !
Regards,
Shiva.