Size Variable Configuration

The Size variable is available in Circle Pack, Donut Chart, Donut Gauge, Map Plot, Network Graph, Numeric Needle Graph, Numeric Stacked Needle Graph, Pie Chart, Scatter Plot, Stack Graph, Table, Treemap, Timeseries Combination, Timeseries Scatterplot visualizations.

Size Variable Configuration

1. Click the down arrow icon to the left of the Size variable.

This displays the configuration panel. Initially, the variable has an [Empty] value.

2. Check the [Empty] box to enable this value.

Clicking on the [Empty] value highlights this selection and currently displays as the associated value of the Size variable.

This means that there is no value associated to the Size variable and the size will either be uniform or not displayed in the graph.

3. To associate other columns from the data table, drag and drop them to the Size variable area. Select one to display the corresponding configuration panel.

4. Enter a label for the Size variable in the Variable Title field.

You can parameterize the variable title to support dynamic schema in the dashboards.

5. The Format field lets you specify the format that numbers will be displayed in. Panopticon Designer (Desktop) uses the same formatting rules as Excel.

6. You can also specify an aggregation method in the Aggregate field.

The default value is Sum.

The Size variable supports a number of other aggregate types as shown below.

 

1. • If the aggregation method is set to PercentOfTotal, the Display Net Value section enabled.

1. If this is checked the Net Value will be displayed in brackets after the Percentage of Total in the detail popup.

2. 

3. Then set the Format.

2. • If you set the aggregation method to Cumulative Sum, Cumulative Sum By Max, Ratio, Percent of Weight Parent, Percent Weight of Total, Weighted Harmonic Mean, Weighted Mean, or Weighted Sum, the Weight Column drop-down list is enabled that allows you to select the weight column to be used.

1. 

3. • If you set the aggregation method to Percentile, the Percentile drop-down list is enabled and displays a list of values that can be used to calculate the value of the selected percentile. Default is 50.

1. 

4. • If you set the aggregation method to Harmonic Mean, Max, Mean, Min, Product, Weighted Harmonic Mean, or Weighted Mean, the Display Difference to Total section is enabled

1. 

2. If this is checked, the difference to total will be displayed in brackets after the aggregation value in the detail pop-up.

7. Select the Divide By value to divide a number:

8. • 1

   • 1000 (by a thousand)

   • 10000

   • 1000000 (by a million)

   • 1000000000 (by a billion)

8. The visible range can either be calculated dynamically (Dynamic Range) or set between predetermined limits by selecting Fixed Range. This enables the Min and Max text boxes and populates them with default values taken from the data set.