Connect Google BigQuery

Design custom dashboards with data from BigQuery.

Numerics lets you easily display custom data from your BigQuery. Here are the sample queries for each widget type:

Label

| Query: SELECT state FROM newmerix:sample.natality where mother_married=false group by state Limit 1 |


Number

| Query: SELECT SUM(cigarettes_per_day) as count FROM newmerix:sample.natality |


Day Density Chart

| Query: SELECT DATE(TimeLoc) as TimeLoc_date,NumValue FROM newmerix:sample.titemvalue WHERE ItemId=2 LIMIT 31 |


Hour Density Chart

| Query: SELECT HOUR(TimeLoc) as TimeLoc_date,NumValue FROM newmerix:sample.titemvalue WHERE ItemId=1 LIMIT 24 |


Line Graph

| Query: SELECT AVG(weight_pounds) AS average_weight FROM newmerix:sample.natality GROUP BY source_year ORDER BY source_year DESC,average_weight DESC LIMIT 30 |


Named line Graph

| Query: SELECT source_year,AVG(weight_pounds) AS average_weight FROM newmerix:sample.natality GROUP BY source_year ORDER BY source_year DESC,average_weight DESC |


Number and Difference Indicator

| Query: SELECT AVG(cigarettes_per_day) avg_count FROM newmerix:sample.natality GROUP BY source_year ORDER BY source_year DESC LIMIT 2 |


Pie Chart

| Query: SELECT mother_age, AVG(weight_pounds) AS average_weight FROM newmerix:sample.natality GROUP BY mother_age ORDER BY average_weight DESC |


Top list Funnel Chart

| Query: SELECT year, AVG(weight_pounds) as average_weight from newmerix:sample.natality group by year order by year desc limit 5 |