Show one important number for a selected time period, how it changed during that period, and an optional comparison.
Select the KPI with Trend block and click Edit (1). Use the Data, Block and Card tabs (2) to configure it.
A KPI with Trend shows three things: an important number, a small line showing how that number changed, and an optional percentage showing whether it increased or decreased.
For example, the block can show $12,000 in revenue for this month. The line shows how revenue moved during the month. The comparison can show that revenue is 20% higher than last month.
Select the block and click Edit to configure its Data, Block, and Card tabs.
Understand the settings tabs
1Data
Choose what information the block uses.
2Block
Change how the information is displayed.
3Card
Style the container around the block.
Start with Data:The block needs information before it can show anything. The Block and Card tabs are optional. If you do not customize them, the block and its card follow the dashboard theme. Use these tabs only when you want this block to look different from the theme.
Configure the Data tab
Choose the date and value used to build the KPI and its trend.
1. Data Source
Required
Choose the table that contains both the date and value columns.
2. Trend Label
Required
Choose the date column used to order the sparkline and calculate comparison periods. Only date columns are available.
3. KPI Value
Required
Choose the column to measure and its Calculation Mode. This creates both the large KPI number and the points in the trend line.
How Calculation Mode changes the result:The selected mode turns many source values into the number plotted by the block.
Example values:102020
Sum
50
Average
16.7
Minimum
10
Maximum
20
Count
3
Count Distinct
2
Count Distinct returns 2 because the values contain two unique numbers: 10 and 20.
Choose Sum for a total
Use it for values you want to add together, such as total revenue, units sold, or hours worked.
Choose Average for a typical value
Use it for questions such as average order value, average rating, or average response time.
Choose Minimum for the smallest value
Use it to find the lowest price, shortest time, or smallest result.
Choose Maximum for the largest value
Use it to find the highest sale, longest time, or largest result.
Choose Count to count values
Use it to answer questions such as how many orders, customers, or records contain a value in the selected column.
Choose Count Distinct to count unique values
Use it when repeated values should count once, such as the number of different customers, countries, or products.
The available modes depend on the column type. Number columns support every mode. Text and date columns support Count and Count Distinct.
Compare against
Optional
The block first calculates the KPI for the current period. It then calculates the same KPI for a second period and shows the percentage change between the two results.
Previous period: compare with the period directly before the current one. If the current period is April, the comparison is March.
Same period last year: compare with the same dates one year earlier. April 2026 is compared with April 2025.
No comparison: show the current value and trend without a comparison badge.
The default is Previous period. You do not need to select it manually unless you want a different option.
Current period
April 2026 · $12,000
↓ compare with
Previous period
March 2026 · $10,000 → change: +20%
Same period last year
April 2025 · $8,000 → change: +50%
No comparison
Show $12,000 without a comparison badge.
Only one comparison option is used at a time. The current value stays the same; the selected comparison changes the value used by the badge.
Default period
Optional
Choose which dates the large number and trend line should use. The default is This month. If the current month is April, the block uses records dated in April to calculate the number and draw the line.
Default example:Imagine it is April. The block shows April's value and trend. Because Compare against defaults to Previous period, it compares April with March.
Filter
Optional
Include only rows that match another condition from the selected Data Source.
Example: filter the selected table:If the KPI with Trend block uses the Orders table, you can choose its Region column and set the condition to equals Europe. The KPI with Trend block then calculates its result using only European orders. This filter belongs to this block, and it does not edit the Orders table. To let viewers choose the condition themselves, add a Filter block to the dashboard.
Configure the Block tab
The Block tab controls the value, comparison indicator, and trend chart. Everything here is optional:
Style
Optional
Choose how the value, comparison badge, and trend line is drawn. This changes its appearance, not its data or calculation.
Default:
Uses the standard appearance from the dashboard theme
Classic:
Uses a traditional, familiar presentation
Glow:
Adds bright colors and a glowing effect
Modern:
Uses a clean, contemporary presentation
Pattern:
Adds patterns to the visual elements
Value Typography
Optional
Set the Font Family, Font Size, Font Weight, and Text Color for the main number. These settings do not change the card title.
Change Indicator
Optional
Show or hide the badge that reports whether the value is up, down, or unchanged compared with the selected period.
Trend Chart
Optional
Show or hide the sparkline. When it is on, choose its Data Color. Turn it off to keep the KPI and comparison without the line.
Configure the Card tab
The entire Card tab is optional. If you do not customize it, the card follows the dashboard theme. Use this tab only when you want this card to look different.
Card Style
Optional
Choose the style that fits the dashboard. This changes the card surface, border, corners, and shadow. It does not change the block's data.
Default:
Standard card
Elevated:
Rounded with a stronger shadow
Cyber:
Glowing colored edges
Claymorphic:
Soft three-dimensional shading
Flat Panel:
Square surface without a shadow
Glass:
Transparent, blurred surface
Neobrutalist:
Thick border and high contrast
Neuromorphic:
Soft surface blended into the background
Gradient:
Background that blends colors
Background
Optional
Show or hide the card surface. Available colors follow the selected style.
Icon
Optional
Add a symbol to the header. Choose its icon and background colors.
Title
Optional
Name the block. Keep it short and clear.
Description
Optional
Add context such as the unit or date range.
Footer
Optional
Add a source, update time, or short note at the bottom.
Typography is separate:Title, Description, and Footer each have their own color, font, size, and weight. These settings do not change the data inside the block.
