Skip to main content

Unanswered questions

2 Topics
D
Novice III
daniel.bouckNovice III
asked in Analytics Module (Data Explorers) Group
Custom Field

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.

463
DavidSchwindt
Mark43 Team Member
6 months ago
ajminton
Contributor I
ajmintonContributor I
asked in Analytics Module (Data Explorers) Group
Data Lake, converting Country code

Here’s a Data Lake questions.  In the DEPT_36245898717.analytics_rms.vw_person_addresses table , there’s a Country field, which is a number.  I would like to convert that number to the name of the matching Country.  For example, the United States is always 840 and Canada is 124, etc.  What table  within the Data Lake is available to convert the number to the Country?  I checked a few places like the attributes , but couldn’t find something to link to.  TIA

613
ajminton
Contributor I
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings