How do we MAKE ESM include all of the event totals in a report and include zero sum totals?

[vigneshwar]

There should be built in dashboards and /or data monitors in the Adminstration Section. Look for the one for the event count. That should expose you the filter that is used in the Dashboard. Take that filter query as template for what you need to do and write a query and call it from a Report.

Thanks

[klfujiwara]

thanks for the effort... I can pound around in the interface and look for dashboards with queries and related all day, already did that. If you have an EXAMPLE, it would help.

[katzmandu]

The easiest way is to make a variable, initialise it to "0" and make sure your report is designed to display that variable. You'll add anything you find in your Count from your report to that variable.