Stream Tables

This article contains sections on:

Editing Stream Tables  
Editing Measure Columns 
Adding Calculated Measure Columns
Fine-tuning Dimension Columns  
Tagging Dimension Columns
Adding User-defined Dimension Columns  
Concatenating Dimension Columns  
Renaming Measure and Dimension Column Headings

 EDITING STREAM TABLES

To create customer-focused metrics, you can edit Measures and Dimensions values in the Stream Table.
New_Stream_Table.png

Measure values can be:

  • Aggregated according to the aggregate function.
    Note: If the stream source is an uploaded file, aggregate type must be defined for each measure.
  • Associated with a measuring unit.
  • Ignored/included in the streaming process

Dimensions values  can be fine-tuned using:

  • Transformation functions
  • Adding user-defined columns with free-text constants
  • Concatenating two or more existing dimension columns
  • Deleting user-defined and concatenated dimension columns

Note

  • Streaming will take a few minutes - how long depends on your system and the amount of data to be processed.
  • To view the metrics created, navigate to the Anodot Metrics window. 
  • MIissing_aggregation_type_icon.icoindicates that the aggregation type  [Average/Sum] has not been set. Streaming is disabled until the aggregation type is defined for all the values. Aggregation type in uploaded files, must be specified for each value. 

EDITING MEASURE COLUMNS

  1. in the Stream Table window, hover over the Measure column heading you want to edit, to display the Aggregation/Units/Ignore menu What_AggUnitIgnaore.ico .
    Note: To display a truncated column heading, for example Sessions …, drag to the right to increase the column width [Session Duration, Session per Day].

2. i. Select Aggregation to produce the Average or Sum across all instances of the selected 'measure' at a single point.
AggDDMenu.png

  • Average = the default 'measure' meter setting.
  • Sum = default 'measure' counter setting.

Note: 

  • [Optional] Choose Apply to all metrics.
  • The default settings can be overridden. 

2.  ii. Select Units to add a measuring unit.  Choose a unit from the drop-down menu.
AggUnitsDDMenu.png

2.iii.  Select  Ignore, for the 'measure' column values not be included in the Streaming process.
Note: Ignored columns are grayed out. To re-instate the 'measure' values into the streaming process, hover over the column heading, click on the down arrow and click Include.

ADDING CALCULATED MEASURE COLUMNS

Calculated measure columns can be added to the Stream Table before streaming the data to Anodot.

  1. In the Stream Table window, click the Measures + icon, to display the New Column dialog box.
  2. Click Choose to select an operator.
  3. Type a New Column Name.
  4. From the Column drop-down menus, choose the Measures that you want to calculate.
    CalculatedMeasures.png
  5. Click Create New Column
  6. Hover over the new column title to open the Aggregation dialog box; set the Aggregation type.
  7. [Optional] Hover over the new column title to open the Units & Symbols dialog box; set the Units type.
  8. To add more new columns, repeat steps 1-7. 

FINE-TUNING DIMENSION COLUMNS

  1. Click Edit Table in the Stream Table.
  2. To filter, transform or ignore dimensions in the streaming process. hover over the dimension column you want to change  Click the down arrow to display the Fine-tune /[Ignore/Delete] Icon.
  3. i. To transform and filter a dimension, select Fine-tune to display the  Fine-tune dialog box. Continue to step 4.
    Fine-tune_Xform_Filter_DB.png
    ii. To ignore/delete a dimension column in the streaming process, select Ignore/Delete.
    Notes
    - Data collector Dimension column values can be ignored [the dimension values will not be streamed] and then included again in the streaming process.
    - User-defined Dimension columns values are deleted.
    -  Grayed out columns indicated that they are ignored. To re-instate a dimension column into the streaming process, hover over the column heading, click on the down arrow > Include icon.
  4. Click Choose.
  5. i. To Transform a Dimension, select:

ChangeCase

Change case of input string to all lower or all upper case

Prefix

Extract prefix of defined length

Replace

Finds a ‘target’ substring and replaces it was ‘replacement’

Suffix

Extract suffix of defined length

Remove

Remove the string between the Prefix and Suffix. Prefix and Suffix are defined by Regex

Extract

Extract the string between the Prefix and Suffix. Prefix and Suffix are defined by Regex

ii. to Filter a dimension ,select:

Starts with

To include values that start with the specified prefix, use * as wildcard

Does not start with

To include values that do not start with the specified prefix, use * as wild card

Ends with

To include values that end with the specified suffix, use * as wildcard

Does not end with

To include values that do not end with the specified suffix, use * as wild card

Equals

To include values that are equal to the specified text

Contains

To include values that contain the specified text, use * as wildcard

Does not Contain

To include values that do not contain the specified text, use * as wildcard

Matches Regex

To include values that match the specified Regex

Does not Match Regex

To include values that  do not match the specified Regex

Note

  1. If requested, select Yes/No ignore case.
  2. To add more filters and/or Transformers, click the Plus icon
  3. Filters and Transformations will work in the order they are presented

6. Click APPLY.

7.  Repeat steps 2 to 6 to change other Dimensions.

8. Click Stream It to stream the filtered and  transformed data into Anodot for processing.

TAGGING DIMENSION COLUMNS

To ignore a Dimension for metric calculation:

  1. In the Stream Table window, hover over the dimension column title you want to ignore.
  2. Rename the column starting with a #TaggingDimensions.png

ADDING USER-DEFINED DIMENSION COLUMNS

User-defined dimension columns can be added to the Stream Table before streaming the data to Anodot. The new column can included either a constant, a free text output string, or be concatenated by joining two or more existing dimension columns. 

To add a new column with a constant output string

  1.  On the Stream Table, click Edit Table.
  2.  Click the  + icon, to display the New Column dialog box.
  3.  From the Choose drop-down menu, select Constant.
    New_Columns__DB.png
  4. Type a New Column Name.
  5. Type an output string;  for example the Web Site View set in the Stream Query page.
  6. Click Create New Column. The new dimension column is displayed in the Stream Table.
    Note To rename the column heading, hover over the heading and type a new name. The default data collector heading is displayed under the new heading.
  7. To add more new columns, repeat steps 2-6. 
  8. Check that you’ve finished fine-tuning the Stream Table.
  9. Click Stream It.

 CONCATENATING DIMENSION COLUMNS 

To concatenate [join] two or more existing Dimension columns to create one new dimension column.

  1. On the Stream Table, click Edit Table.
  2. To display the New Column dialog box, click the + icon. 
  3.  From the Choose drop-down menu, select Concatenate.
    New_Columns___Concatenate_DB2_.png

  4. Type a New Column Name.
  5. Add a Delimiter - any delimiter can be used. 
  6. Use the Column drop-down menus, to select at least 2 properties.
    Note To add more columns, click the + icon.
  7. Click Create New Column. The concatenated column is displayed in the Stream Table..
  8. [Optional] To rename the column heading, hover over the heading and type a new name.
  9. To add more concatenated columns, repeat steps 2-7.
  10. Check that you’ve finished fine-tuning the Stream Table.
  11. Click Stream It.

 RENAMING MEASURE AND DIMENSION COLUMN HEADINGS

To rename a column heading, hover over the heading you want to rename and type a new name.
Changing_Column_headings.png

Note: The default data collector heading is displayed under the new name. Original user-defined and concatenated column headings are not.

 SEE

Guidelines by Data Source Type

Was this article helpful?
0 out of 0 found this helpful