.png)
After several months of development, we’re excited to announce Count’s new low-code functionality, which gives you the power of SQL joins, calculations, and table creation without a single SELECT statement.
The Count canvas gives data teams unprecedented power to break down complex pieces of analysis, and rapidly explore different approaches, in a non-linear, collaborative canvas.
With today’s release, the experience of exploring data in Count is available to those outside the data team, creating a space where data and business teams can use data to solve the business's biggest problems…together.
Use low-code cells to create new tables from scratch or off an existing analysis. Join your data sources together with a few clicks, and create custom columns and filters with powerful calculations.
Plus, low-code joins and calculations are available on all visual cells, making it faster than ever to dive into results, and explore new trains of thought, for analysts and non-analysts alike.
Cells are the building blocks of Count. Since you can chain cells together, you can quickly build out complex analysis that still makes sense.
However, up until yesterday to build a cell you needed to be able to write SQL or Python.
Now, with low-code cells, the cell-building experience is open to coders and non-coders alike.
This means when a stakeholder wants to explore an analysis further - maybe by filtering the results, further aggregating the table, or even joining that table to another database table, cell, or CSV file - they can do that without writing a single line of code.
Learn more about low code cells here.
We believe data should always be transparent to everyone for it to be trusted. This means you won’t find any black boxes in Count, including in our low-code functionality.
Any low-code cell can be turned into a SQL cell so you can see exactly what code is being generated from that cell.
We knew that low-code functionality wasn’t just for building tables though. Even the most SQL-savvy users know the feeling when you’re building a visual and don’t just want to plot revenue vs. costs, but to create a new column on the fly for profit (revenue - costs).
These kinds of transformations had to be done in SQL or Python, but now with calculations, you can create columns, visual axes, and filters using arbitrarily complex expressions.
These expressions use a DuckDB-like syntax that works on all databases.
To see some examples of the types of expressions you can build, check out the docs here.
Being able to join two or more tables together is a significant step in someone’s ability to confidently analyze data. With Count’s no-code joining, that ability is now available to everyone, without having to train the organization on the difference between a LEFT and INNER join.
You can join tables to any visual or low-code cell, and specify the conditions of that join. Count will generate suggested joins for you to speed up the process and help everyone query data with confidence.
Learn more about no-code joining here.
The canvas is designed to bring data and business teams together to collaboratively solve the biggest challenges.
Whether that means diving into a canvas together to figure out why retention has suddenly dropped, or adopting a more agile approach to building company-wide metric trees, the choice is yours. Our customers are already taking full advantage of this new low-code flexibility to do things like:
Data teams can’t solve the biggest problems alone. Low code is our way of making sure data isn’t just something you look at once a day in a dashboard but is part of how the entire company operates.
.png)
