# Line Chart Generator for Any Metric Over Time

Source: https://maito.app/workflows/chart-a-metric

Ask Maito for a metric over time and it queries BigQuery or Supabase and sends a chart ready for a deck, with the data behind it and notes on odd points.

Get a chart of any metric over time, ready to paste into a deck.

[Data](https://maito.app/workflows/team/data) · When you ask · Updated October 19, 2026

Works with

-   Slack
-   Email
-   [BigQuery](https://maito.app/workflows/tool/bigquery)
-   [Supabase](https://maito.app/workflows/tool/supabase)

## How do you chart a metric over time?

To chart a metric over time, mention Maito with the metric and date range. It queries BigQuery or Supabase, builds the chart, explains the main changes such as a dip or a jump, and attaches the image and the data behind it. Checking for tracking changes keeps the line honest.

## How it's done today

People screenshot dashboards.

## What Maito does

1.  Pull the data
2.  Make a clean chart

## Example

**Nina** (4:15 PM):

Chart weekly active users for the last 6 months.

**Maito** (4:18 PM):

Weekly active users, Apr 20 to Oct 12: 3,410 to 4,870, up 43%.

• Steady growth of about 2% a week through July  
• Dip of 11% in the week of Jul 6 (US holiday week)  
• Flat through August  
• Jump of 9% the week of Sep 7

**The catch:** the app event for a session was renamed on Jun 1 (session\_start became app\_open). A query on the new name alone shows a false 31% crash in that week. I counted both names so the line is continuous.

From the BigQuery events table. Attached: wau-6-months.png, 16:9 and ready for a slide.

**Nina** (4:20 PM):

Do a version excluding internal users.

**Maito** (4:22 PM):

Attached: wau-6-months-external.png. Internal users are 1.4% of the total, so the shape is the same: 3,360 to 4,800, up 43%.

## How to set it up

When you ask Chart a metric

Set up

Nothing to set up. Ask in Slack or by email whenever you need it.

Connect database

-   BigQuery
-   Supabase

Not connected yet? Your agent sends you a link to sign in.

## What it won't do

It charts what the data holds. If an event was tracked differently over time, it tells you what it did, but you should check that it matches your definition.

## Questions

### What format is the chart?

An image you can paste into a deck, with the data and query attached so you can rebuild it.

### Does it explain odd points?

Yes. It notes dips, jumps and event renames that could make the line look wrong.

### Which databases can it use?

BigQuery and Supabase.

## More data workflows

-   [Answer data questions in Slack Ask a question in plain words and get the number, with the query behind it. Data · When you ask Works with BigQuery, Supabase.](https://maito.app/workflows/answer-data-questions-in-slack)
-   [Explain a dashboard number Know what a number means and how it's calculated. Data · When you ask Works with BigQuery, Supabase, Notion, Confluence.](https://maito.app/workflows/explain-a-dashboard-number)
-   [Check data for problems Spot missing data, duplicates and sudden jumps before anyone trusts a bad number. Data · On a schedule Works with BigQuery, Supabase.](https://maito.app/workflows/check-data-for-problems)
-   [Write and fix SQL Get a working query from a description, or fix a broken one. Data · When you ask Works with BigQuery, Supabase.](https://maito.app/workflows/write-and-fix-sql)
-   [Send a weekly metrics digest Key numbers for the company every Monday, with what changed and why. Data · On a schedule Works with BigQuery, Supabase, Stripe, PayPal.](https://maito.app/workflows/send-a-weekly-metrics-digest)
-   [Review possible duplicate customers before merging See why two customer records might be the same person, then decide. Nothing merges on a shared name. Data · When something happens Works with HubSpot, Salesforce, Airtable, Microsoft 365.](https://maito.app/workflows/review-possible-duplicate-customers-before-merging)

[See all workflows](https://maito.app/workflows)

## Put your AI teammate to work.

Set it up in minutes. Start with this one, and let it earn the next one.

[Put Maito to work](https://maito.app/login?returnTo=%2Fworkflows%2Fchart-a-metric)[Book a demo](mailto:support@maito.app?subject=Maito%20demo)