Share
Explore

icon picker
KPIs with Snowflake

Display key metrics powered by your data in Snowflake.
info
Sync in key performance indicators (KPIs) from Snowflake to create customizable and interactive dashboards of your data. Add or edit the queries in the table, then select the metric for each callout box and adjust the icons as desired.
mouse-left-click

15,163

Active Users
chair

11,840

Enterprise Seats
money-bag

$
870,315

Revenue

Source data

Refresh data
Snowflake queries
0
Name
Query
i
Value
1
Active Users
SELECT
ROUND(SUM(c.paid_seats) * 0.555) AS value
FROM
SAMPLE_DATA.ACCOUNT_PLAN.CUSTOMERS c
15,163
2
Enterprise Seats
SELECT
SUM(c.paid_seats) AS value
FROM
SAMPLE_DATA.ACCOUNT_PLAN.CUSTOMERS c
JOIN SAMPLE_DATA.ACCOUNT_PLAN.PLANS p USING (plan_id)
WHERE
p.name = 'Enterprise'
11,840
3
Revenue
SELECT
SUM(c.paid_seats * p.price_per_seat_usd) AS value
FROM
SAMPLE_DATA.ACCOUNT_PLAN.CUSTOMERS c
JOIN SAMPLE_DATA.ACCOUNT_PLAN.PLANS p USING (plan_id)
870,315
No results from filter
Snowflake query results
0


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.