Data#

Requirements#

The Mosaic Plot panel expects time series data frames, meaning each series must contain at least one field with time type (if multiple such fields exist, the first one will be used)

Three data formats are supported:

1. Multi Frame Data Format#

Hint

This is the default format. It was previously referred to as the Regular Data Format

This data format is applicable where each data frame has a time field, a numeric Amplitude field and a string Breakdown label to differentiate the different series. It can also contain an (optional) additional string label for grouping the different series.

For example, let's assume that we want to plot the number of requests hitting a number of different servers
Each server is located in some region

For the above example, our data will contain a time field, a number field that represents the number of requests, and a string label representing the server name. It might also contain a string label represening the region name.
The data will be presented in multiple frames, where each frame corresponds to a specific combination of label values. For example, each frame might look something like this:

Time Host Region Requests
1647399651000 use1-03 us-east-1 234
1647399656000 use1-03 us-east-1 125
Time Host Region Requests
1647399651000 use1-02 us-east-1 163
1647399656000 use1-02 us-east-1 14
Time Host Region Requests
1647399651000 usw1-01 us-west-1 111
1647399656000 usw1-01 us-west-1 875

Hint

In the above example, it is important to note that Time & Requests are fields, while Host & Region are actually labels

Hint

When using the multi frame data format, rows are mapped to the Breakdown label

2. Heatmap Data Format#

This data format is applicable where each data frame contains only a time field and a numeric value field.

For example, let's assume we want to plot a heatmap of the number of requests over time, in bins representing response time ranges. Basically histograms over time.
For the above example, our data will contain multiple data frames, where each frame has a time field and a value field, whose name represents the bucket (and vertical position in the plot).

The data will contain multiple data frames that look something like this:

Time 100-200
1647399651000 4
1647399656000 12
1647399661000 12
Time 200-500
1647399651000 1
1647399656000 24
1647399661000 4
Time 500-1000
1647399651000 0
1647399656000 10
1647399661000 9

Hint

When using the heatmap data format, each row is mapped to a specific data frame

3. Single Frame Data Format#

This data format is applicable when all of the data is in a single data frame. The data frame must contain a time field, a numeric Amplitude field and a string Breakdown field to differentiate the different series. It can also contain an (optional) additional string field for grouping the different series.

For example, let's assume that we want to plot the number of requests hitting a number of different servers
Each server is located in some region

For the above example, our data will contain a time field, a number field that represents the number of requests, and a string field representing the server name. It might also contain a string field represening the region name.

Our data will be in a single data frame (with no labels, just fields).
It might look something like this:

Time Host Region Requests
1647399651000 use1-03 us-east-1 234
1647399651000 use1-02 us-east-1 163
1647399651000 usw1-01 us-west-1 111
1647399656000 usw1-01 us-west-1 875
1647399656000 use1-03 us-east-1 125
1647399656000 use1-02 us-east-1 14

Hint

When using the single frame data format, rows are mapped to the Breakdown field

Notes#

  • Mosaic Plot expects that each data frame has the same fields
  • Mosaic Plot expects that each data frame be of the same length
  • Mosaic Plot doesn't currently support null values