Launch, grow, and unlock your career in data

March 9, 2012

Displaying Labels on Filled Maps Only When a Particular Criterion Has Been Met

1 comment
Andy Piper from Norfolk Southern, and long-time member and frequent presenter at ATUG, has created this fabulous tutorial.  From Andy:
The ability to display labels onto map locations (and more recently filled maps) has always been present -- simply drag and drop a field you wish to use as the label onto the Label shelf. However, in many circumstances there may simply be too many labels that appear on the map to obtain useful information.
This document will demonstrate how to display labels on a filled map only when a particular criterion has been met (without manually modifying your marks). A measure field called Demand is used in this example, though other measures such a sales, weight, population, etc. can easily be used.  This same process can also be useful when conducting sensitivity analysis.
Download the tutorial here.

1 comment :

  1. I so no reason for using the WINDOW_SUM() table calculation for the situation described, so I would recommend that be removed from the calculation.

    IF Sum([Demand])>=[Label Criteria] THEN Sum([Demand]) END

    is all that is needed.