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.

State
California 41.0k
Texas 37.5k
Florida 28.8k
New York 19.1k
Ohio 11.6k
District of Columbia 10.6k
Georgia 10.6k
Pennsylvania 10.5k
Virginia 10.2k
Colorado 8.3k
Category
Odd Equipment 157.9k
Cursed Sporting Goods 124.3k
Mysterious Apparel 45.1k
Sinister Toys 19.7k
Item
Microscope 64.3k
Running Shoes 58.7k
Fishing Rod 56.9k
Lamp 51.8k
Typewriter 41.8k
Vintage Jacket 28.2k
Model Racehorse 14.0k
Mystic Pendant 8.7k
Boxing Gloves 8.6k
Necklace 8.2k
Channel
Google Paid 109.6k
Google Organic 92.4k
Facebook Ads 60.3k
Referral 38.5k
Tiktok Ads 28.8k
Coupon 17.4k
Line Chart
Parser Error: syntax error at or near ")" LINE 3: sum(sales)filter() as sales_usd0 ^

Examples

Basic Usage

<DimensionGrid data={my_query} />

As an Input

Dimension grid produces a condition for all of the selected dimensions which is suitable for referencing directly in a where or filter 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