Punchcard

[ 1 Overview ] [ 2 What data do I need for this widget? ] [ 3 Creating a punch card ] [ 4 Working with punch cards ] [ 5 Query example ]

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

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:

Query	Required field	Column added

Query	Required field	Column added
`from demo.ecommerce.data group every 5m by statusCode, bytesTransferred, method every 5m`	Partitioning	statuscode
	Value	responseTime
	Grouping Colors	method