Skip to content
ZillionInfo DataSphereX

Time Aggregation

Time Aggregation aggregates the records of the input attribute data based on the time field.

1. Set the input data

  • Input Data: Attribute data only.

2. Set the aggregation type

  • Calculate Values: Calculate the statistics of multiple records in the same time category.
  • Count Records: Count the number of records in the same time category.

3. Set the output fields

3.1 Caculate values

  • Output Fields: The fields to be added to the new data.
  • Merge Rule: The rule to merge the values of multiple records in a time category.
    • First: Use the value of the first record in a time category.
    • Last: Use the value of the last record in a time category.
    • Join by Semicolon: Concatenate the values of multiple records in a time category with semicolons.
    • Sum: Calculate the sum of the values of the records in a time category.
    • Average: Calculate the average of the values of records in a time category.
    • Count: Calculate the number of the records in a time category.
    • Min: Use the minimum value of the records in a time category.
    • Max: Use the maximum value of the records in a time category.
    • Standard Deviation: Calculate the standard deviation of the values of the records in a time category.

3.2 Count records

  • Count Field: The number of different values of the field is counted.

4. Set the output ID field

  • ID Field (Optional): The records with the same ID in a same time category will be aggregated.

5. Set the time field

  • Time Field: Its values will be used as the time.

6. Set the time category

  • Time Category (Optional): Hour, Day, Day of Week, Day of Week_Hour,Weekday/Weekend, Week, Month, Quarter, Year, and Year_Month. If it is not set, the different values in the time field will be used as time categories.

7. Set the output data

  • Output Data Name: If no name is set, the default is “toolName_time”.

8. Submit

After completing the above settings, click Submit to start the tool.
When it finishes successfully, a message will be shown at the top of the page. You can click the Open Data button to start accessing the data or go to the Data page to view it.