This is a really helpful feature for reporting workflows that require a "hard copy" medium in addition to a Dashboard!
Ismael Chivite, I'm having a couple issues formatting the queries in my Summary Report Template. The first one is formatted like others that works, so I don't understand why it's failing. The other is related to filtering by dates. I'm not clear on the proper syntax to achieve what I'm wanting to.
First, this query if producing the following error when I try to create a sample report.
${FireInspections_pts |where:“ActionTaken= ‘approved’ !important”|stats:"count,OBJECTID"}
Next, I'm trying to populate a table showing a total of each inspection type by Month. I have the query working to summarize total inspections by type, but I have not been able to get an expression to work that will parse the counts by a specified date range.
The "Total" (far right) query is:
${FireInspections_pts|where:“InspType=100 !important”| stats: “count,OBJECTID”}
I've tried including date ranges for the January cell, but the syntax does not seem to be correct:
${FireInspections_pts|where:“ReceivedDt = BETWEEN DATE ‘2020-01-01 00:00:00’ AND DATE ‘2020-01-31 00:00:00’”| stats: “count,OBJECTID”}
What am I missing with these two queries?