> ## Documentation Index > Fetch the complete documentation index at: https://docs.evidence.studio/llms.txt > Use this file to discover all available pages before exploring further. # Big Value > Display a big value with optional comparison, delta, and sparkline Basic Usage ```liquid theme={null} {% big_value data="demo.daily_orders" value="sum(total_sales)" fmt="usd1m" /%} ``` ## Examples ### Basic Usage Basic Usage ```liquid theme={null} {% big_value data="demo.daily_orders" value="sum(total_sales)" fmt="usd1m" /%} ``` ### Comparison Comparison ```liquid theme={null} {% big_value data="demo.daily_orders" value="sum(total_sales)" fmt="usd1m" date_range={ date="date" range="last 12 months" } comparison={ compare_vs="prior year" } /%} ``` ### Sparkline Sparkline ```liquid theme={null} {% big_value data="demo.daily_orders" value="sum(total_sales)" fmt="usd1m" sparkline={ type="line" x="date" } /%} ``` ### Text Size Text Size ```liquid theme={null} {% big_value data="demo.daily_orders" value="sum(total_sales)" fmt="usd1m" text_size="4xl" /%} ``` ## Attributes Table or view to query The column name for the main value to display Use date\_range to filter data for specific time periods. Accepts predefined ranges (e.g., "last 12 months"), dynamic ranges (e.g., "Last 90 days"), custom date ranges (e.g., "2020-01-01 to 2023-03-01"), or partial ranges (e.g., "from 2020-01-01", "until 2023-03-01") **Example:** ``` date_range={ range = "today" date = "string" } ``` **Attributes:** * range: `string` - Time period to filter. Use presets like 'last 7 days', dynamic patterns like 'Last 90 days', custom ranges like '2020-01-01 to 2023-03-01', or partial ranges like 'from 2020-01-01'. * **Allowed values:** * `today` * `yesterday` * `last 7 days` * `last 30 days` * `last 3 months` * `last 6 months` * `last 12 months` * `previous week` * `previous month` * `previous quarter` * `previous year` * `this week` * `this month` * `this quarter` * `this year` * `next week` * `next month` * `next quarter` * `next year` * `week to date` * `month to date` * `quarter to date` * `year to date` * `all time` * date: `string` - Date column to filter on. Required when the data has multiple date columns. Comparison configuration object **Example:** ``` comparison={ compare_vs = "prior year" display_type = "compared_value" target = "string" benchmark = { agg = "avg" subject = "store_name" within = ["region"] } hide_pct = true pct_fmt = "string" abs_fmt = "string" text = "string" delta = true down_is_good = true neutral_range = [] } ``` **Attributes:** * compare\_vs: `string` - Type of comparison to perform. Options: prior year (same period last year), prior period (previous period of same duration), target (compare against a target value), benchmark (compare against group average/aggregate) * **Allowed values:** * `prior year` * `prior period` * `target` * `benchmark` * display\_type: `string` - What to display for comparison. Options: compared\_value (comparison period value), abs (absolute change), pct (percentage change). Default: pct * **Allowed values:** * `compared_value` * `abs` * `pct` * target: `string` - Target value for target comparison. Can be a column name, aggregation (e.g., "sum(target\_sales)"), or literal value. * benchmark: `options group` * **Options:** * agg: `string` - Aggregation function to apply across benchmark group. Options: avg (average), median, min, max, sum, count, count\_distinct * **Allowed values:** * `avg` * `median` * `min` * `max` * `sum` * `count` * `count_distinct` * subject: `string` - Column or expression that defines individual entities in the benchmark (e.g., "store\_name", "customer\_id"). Required for single-value components. * value: `string` - Optional column or expression to use for benchmark calculation. If not specified, uses the main value column. Useful if you have a pre-aggregated benchmark table for RLS reasons. * within: `array of strings` - Dimension columns to group the benchmark by (e.g., \["region"]). Leave empty for dataset-wide benchmark. * where: `string` - SQL WHERE clause to filter which entities are included in the benchmark * exclude\_self: `boolean` - Exclude the current row from its own benchmark calculation (table context only). Default: false * hide\_pct: `boolean` - Hide the percentage change line in comparison tooltips * pct\_fmt: `string` - Format code for percentage values in comparison tooltips * abs\_fmt: `string` - Format code for absolute values in comparison tooltips * text: `string` - Text displayed after the comparison value * delta: `boolean` - Whether to display the comparison as a delta * down\_is\_good: `boolean` - Whether a decrease is considered positive * neutral\_range: `array` - Range \[min, max] for neutral values. Use null for infinity (e.g., \[null, 0] means anything ≤ 0 is neutral) Sparkline configuration object **Example:** ``` sparkline={ type = "line" color = "string" x = "string" y_fmt = "string" x_fmt = "string" fit_to_data = true connect_group = "string" date_grain = "year" date_range = { range = "today" date = "string" } } ``` **Attributes:** * type: `string` - The type of sparkline to display * **Allowed values:** * `line` * `area` * `bar` * color: `string` - Color for the sparkline * x: `string` - X column for the sparkline * y\_fmt: `string` - Value format for the sparkline tooltips * x\_fmt: `string` - Date format for the sparkline tooltips * fit\_to\_data: `boolean` - Whether to fit the Y axis scale to the data range * connect\_group: `string` - Connect group for the sparkline * date\_grain: `string` - Time grain for the sparkline data points * **Allowed values:** * `year` * `quarter` * `month` * `week` * `day` * `hour` * `minute` * date\_range: `options group` * **Options:** * range: `string` - Time period to filter. Use presets like 'last 7 days', dynamic patterns like 'Last 90 days', custom ranges like '2020-01-01 to 2023-03-01', or partial ranges like 'from 2020-01-01'. * **Allowed values:** * `today` * `yesterday` * `last 7 days` * `last 30 days` * `last 3 months` * `last 6 months` * `last 12 months` * `previous week` * `previous month` * `previous quarter` * `previous year` * `this week` * `this month` * `this quarter` * `this year` * `next week` * `next month` * `next quarter` * `next year` * `week to date` * `month to date` * `quarter to date` * `year to date` * `all time` * date: `string` - Date column to filter on. Required when the data has multiple date columns. Format for the main value. See [Value Formatting](/core-concepts/value-formatting) for available formats. Title for the main value Maximum width of the component Minimum width of the component Text size for the value. Options: sm, base, lg, xl (default), 2xl, 3xl, 4xl, 5xl **Allowed values:** * `sm` * `base` * `lg` * `xl` * `2xl` * `3xl` * `4xl` * `5xl` Additional CSS classes for the title Additional CSS classes for the value URL to link the value to Information tooltip text URL to link the info text to (can only be used with info) Create a custom link title for the info link, placed after the info text (can only be used with info\_link) IDs of filters to apply to the query Custom SQL WHERE condition to apply to the query. For date filters, use date\_range instead. Custom SQL HAVING condition to apply to the query after GROUP BY Maximum number of rows to return from the query. Note: When used with tables, limit will disable subtotals to prevent incomplete subtotal rows. Column name(s) with optional direction (e.g. "column\_name", "column\_name desc") Custom SQL QUALIFY condition to filter windowed results Additional CSS classes for the component Time in seconds between automatic data refreshes (minimum 60). Overrides the page-level auto-refresh setting for this component. Set the width of this component (in percent) relative to the page width