Altair® Panopticon

 

Text Combination Settings

This section discusses the steps and guidelines to create the text combination graph using the following sample dataset.

 

Sample Table

Auto Key

Gr

Id

Line

Bar

Scatter

Spread

SpreadRef

Stack

1

X

A

3.00

4.00

2.00

1.00

3.0

1.0

2

X

B

4.00

5.00

3.00

2.00

3.0

3.0

3

X

C

5.00

6.00

4.00

2.00

4.0

2.0

4

Y

D

3.00

4.00

2.00

5.00

4.0

4.0

5

Y

E

4.00

5.00

3.00

6.00

4.0

1.0

6

Y

F

5.00

6.00

4.00

5.00

4.0

3.0

 

Steps:

1.     The text combination settings pane is displayed after clicking the Options  button or the Visualization Title (i.e., Text Combination):

 

2.     To build the hierarchical structure in the text combination graph, drag text columns to the Breakdown Items drop area (e.g., Id, Gr, and Auto Key).

 

3.     You can opt to drag columns to the Size, Color, Opacity, Shape, Reference Lines, and Details drop area.

For this sample visualization, we dragged the Id column to the Color and Shape variables drop areas.

 

     

4.     Continue designing the visualization by dragging numeric columns from the Data Table pane to the Visuals variable drop area.

The column (e.g., Line) is added under the Visualizations tab list and, by default, uses the Line graph and the Left Y-Axis alignment.

 

The X axis displays the multi-level hierarchy based on the three columns added in the breakdown (e.g., Id, Gr, and Auto Key). The Y axis displays the added visual member (e.g., Line).

5.     The properties that you can set will depend on the visualization type that you will add.

The general settings include:

 

 

Setting

Description

Title

Title of the visualization.

Visualization

If the visualization is incorrect, instead of deleting, you can just select another one in the Visualization drop-down list. The settings pane will be changed to display the corresponding properties of the selected visualization.

Aggregate

Aggregation method to be used. Default is Sum.

Format

The format that numbers will be displayed in. Panopticon uses the same formatting rules as MS Excel.

Divide By

Select the Divide By value to divide a number:

·         1

·         1000 (by a thousand)

·         10000

·         1000000 (by a million)

·         1000000000 (by a billion)

Y Axis Alignment

The Y-Axis alignment: Left or Right.

Color

The Color variable that will be used for the column:

·         None

·         Shared Single

·         Custom Single

·         Column added to the Column variable

Column/Value Column

The column used for the visualization. If the dragged column is incorrect, instead of deleting, you can just select another column in the Column/Value Column drop-down list.

 

6.     Visual members can be set to display any of the following visualizations:

 

 

·         Line

 

Additional settings include:

Setting

Description

Single Series

Determines whether to use all columns in the breakdown to create a single series or if one column should be used to divide the data into multiple series.

Opacity

Select the Opacity value.

Line Width

Specifies the line width in pixels.

Dot Radius

Specifies the radius of each data point in pixels.

Line Interpolation

Specifies whether the line is Stepped, Linear, or Smooth interpolation.

Value Interpolation Time Gaps

Determines whether time axis gaps (Working Week/Time) are interpolated.

Value Interpolation Na Value Gaps

Determines whether Na value (or missing) gaps are interpolated.

Shade Area Below Line

Defines that opacity shades are applied between the lines and the zero Y grid line.

Shade Area Opacity (%)

Specifies the opacity (transparency) of the shaded area, expressed in percent 0-100 of the opacity value currently set on the line.

Display Last Value

Determines if the flag of the last value will be displayed.

Once enabled, the Show Last Value Title is displayed.

Check the box to display the title of the last value in the flag.

Dash Pattern

Specifies the line pattern. Available options are:

·         Dotted

·         Dashed

·         Solid

 

Sample 1. Single Series is enabled, the Line Width is set to 4, the Dot Radius to 6, and the Shade Area Below Line is enabled.

 

 

   NOTE

When enabling the Single Series, it is recommended to set the Color variable to Shared Single.

 

Sample 2. Single Series is disabled, the Line Width is set to 4, the Dot Radius is set to 6, and the Shade Area Below Line is enabled.

The last column in the breakdown (e.g., Auto Key) is used to divide the data into multiple series.

 

 

·         Spread

 

Additional settings include:

Setting

Description

Reference Column

The field that will be used as the reference line data series.

Line Width

Specifies the width in pixels of the Spread Graph data series lines.

Opacity

Select the Opacity value.

Spread Color Opacity

Specifies the level of color transparency/opacity for the Positive and Negative Spread colors. The value is from 0 to 255 with the default set to 128.

Line Interpolation

Specifies the interpolation mode as Linear, Stepped, or Smooth.

Value Interpolation Na Value Gaps

Determines whether Na value (or missing) gaps are interpolated.

Value Line Color

Specifies the color of the value line data series.

Reference Line Color

Specifies the color of the reference line data series.

Positive Spread Color

Specifies the color when the spread between the value and reference is positive.

Negative Spread Color

Specifies the color when the spread between the value and reference is negative.

 

Sample 3. Single Series is enabled in the Line graph. In addition, in the Spread graph, the Value Column is set to Spread, and the Reference Column to SpreadRef.

 

Sample 4. Single Series is disabled in the Line graph. In addition, in the Spread graph, the Value Column is set to Spread, and the Reference Column to SpreadRef.

