Support Center

SnapSite 2016A Enhancments

Last Updated: Mar 29, 2016 11:00AM PDT

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
SnapSite includes embedded formulas for the segment number, base value, and percent of base for each of the top three Panorama segments in a geographic area.

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.
Up to 15 classes can be specified.

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.

Contact Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found