Periodic reporting via emails

Hi there,

Is there a way to create a task that periodically send data from a query to email addresses in CSV format? Like a daily report?

Thanks

https://docs.influxdata.com/influxdb/v2.0/monitor-alert/send-email/

Thanks Franky,

I looked at the link but it only send a value, I need to send the whole table.

So how do I change this

There have been ${string(v: r._value)} critical statuses.

into something like

data = from()...
...
Hi, here's your data: ${data}

I tried this:

Hi, here's your data: ${data[0]}

It said an internal error ocured.