Metabase

Know what every Metabase card means, then rebuild the dashboards you rely on.

01

Dot explains your saved questions

Their SQL, and live results under any filter.

Threadanalytics

Ryan Ortiz9:41 AM

@Dot How does the Qualified Pipeline question in Metabase filter deals?

1 reply

DotAPP9:42 AM

6 steps · 40s · Access Online

Open deals over $10K past discovery, excluding renewals.

Source: Metabase’s Qualified Pipeline.

Qualified Pipeline · SQL
WHERE status = 'open'
  AND amount > 10000
  AND stage <> 'discovery'
  AND deal_type <> 'renewal'

Threadanalytics

Priya Shah9:41 AM

@Dot Do all tiles on our Revenue dashboard count revenue the same way?

1 reply

DotAPP9:42 AM

4 steps · 25s · Access Online

No. Two of eight include refunds and use order date.

Source: Metabase’s Revenue dashboard.

Here is the data.

TileRefundsDate
Monthly revenueIncludedOrder date
Revenue by planIncludedOrder date
Revenue by regionLeft outPayment date

Threadanalytics

Daniel Weber9:41 AM

@Dot What does the First Response Time card show for Enterprise last month?

1 reply

DotAPP9:42 AM

7 steps · 45s · Access Online

4.2 hours, faster than any other tier.

Source: Metabase’s First Response Time.

Chart

02

Move dashboards into Dot

On live SQL, each card checked against Metabase.

Threadanalytics

Priya Shah9:41 AM

@Dot Move our Support KPIs dashboard into Dot.

1 reply

DotAPP9:42 AM

6 steps · 41s · Access Online

Rebuilt, and every card matches.

Source: Metabase’s Support KPIs.

Support KPIs9 cards · 3 filters
Open tickets
184
First response
5.1 h
Satisfaction
92%

Threadanalytics

Daniel Weber9:41 AM

@Dot Rebuild the Revenue dashboard with net revenue on every tile.

1 reply

DotAPP9:42 AM

7 steps · 47s · Access Online

Two tiles now read lower: Metabase counted refunds there.

Source: Metabase’s Revenue dashboard.

Revenue8 tiles · net revenue
Net revenue
$2.31M
Refunds
−$84K
This month
$781K

Threadanalytics

Lisa Park9:41 AM

@Dot Email the rebuilt Support KPIs to our support leads every Friday at 8.

1 reply

DotAPP9:42 AM

9 steps · 47s · Access Online

Scheduled.

Support KPIsFridays, 8:00 · 4 support leads

Connect your data.

Start for Free