Text Combination Settings (Legacy)

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

Sample Table

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. Select the checkbox 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 on the basis of 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.

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support