Summary

Standardize data columns in reference to the parameter, which is calculated for this day. e.g.

  • Which share have different values at the average of the day.

e.g.  A value is 5% of the average volume of the day,

How much is it in comparison to the biggest value of the period?

The value is 50% of the biggest value

Configuration

Input settings of existing table

Name

Value

Opt.

Description

Example

Day type

System.String

-

Day type for day type-by-day type normalizing.

-

From

System.String

-

This is the From column of the data table.

-

To

System.String

-

This is the To column of the data table.

-

Data column

System.Double

-

This column contains data to be standardized. Contrary to others, it is not copied into the target table.

-

Queue

System.String

opt.

Queue for queue-by queue normalizing.

-

Settings

Name

Value

Opt.

Description

Example

Result column

System.String

-

Name of the result column.

-

Normalizing method

System.String

  • To the maximum value
  • To the sum total

-

This parameter specifies whether the maximum value is normalized to 100 or if the sum total of the period featured by day type and queue is normalized to 100.

-

Want to learn more?

Screenshot

Troubleshooting

Nothing known up to now.

Related topics