Use these variable names to get a dropdown of values.
| Variable |
|---|
{movie_id} |
{occupation_id} |
{genre_id} |
Use {start_time} and {end_time} for a date range selector. End a variable name with _at for a date selector.
Use these column names to link results to other pages.
| Name | URL |
|---|---|
| title | https://www.imdb.com/find/?q={value}&exact=true |
| zip_code | https://duckduckgo.com/?q={value} |
Values that match the format of a URL will be linked automatically.
Use these column names to show additional data.
| Name |
|---|
| occupation_id |
| movie_id |
| genre_id |
Use specific combinations of column types to generate charts.
| Chart | Column Types |
|---|---|
| Line | 2+ columns - timestamp, numeric(s) |
| Line | 3 columns - timestamp, string, numeric |
| Column | 2+ columns - string, numeric(s) |
| Column | 3 columns - string, string, numeric |
| Scatter | 2 columns - both numeric |
| Pie | 2 columns - string, numeric - and last column named pie |
| Map |
Named latitude and longitude, or lat and lon, or lat and lng
|
| Area Map |
Named geojson
|
Use the column name target to draw a line for goals.
Create a query with the comment /* cohort analysis */. The result should have columns named user_id and conversion_time and optionally cohort_time.