Punch card

Overview

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

1. Go to Data Search and open the required table.

2. Perform the required operations to get the data you want to use in the chart.

3. Click the gear icon on the toolbar and select Charts → Diagrams → Punch Card.

4. 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

5. 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.

Query example

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