Product

4 min read

Why every chart should show its query

A chart without its query asks you to trust it. We put the query, the filters and the excluded rows next to every answer. Here is why.

Theo Marchetti

Clear glass ribbons curving down into a dark blue ground

Two people in the same meeting can look at two charts of "active users" and see different numbers. Usually neither chart is wrong. They count different things, and nobody can tell which, because the definition is hidden.

Definitions drift

An active user might mean someone who logged in, someone who opened a project, or someone who did anything at all. Teams change these definitions as the product grows, and old charts keep the old ones without saying so.

What we show instead

Every answer in Facet carries its working: the SQL, the events it counted, the filters it applied and the rows it left out. You can copy the query, change a filter and run it again. If two charts disagree, you can see why in a minute instead of a week.

Next post

Retention, explained without the jargon

Bring your own question

Facet is free for up to 3 seats. Ask the question from this post and see what comes back.

Bring your own question

Facet is free for up to 3 seats. Ask the question from this post and see what comes back.

Bring your own question

Facet is free for up to 3 seats. Ask the question from this post and see what comes back.

Create a free website with Framer, the website builder loved by startups, designers and agencies.