Stream Tables

This article contains sections on:

Editing Stream Tables  
Editing Measure Columns  
Fine-tuning Dimension Columns  
Adding User-defined 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. Click Edit Table in the Stream Table.
  2. 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].

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

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

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

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.

 ADDING USER-DEFINED COLUMNS

User-defined 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