Matrix

Matrix Description:

  • Matrix displays a series of squares, arranged by group and time, in the style of a pivot. The squares are shaded according to each metric value.

  • Field 1 - Group - This field will represent the categories along the Y axis.

  • Field 2 - Time - This field will represent the categories along the X axis. This field must have the function set to Group(Year & Month).

  • Field 3 - Metric - This field will represent the value of each square.

  • Notes:

    • Matrix can only render so many squares. If you aren’t getting enough data on the time based X axis, try filtering out some items from the group based Y axis.

General Field Definitions:

  • Group - This column can be any data type, aggregated or not aggregated. These columns are used to group data in other columns, and often serve as the axis or scale of a particular visualization.

  • Time - This column must be a Datetime data type.

  • Metric - This column can be any data type. It is generally an aggregate, and most commonly a numeric, but does not have to be. These columns are the elements that are being charted, mapped, or displayed on your visualization.