How to send multiple values in a single alert notification email?

Hi all,

I am using InfluxDb. I create a table called “weather” with few columns like temp, humidity, city, state, country, zip.

I set an alert notification for temperature. When value of temp column of any city touch 40.0, Grafana sends email notification to recipients.

Now, I want to show other information like city, state, zip along with temp value in Email. Is it possible? If yes could you guide me how to do?

Thanks

checkout alert notification templates and influxdb alias-patterns.