Count
count.co
  • Getting Started
    • What is Count?
    • Count FAQ
    • Intro to your workspace
    • Example canvases
    • Getting started guides
      • Set up your workspace and projects
        • 1. Review workspace settings
        • 2. Create and organise your projects
      • Canvas orientation
      • Your first ad hoc analysis
        • 1. Examples and templates
        • 2. Build your first queries
        • 3. Create visuals
        • 4. Caching, local cells and scheduling
        • 5. Collaborating with a stakeholder
      • Your first report
        • 1. Examples and templates
        • 2. Filters and control cells
        • 3. Sharing your report
        • 4. Alerts
  • Connect your data
    • Database connection overview
      • Athena
      • Azure Synapse
      • BigQuery
      • Databricks
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
      • Redshift
      • Snowflake
    • Refresh database schema
    • Upload CSV files
    • dbt integration
      • ☁️dbt Cloud integration
      • 👩‍💻dbt Core integration
  • Import & Export
    • Import from other tools
      • Import Miro files
      • Import SQL files
      • Import Google Sheets
      • Import Jupyter notebooks
    • Export code and results
      • Export compiled SQL and Jinja-SQL
      • Export CSV files
      • Export images and PDF files
  • THE CANVAS
    • Navigating the canvas
      • Canvas tool bar
      • Data sidebar
      • Customizing the canvas
    • Canvas objects
      • Cells
      • Text and markdown
      • Shapes and tools
      • Sticky notes
      • Frames
      • Images
      • Embeds
      • Stamps
      • Grouping objects
      • Object order and alignment
      • Locking objects
      • Scaling objects
      • Shared styles
    • Overviews
    • Templates
    • Count AI
    • Alerts and subscriptions
      • Slack integration
    • Keyboard shortcuts
  • Querying data
    • Cells overview
      • Dynamic query compilation engine
    • SQL cells
      • Referencing other cells
      • Jinja templating
      • SQL formatting
    • Python cells
    • Visual and low-code cells
      • Calculations in visuals and low-code cells
      • Joins in visuals and low-code cells
    • Control cells
      • Single and multiple selects
      • Date controls
      • Text, number, and boolean controls
      • Custom control cells
    • Local DuckDB cells
      • DuckDB on the server
    • Query caching and scheduling
    • Manage queries and results
    • Troubleshooting
  • Visualizing data
    • Visualization overview
    • Templated visuals
    • Custom visuals
      • Marks
      • Facet
      • Subplots
      • Style
      • Filters
    • Formatting a visual
      • Axes
        • Secondary Axis
      • Colors and labels
      • Legends
      • Tooltips
    • Column summaries
    • Dynamic text
    • Every Visual Under the Sun
  • Presenting and Reporting
    • Reports and Slides
  • Count Metrics
    • Intro to Count Metrics
    • Build and edit a catalog
    • Views
      • Creating views
      • Customizing views
    • Datasets
      • Creating datasets
    • Save changes to the catalog
      • Catalog validation
      • Version control
    • Exposing catalogs to the workspace
    • Caching in Count Metrics
    • Using the catalog
      • Explore from cell
  • Sharing and Permissions
    • Real-time collaboration
    • Comments
    • Sharing permissions
    • Shared links
    • Embedding canvases
  • History and Versions
    • Version control
    • Duplicating and merging
    • Data snapshots
  • Settings and administration
    • Workspace settings
      • Workspace members
      • Groups
      • Tags
      • Billing
      • Single sign-on (SSO)
        • Okta
        • Entra ID
        • JumpCloud
        • Google
        • Generic OIDC
      • Brand
    • Connection settings
    • Project settings
    • User settings
    • Roles and permissions
  • Quick guides
    • Interactive control guides
      • Date ranges
      • Date groupings
      • Search
      • Select All
  • Resources
    • Join the Slack community
  • Blog
  • Security overview
  • Terms of use
  • Pricing FAQ
Powered by GitBook
On this page
  • Introduction
  • Creating a template
  • Editing a template
  • Creating a canvas from a template
  • Inserting a template into a canvas
  1. THE CANVAS

Templates

Sped up creating repetitive or standardised layouts by combining objects into reusable templates.

PreviousOverviewsNextCount AI

Last updated 8 months ago

Introduction

Canvas templates are special canvases which are designed to allow sharing common logic and layout across your project or workspace.

When a canvas has been marked as a template:

  • That canvas will appear in the templates list

  • It will be possible to pin that canvas to the 'New canvas' group in a project

Templates are very flexible - they can be designed as a starting point for an entire new canvas, or they can be much smaller and contain some commonly-used controls or logic, or even just a single cell with a bunch of common Python functions.

Creating a template

Templates are created from a whole canvas, or a selection of objects. To create a template from the whole canvas:

  • Click the Save as template option from the design bar when no objects are selected.

  • Choose the Save as template option from the File menu.

To create a template from a selection of objects, select the objects and click Save as template from the design bar.

In all cases, the template dialog will appear which allows customising various properties of the template:

  • Template name - this will be the title of the new template canvas that is created.

  • Description - the description of the template.

  • Project / workspace - should this template be available to members of this project, or the whole workspace?

  • Select preview area - choosing this option will allow fine-tuning the area of the template that thumbnails are generated for, in case you'd like to highlight a particular area of the template.

  • Upload image - choose this option to upload a custom thumbnail image for this template.

These properties can also be updated later after the template has been created.

Editing a template

Remember - templates are just canvases! To edit a template, just navigate to it and edit it as you would any other canvas. All of the other canvas rules apply, including realtime multiplayer editing, version control, permissions etc.

There are just a couple of differences to be aware of when editing templates:

  • Alerts cannot be added to a template

  • Changes to templates are not immediately published - only the latest version of a template is used when it is imported in other canvases. To make your changes available to other members of your workspace, click the Update template button to publish those changes. (Note - unpublished changes to a template are saved continuously, as with all canvases.)

Creating a canvas from a template

There are several ways to start a new canvas from a template. In all cases, the contents of the latest version of the template will be copied into a new canvas.

  • Right-click the template from the project home page and choose Create canvas from template:

  • If the template has been pinned to the project, choose it from the New canvas list

Inserting a template into a canvas

To insert the contents of a template into an existing canvas, click the Add template button in the corner of the canvas:

The templates dialog will be opened, which allows navigating the custom templates in your workspace, and the built-in templates designed by the team at Count:

To insert the objects from one of these templates, hover over it and click the Use template button. To view an interactive preview of the template, click the Preview button:

When inserting objects from templates:

  • Any template cells with conflicting names will be renamed.

  • Any images and CSV files will be copied into your canvas.

  • If a template cell refers to a database connection that you do not have access to, it will show an error.

Publishing a template is really just saving a new version of the template - check previous versions in the .

Any will be copied into your canvas.

version history
shared styles
The template dialog options.
Editing a template
View a live preview of a template.