SnapSite 2016A Release Improvements
New Formula Functions
RANK (<number>, <type>, <variable1>:<variable2>)
The RANK() function can be used to select the nth item from a ranked array of variables and display either the rank position, its value, or its percentage value of the array sum. Its primary use is in presenting the dominant Panorama segments, but it can also be used to generate the modal class of a distribution.
<number> = the rank position in the array <variable1>:<variable2>, must be between 1 and the
count of items in the array. Numbers outside this range throw a runtime error
<type> = 1 (returns the rank position of the item)
= 2 (returns the value of the item at the rank position)
= 3 (returns the % of the value of the item at the rank position)
<variable1>:<variable2> is a range of variables, which must be delimited with a “:” (colon)
- Returns the 3rd most prevalent Panorama segment according to household counts
- Returns the % of the population found in the most dominant Panorama segment
- Returns the modal age class (the most commonly occurring value). Note that the function return is the class number and not a description
CLASS (<number>, <bound1>, <bound2>, …, <bound number-1>, <variable>)
The CLASS() function is used to create a classification variable. For example, you could classify rainfall into 7 categories – 0, 0-10, 10-20, 20-30, 40-50, 50-75, and 75+, with the result presented as the class number rather than the actual value.
Please note that in order to enable a class for zero values, ranges are computed as <= for the first class bound and as < for subsequent bounds.
<number> = the number of classes in the classification
<bound x> = the class boundary (e.g. 10,20,30)
<variable> = the variable to be classified
CLASS( 5, 50, 100, 150, 250, CRMTOTC)
- Classifies total crime risk into five categories - <50, 50-100, 100-150, 150-250, and >250. The result will be a number from 1 to 5
- Returns 1 if the median income is below $100K, 2 otherwise. This can be useful in building statistical models which include categorical data.
Panorama is now the default segmentation system for SnapSite and is used for major functions such as Panorama coding (appending codes to records in a file), Profile Reports, MPI reports, and profile rankings. Mosaic is no longer supported, except in database extractions.
Note that myPanorama functionality is not yet available within SnapSite.