Get your data to the right people at the right time.
When speaking to a Head of Data a few years ago, she used a phrase I've been in love with ever since: dashboard detritus. She was referring to the festering heap of unused and unloved dashboards, reports, and ad-hoc analyses that had been slowly accumulating on her team.
The detritus problem is one every data team is familiar with. While many approaches can help a detritus problem, one particularly effective method to fighting back against dashboard detritus is data distribution.
Data distribution ensures the data people need is in the right place so that people can find it exactly when they need it. They don't need to troll through a long list of dashboards or flip through old Slack conversations; it's just right there in their inbox, or in their project Slack channel (where, let's face it, we all spend a lot of time).
To help teams improve their data distribution, this week we launched canvas alerts, a feature that is designed to let you share data with your team right when they need it, and without any searching.
Lots of BI and data modeling tools have alerts. The big difference for Count is that an alert can be just about anything. You can of course send charts or queries every day or week, but you can use the power of custom SQL and triggers to build infinitely complex alerts.
For example, you can use alerts to:
Any query, visualization, or grouped combination of cells, visuals, text, and shapes can be turned into an alert.
To add an alert to a cell, visual, or frame you can click the 🔕 button shown when you select the object:
Now you can see your alert in the Alert menu on the right-hand side:
All alerts will need to be scheduled. This determines when the queries will be re-run against your database to pull the latest information.
If you have a trigger set-up, then whether or not an alert is set depends on the results of the queries run at that time.
You can choose the frequency (hourly, daily, weekly, monthly) and the time of day at which you want your alerted queries to run.
And now, the fun part! All canvas subscribers will receive an email whenever an alert goes out, but you can optionally send an alert to Slack.
Alerts that are sent to Slack channels will be visible to all members of the channel even if a member does not have access to that canvas.
The end result is an incredibly powerful and quick way to distribute data to the people that need it, maybe even before they know they need it.
Check out the complete video intro to alerts here 👇 or check out the documentation.
