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

Priya Shah9:41 AM

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

1 reply

Dot9:42 AM

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

Daniel Weber9:41 AM

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

1 reply

Dot9:42 AM

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

Lisa Park9:41 AM

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

1 reply

Dot9:42 AM

4.2 hours, faster than any other tier.

Source: Metabase’s First Response Time.

02

Move dashboards into Dot

On live SQL, each card checked against Metabase.

Threadanalytics

Daniel Weber9:41 AM

@Dot Move our Support KPIs dashboard into Dot.

1 reply

Dot9:42 AM

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

Lisa Park9:41 AM

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

1 reply

Dot9:42 AM

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

David Mensah9:41 AM

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

1 reply

Dot9:42 AM

Scheduled.

Support KPIsFridays, 8:00 · 4 support leads

Connect your data.

Start for Free