Count docs
Search…
⌃K
Links

Visual cells

Making data pretty since 1160BC*
Visual cells are where you create visualizations in Count. They can be built from a:
  • SQL cell
  • CSV cell
  • database table

Creating a visual cell

There are a few ways to create a visual cell:
  1. 1.
    Drag in a column from the data sidebar
  2. 2.
    Click one of the 'Create visual' shortcuts near the edge of a selected cell
  3. 3.
    Click the 'Visual' button in the canvas control bar
  4. 4.
    Use the keyboard shortcut V

Building a visual

See the following sections to learn more about how to build visuals in Count:

See the output table of a visual

In any visual, you can toggle between the visual and the table of results. This allows you to see the row-level detail of your visual.
Seeing visual results table

Querying a visual

You can query a visualization to continue your analysis (think: Pivot your data, then query the resulting pivot table).
Reference a visual cell by:
  • building a SQL cell that references the visual cell name in the FROM statement, or
  • selecting one of the 'Reference cell' shortcuts near the edge of the a selected visual
Querying a visual
*Gotta love wikipedia.