Dear
the ticket code it is not part of the filter
this is the query script
SELECT
cr.persistent_id,
cr.type_symbol,
PdmDay(( cr.open_date )),
count(cr.persistent_id),
PdmMonth(( cr.open_date )),
PdmYear(( cr.open_date )),
cr. affected_end_user_admin_org_name,
cr.open_date,
cr.reporting_method_symbol
FROM
cr
WHERE
(
PdmYear(( cr.open_date )) = 2017
AND
PdmMonth(( cr.open_date )) = 5
AND
cr.status_symbol NOT IN ( 'Cancelled' )
AND
cr.tenant_name = 'Consorcio'
AND
cr.type_symbol IN ( 'Incident','Request' )
)
GROUP BY
cr.persistent_id,
cr.type_symbol,
PdmDay(( cr.open_date )),
PdmMonth(( cr.open_date )),
PdmYear(( cr.open_date )),
cr. affected_end_user_admin_org_name,
cr.open_date,
cr.reporting_method_symbol