Currently in one of our analytic reports we have every Call For Service that was created in the last completed month, and the number of each. We’re looking to also add a column for “Self Initiated” to determine how many of those total were self initiated by the officer in the field vs created by dispatch. Unfortunately CFS created via the Right Click menu in CAD are classified as “Self Initiated” so that doesn’t work.
Is there a custom field/measure we can use to count the same total number of CFS per CFS type excluding those in dispatch by dispatcher name or unique ID number? We can’t use the dispatch role as we have officers who work in there as well part time and don’t want to exclude them.