The last column in the breakdown (e.g., Auto Key) is used to divide the data into multiple series.

 

 

·         Bar

 

Additional settings include:

Setting

Description

Opacity

Select the Opacity value.

Bar Width

Specifies the width in pixels for each bar.

Show Borders

 

Determines whether borders are drawn around bars. These are only visible if the Bar Width is greater than 1 pixel.

 

 

Sample 5. Single Series is enabled in the Line graph. In addition, in the Bar graph, the Color is set to column Id, the Bar Width to 0.3, and the Show Borders is enabled.

 

Sample 6. Single Series is disabled in the Line graph. In addition, in the Bar graph, the Color is set to column Id, the Bar Width to 0.3, and the Show Borders is enabled.

 

·         Scatter

 

Additional settings include:

Setting

Description

Single Series

Determines whether to use all columns in the breakdown to create a single series or if one column should be used to divide the data into multiple series.

Size

Select the Size variable that will be used.

Shape

Select the Shape value.

Opacity

Select the Opacity value.

Show Borders

Determines whether a border is drawn around each scatter point.

Min Radius

The minimum radius in pixels of the scatter point.

Max Radius

The maximum radius in pixels of the scatter point.

Legacy Shape

Allows older workbooks to be updated and use the shape variable. Default is Use Variable.

Other shapes can also be selected.

 

 

Sample 7. Single Series is enabled in the Line and Scatter graphs. In addition, in the Scatter graph, the Shape column is set to Id and the Min Radius to 3.

 

 

 

Sample 8. Single Series is disabled in the Line and Scatter graphs. In addition, in the Scatter graph, the Shape and Color columns are set to Id and the Min Radius to 3.

 
 

·         Price Band

 

Additional settings include:

Setting

Description

Single Series

Determines whether to use all columns in the breakdown to create a single series or if one column should be used to divide the data into multiple series.

Reference Column

The field that will be used as the reference line data series.

Line Width

Specifies the width in pixels of the Spread Graph data series lines.

Opacity

Select the Opacity  value.

Line Interpolation

Specifies the interpolation mode as Linear, Stepped, or Smooth.

Value Interpolation Na Value Gaps

Determines whether Na value (or missing) gaps are interpolated.

 

 

·         Stacked Bar or Grouped Bar

       

 

Additional settings include:

 

Setting

Description

Bar Width

Specifies the width in pixels of each bar:

NOTE: This is overridden when a column is added in the Size variable. Consequently, the width of the bars will be based on the comparison of their size in relation to where they are located on the X axis.

Show Borders

Specifies whether a border is drawn around bars. These are only visible if the Bar Width is greater than 1 pixel.

 

·         Stack

   

 

Additional settings include:

 

Setting

Description

Single Series

Determines whether to use all columns in the breakdown to create a single series or if one column should be used to divide the data into multiple series.

Show Borders

Specifies whether a border is drawn around stacks.

 

 

7.     The text combination visualization includes an expanded axes pane, which includes specification of the properties for both the Left and Right Y axes.

  

    

Select or specify the following properties:

Setting

Description

Scale

Determines whether the scale of the axis is Linear, Log, or Power.

·         Linear – a change between two values is based on addition e.g., 30, 60, 90, 120, 180, etc.

·         Log - a change between two values is perceived based on the ratio of the two values or based on multiplication.

Once selected, the Base control displays  the value of the common base for the logarithmic scale (i.e., 10).

 

For example, log10(x) represents the logarithm of x to the base 10 e.g., 1, 10, 100, 1000, etc.

You can opt to enter a new Base value then click .

NOTE: Value cannot be lower than 2.

·         Power – Works according to the SIGN(MEASURE)*LOG10(MAX(1, ABS(MEASURE))) formula. Works like the Log scale except it can handle negative values and every value between -1 and 1 is set to 0.

For example, for values between -100 and 100, the axis will be:

-100, -10, 0, 10, 100

Tickmarks

Determines whether the tick marks are set to Automatic, Fixed, or None.

·        Automatic – allows you to set the Tick Format and Preferred Tick Space values.

 

·        Fixed – allows you to set the tick mark’s Value and Label.

 

Click  to add more or  to delete.

·        None – no tick marks are set for the X or Y axis.

Tick Format

Set to From Variable to use the format string that is on the current variable displayed in the axis. Set to Metric Prefix to format the Tick labels in the numeric axes using the metric prefixes.

Preferred Tick Space

The preferred space in pixels between the minor grid lines across the axis.

Inverted

Determines whether the Y or Height axis is inverted.

Show Title

Displays an Axis Title label.

When enabled, you can opt to enter a custom Title for the axis which will override the title of the visualization variable.

Axis Bar Thickness

The margin in pixels for the axis. If set to zero, the axis is removed.

Preferred Tick Space

The preferred space in pixels between the minor grid lines across the axis.

Minor Grid Line

How minor grid lines are drawn across the axis. Allowed values:

·         None

·         Dotted

·         Dashed

·         Solid

Major Grid Line

How major grid lines are drawn across the axis. Allowed values:

·         None

·         Dotted

·         Dashed

·         Solid

Range

The visible range for the Left and Right Y-axis variables 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.

Independent Y-Axis Scaling

Determines whether to have each visualization Y-axis in a cross tab automatically scaled independent of the others.

Title and Format From

The title and format of the Left and Right Axes based on the selected fields.