---
title: "Big Number Chart in Preset"
slug: "big-number-chart"
description: "Description and usage of the Big Number chart in Preset Cloud."
updated: 2023-03-10T18:59:24Z
published: 2023-03-10T18:59:24Z
canonical: "docs.preset.io/big-number-chart"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.preset.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Big Number Chart

## Big Number and Big Number with Trendline Charts

### The **Big Number** chart lets you emphasize an important aggregate metric or KPI (key performance indicator). The **Big Number with Trendline** chart helps you emphasize the recent state of your aggregate metric and want to showcase a trendline. Here are some examples of both charts.

### ![](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/big_numbers.png) Reference Content

If you're new to visualizing data in Preset, we recommend the following reference articles:

- [Creating a Chart](https://portal.document360.io/v1/docs/creating-a-chart): A walkthrough of the overall process of chart selection and creation.
- [Using Preset Chart Builder](https://portal.document360.io/v1/docs/using-preset-explore): How to work with the Chart Builder page, the primary interface used when creating a chart.

## Creating a Big Number Chart

To create a basic Big Number chart, you need to define:

| ![](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/Screen%20Shot%202022-09-13%20at%204.03.12%20PM.png) | **Time (optional)** - You can specify a time range that will be used when calculating the aggregate metric that is visualized. The time grain isn't included in the visualization for the Big Number chart. **Metric (required)** - At the core, this chart shows an aggregate metric as a single number. - You are required to choose a column and an aggregate function you want applied to that column. Some examples: - COUNT_DISTINCT(ride_id): # of distinct rides - AVG(rides): average # of rides **Filters (optional)** - You can add filtering criteria to narrow down the rows / data used for computing the aggregate metric. **Subheader (optional)** - You can define the subheader text that goes under the big number itself |
| --- | --- |

Click **Create** **Chart** or **Update Chart** to generate the queries, run the queries, and visualize the results.

![](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/Screen%20Shot%202022-09-13%20at%204.05.04%20PM.png)

## Creating a Big Number with Trendline Chart

If you instead want to emphasize the recent state of your aggregate metric and want to showcase a trendline, you can use the **Big Number with Trendline** chart instead.

| ![](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/Screen%20Shot%202022-09-13%20at%204.14.29%20PM.png) | **Time (optional)** - You can specify a time range that will be used when calculating the aggregate metric that is visualized. - The time grain you choose here is crucial, as it will be used for generating the trendline by comparing the last X periods. **Metric (required)** - At the core, this chart shows an aggregate metric as a single number. - You are required to choose a column and an aggregate function you want applied to that column. Some examples: - COUNT_DISTINCT(ride_id): # of distinct rides - AVG(rides): average # of rides **Filters (optional)** - You can add filtering criteria to narrow down the rows / data used for computing the aggregate metric. **Options** - **Comparison Period Lag:** the # of periods (using the time grain you chose earlier). The options we chose here will generate a trendline for the last 30 days, on a day-by-day basis. - **S****how Trend Line**: if ticked, shows the trendline. - **Start Y-axis at 0**: if ticked, starts y-axis at 0 instead of the lowest value in the dataset. |
| --- | --- |

Click **Create** **Chart** or **Update Chart** to generate the queries, run the queries, and visualize the results.

![](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/Screen%20Shot%202022-09-13%20at%204.19.58%20PM.png)

Here's the SQL query that was generated by Preset:

```plsql
SELECT DATE_TRUNC('DAY', started_at) AS "__timestamp",
       count(DISTINCT ride_id) AS "COUNT_DISTINCT(ride_id)"
FROM dbt_smukherjee.citibike_trips
WHERE started_at >= '2022-04-01 00:00:00.000000'
  AND started_at < '2022-05-01 00:00:00.000000'
  AND member_casual = 'member'
GROUP BY DATE_TRUNC('DAY', started_at)
LIMIT 5000
```