Home components dimension grid

Dimension Grid

Dimension grid produces an interactive grid of one dimension tables, one for each string column in the source table. The dimension grid can can also be used as an input.

Examples

Basic Usage

	

		
		

<DimensionGrid data={my_query} />

Custom Metric

	

		
		

<DimensionGrid 
    data={my_query} 
    metric="sum(fare)"
/>

As an Input

Dimension grid produces a condition for all of the selected dimensions which is suitable for referencing directly in a where clause. For example airline = 'Air Canada' and plane = '747. Where no dimensions have been selected, DimensionGrid returns true.

	

		
		

<DimensionGrid 
    data={my_query} 
    name="selected_dimensions"
/>


```sql filtered_query
select *
from source_name.table
where ${inputs.selected_dimensions}
```

Options

data
REQUIRED
Query name, wrapped in curly braces
Options:
string
metric
SQL aggregate which could be applied to `data` e.g. 'sum(sales)'
Options:
string
name
Name of the dimension grid, used to reference the selected value elsewhere as {inputs.name}
Options:
string
metricLabel
Label for the metric
Options:
string
limit
Maximum number of rows to include in each table
Options:
number