BigQuery

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

Label

| 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

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

Hour Density Chart

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

Line Graph

| 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

| 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

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

Pie Chart

| 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

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