Ticker Board Parameters

Fields

1. In the Data area on the right, select a dataset, and double-click or drag required dimension and metric fields to the corresponding areas on the Fields tab.
2. Set a filter.
   1. Find the data field you need in the dimension and metric lists within the data column.
   2. Click next to the field you wish to filter and you will be directed to the filter settings page.
   3. Click OK.

      Table 1 Filter parameters

      Type	Parameter	Description
      string	Condition	Filter Mode: The options are Condition and Enumeration. Condition Type: The options are And condition and Or condition. Filter Condition: The options are Exact match, Contain, Start with, End with, Not match, Not contain, Null, and Not null.
      	Enumeration	Query Mode: The options are Single-select and multi-select. Filter Condition: The options are >, ≥, <, ≤, =, ≠, Null, and Not null.
      Metric	Condition Type	The options are And condition and Or condition.
      	Filter Condition	The options are >, ≥, <, ≤, =, ≠, Null, and Not null. You can select Before aggregation and After aggregation for data. NOTE: If you select Before aggregation, data is filtered before aggregation. If you select After aggregation, data is filtered after aggregation. For aggregation concepts, see Creating a Dataset. You can click Create Filter Condition to set multiple filter criteria.
      Date	Range value	Select a time range for filtering.
      	Single value	Set a single time for filtering.
      	Condition	You can select And condition or Or condition as the condition type and select filter condition like >, ≥, <, ≤, and =. You can click Create Filter Condition to set multiple filter criteria.

3. Set the maximum number of query results.

   Enter the maximum number of records that can be returned in the text box. The default value is 1000.

4. Set automatic refresh.

   The auto refresh interval supports the following options: no refresh, 1 minute, 5 minutes, 15 minutes, and 30 minutes.

Styles

• Size/Position
  • W: width of the target, in pixels.
  • H: height of the target, in pixels.
  • X: position of the target on the canvas, in pixels.
  • Y: position of the target on the canvas, in pixels.
  • Opacity: Adjust the transparency of the target on the canvas using a slider or by manually entering a percentage. A higher percentage means lower transparency.

  Figure 1 Size/Position

  
  
• Global Style
  • Alignment: Select an alignment method for the ticker board. The value can be Center Horizontally, Left, or Right.
  • Spacing: Enter a value or click the buttons to set the distance between the digits and the upper edge of the target.
  • Always Animate: After this function is enabled, the number on the ticker board changes dynamically as the data changes.
  • Animation Duration: Enter a value or click the buttons to set the duration for playing animation once. The unit is milliseconds.
• Title
  • ShowTItle: Select this to show the title of the ticker board.
  • Title Name: Enter a title for the ticker board.
  • Alignment: Select an alignment method for the title. The value can be Top center, Top left, Top right, Bottom Center, Bottom Left, or Bottom Right.
  • Font: Select a font for the title.
  • Font Size: Set the font size for the title.
  • Color: Select a font color for the title.
  • Font Weight: Set the font width of the title text.
• Numeric
  • Decimal Control: Select this to further set the Decimal and Delimiter parameters.
  • Thousand Separator: Set a value's thousand separator for easier readability.
  • Font: Select a font.
  • Font Size: Set the font size.
  • Color: Select a font color.
  • Font Width: Set the font width.
  • Digit Spacing: Enter a value or click the buttons to set the interval between digits.
  • Left and Right Padding: Set the alignment distance between the left and right.
  • Top and Bottom Padding: Adjust the padding to set the space between content and the top and bottom margins.
  • Background Color: Select a background color.
  • Borderline options: You can set the style, width, rounded corners, and color of the borderline.
• Growth Trend
  • Custom Icon: Upload an icon by entering a URL or selecting a file from your local computer.
  • Content: Input a symbol to represent the trend of growth.
  • Font: Select a font.
  • Font Size: Set the font size.
  • Color: Select a color to indicate the growth.
  • Font Weight: Set the font width.
• Decline Trend
  • ShowDecline Trend: Select this to further set the following parameters.
  • Custom Icon: Upload an icon by entering a URL or selecting a file from your local computer.
  • Content: Input a symbol to represent the trend of decline.
  • Font: Select a font.
  • Font Size: Set the font size.
  • Color: Select a color to indicate the decline.
  • Font Weight: Set the font width.
• Prefix/Suffix
  • Content: Enter the prefix/suffix.
  • Font: Select a font.
  • Font Size: Set the font size.
  • Color: Select a color.
  • Font Weight: Set the font width.

Interactions

1. Click Interactions.
2. Expand Interaction Definition and click Edit interaction event.

   Figure 2 Edit interaction

   
   
3. Set Event to Click.
4. Click Add Action to add an action. Actions can be changed between hidden and visible states, with different action values displayed depending on the selected widget.
5. Click OK to complete the setting of the interaction event.
   Note

   • Data filtering operators are categorized by string, number, and date types.
     • String operators support exact matches, inequalities, inclusions, exclusions, prefixes, suffixes, and checks for emptiness.
     • Number operators allow for equality, inequality, range comparisons, and checks for emptiness.
     • Date operators support equality and range comparisons.