Adding a Numeric Combination Graph (Legacy)

This section discusses the steps to create the numeric combination graph using the following sample dataset, where: 

cos = COS([deg]*2/360*Pi)

sin = SIN([deg]*2/360*Pi)

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

   

2. Set the following property:

   Setting	Description
   Show Coordinates	Determines whether the graph coordinates (i.e., X-Y plots, or Date/Time-Y plots) on mouse over are displayed in the visualization. Tap the slider to turn it on.

    

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

   

4. To set the X-axis, drag numeric columns from the Data Table pane to the X variable drop area.

   For this sample visualization, the deg column will be used as the height variable.

   

5. You can opt to drag columns to the Size, Color, Opacity, Shape, Reference Lines, and Details drop area.
6. Continue designing the visualization by dragging numeric columns from the Data Table pane to the Visuals variable drop area.

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

   

   The graph displays a single series based on the column added in the breakdown.

7. 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.

    

8. 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, and the Color is set to Custom Single (#2580bd).

     

   • 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 2. Single Series is enabled in the Line and Scatter graphs. In addition, in the Scatter graph, the Color is set to Custom Single (#bb2525).

     

   • 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 the cos column, and the Reference Column to the sin column.

     

   • 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.

      

     Sample 4. Single Series is enabled in the Line and Price Band graphs. In addition, in the Price Band graph, the Color is set to By Sign, the Value Column is set to the cos column, and the Reference Color to the sin column.

     

   • 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 Column is set to the sin column, the Color to the deg column, and the Bar Width to 2.

     

   • 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.

      

   • The numeric 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