In this graph, the discs are used to represent values over time for a set of parameters. The size of each disc is proportional to its value.
What data do I need for this widget?
The option to create this chart will be disabled unless your query contains at least a column with numeric values.
Creating a punch card
Go to Data Search and open the required table.
Perform the required operations to get the data you want to use in the chart.
- Select Additional tools → Charts → Diagrams → Punch Card from the query toolbar.
Click and drag the column headers to the corresponding fields. This chart requires you to select three fields:
Required field Data type Partitioning Any type but json Value float, integer, duration Grouping colors (optional) Any type but json
- The punch card is displayed.
Working with punch cards
Hover over a disc on the chart to see its value or over a variable on the right to see all the values of the row.
Click on the Global size toggle at the top left to change the scale for the size of the discs. When activated, the size will be relative to the overall values; when deactivated, it will be relative to the values of the row.
You can recreate the example shown in the picture above with the data from the following query and mapping the fields as follows:
from demo.ecommerce.data group every 5m by statusCode, bytesTransferred every 5m
|Required field||Column added|