ToolZ has several types of data objects for you to work with.

Datatypes

Datatypes represent a specific type of data. 


They have:

  • TRENDING_DATE_LABEL: What the trending date is called for the datatype (e.g., "Signup Date" or "Report Date").
  • DATA_LAST_UPDATED: A timestamp that indicates the last time the data for the datatype was refreshed. Can be formatted using the date formatting options.
  • GROUPS: All of the groups associated with the datatype.
  • PROPERTIES: All of the properties that the datatype has.

Groups

Groups represent a category by which datapoints are classified.


They have:

  • NAME: The name of the group (e.g., "State" or "Region").
  • ID: The ID of the group (e.g. "state" or "client_10_level_4").

Group members

Group members represent a specific instance category to which datapoints belong.


They have:

  • NAME: The name of the group member (e.g., "Massachusetts" or "Region 10")
  • ID: The numeric ID of the group member
  • ORDER_NUM: The numeric sort ID of the group member
  • INDEX: The numeric index of the current record within the data set, starting at 1

Properties

Properties represent attributes of datapoints. 


They have:

  • NAME: The name of the property (e.g., "Score" or "Age")
  • PROPERTY_ID: The ID of the property (e.g. "percent_score" or "age")