.png%3Falt%3Dmedia%26token%3Ddadbeb66-a273-411a-afdd-d51dd957a2bf)
.png%3Falt%3Dmedia%26token%3Ddadbeb66-a273-411a-afdd-d51dd957a2bf)
Visual cells
Making data pretty since 1160 BC*.
Visual cells are where you create visualizations in Count. They can be built from other cells, or directly from database tables.
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
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
FROMstatement, or - selecting one of the
Reference cellshortcuts near the edge of the selected visual
Querying a visual
Visuals that contain more than one mark have multiple queries (and therefore output tables) associated with them — one per mark. The output table that is referenced by another cell is that returned by the lowest non-empty mark.
By default, your visuals will be executed as queries on your data warehouse. If you would prefer to instead perform these queries locally, you may select the Local database option from the cell controls in the right-hand sidebar.
If the visual is built directly from a database table, then this option will not be possible. In this case you should first create a cell that references the database table, then ensure the visual references that cell.
Last modified 2mo ago