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