Count in alert builder

I was attempting to make a rule for syslog messages and how many times the same message appears in 5 mins so: if message appears > 10 times rule is triggered. it does not appear there is currently a way to do this within the alert builder. however the Count function in mysql does work is there any way it could integrated?

You have to create an alert like this:

syslog.timestamp >= macros.past_5m AND syslog.msg LIKE '%MESSAGE TO MATCH%'*

Save it and edit it again. Go to advanced -> set override sql to on and add:
HAVING COUNT(*) > 10

Make sure max alert is 1, the delay is 0 and interval > 5 min (6 min at least)
Alert recovery is off

Hi,
How can we have the value of count(*) in the alert mail ?
Thanks