Can we send Analytics report only when there is data(results) ?

[IAM_99]

Hi Team,

We have analytics report scheduled , How to send email - only when there is result set/data returned by sql query.

[rushikeshvartak]

Use below condition in TO email template

<%if (totalRecords.equals(0)) print "NULL" else print "${ownerEmail}" %>