Normalizing (date)
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 day?
The value is 50% of the biggest value.
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
From | System.DateTime | - | This is the From column of the data table. | - |
To | System.DateTime | - | This is the To column of the data table. | - |
Data column | System.Double | - | Day type for day type-by-day type normalizing. | - |
Day type | System.String | opt. | Day type for day type-by-day type normalizing. | - |
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
| - | 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