How to include a count of 0 value in my report.
I am trying to build a very basic report to set up alerts off of, but struggling with getting values of 0 to show in the report to trigger my alert.
The two columns I have are incidents.interface_id and count(incidents.i_id). When I run the report I want it to show how many emails are on each interface filtered by the create date, but currently when I run the report if there are no incidents on that interface then the line item just doesn't show up. I want the interface id to show up with a 0 if there are none.