|
About the BigQuery Snippets category
|
|
0
|
231
|
July 16, 2021
|
|
Latest Row (deduplicate)
|
|
3
|
398
|
November 8, 2021
|
|
Random Number Between 2 Integers
|
|
1
|
186
|
September 9, 2021
|
|
Advanced Date Dimension with Fiscal Calendar
|
|
1
|
218
|
August 23, 2021
|
|
Basic Date Dimension
|
|
0
|
175
|
August 22, 2021
|
|
Formatting Date Cheat Sheet
|
|
0
|
250
|
August 12, 2021
|
|
Extract/Trunc WEEK starting on Mon (not Sun)
|
|
0
|
97
|
August 9, 2021
|
|
Generate Uniform Distribution
|
|
0
|
188
|
July 16, 2021
|
|
Last day of the month
|
|
4
|
351
|
August 5, 2021
|
|
First row of each group
|
|
2
|
271
|
August 4, 2021
|
|
UDF: Weekday
|
|
0
|
130
|
August 4, 2021
|
|
UDF: Quarter
|
|
0
|
66
|
August 4, 2021
|
|
UDF: Month of Year
|
|
0
|
81
|
August 4, 2021
|
|
Compound growth rates
|
|
0
|
161
|
July 16, 2021
|
|
Cohort Analysis
|
|
0
|
532
|
July 26, 2021
|
|
UDF: Least Value in an Array
|
|
0
|
125
|
July 26, 2021
|
|
PIVOT in BigQuery
|
|
0
|
246
|
July 28, 2021
|
|
Identify Outliers in BigQuery
|
|
0
|
369
|
July 26, 2021
|
|
Extract repeating word from string
|
|
0
|
135
|
July 26, 2021
|
|
Split a string on uppercase characters
|
|
0
|
73
|
July 26, 2021
|
|
Least/Greatest value in an array
|
|
0
|
110
|
July 26, 2021
|
|
Replace or Strip out multiple different string matches from some text
|
|
0
|
94
|
July 24, 2021
|
|
Yearly cohorts
|
|
1
|
239
|
July 26, 2021
|
|
Concatinate text handling nulls
|
|
1
|
97
|
July 26, 2021
|
|
Count NULLs
|
|
0
|
274
|
July 16, 2021
|
|
Bar Chart
|
|
0
|
207
|
July 16, 2021
|
|
Horizontal Bar Chart
|
|
0
|
148
|
July 16, 2021
|
|
100% Stacked Bar Chart
|
|
0
|
184
|
July 16, 2021
|
|
Median
|
|
0
|
162
|
July 16, 2021
|
|
Rank by Group
|
|
0
|
153
|
July 16, 2021
|
