|
About the BigQuery Snippets category
|
|
0
|
217
|
July 16, 2021
|
|
Random Number Between 2 Integers
|
|
1
|
145
|
September 9, 2021
|
|
Advanced Date Dimension with Fiscal Calendar
|
|
1
|
177
|
August 23, 2021
|
|
Basic Date Dimension
|
|
0
|
132
|
August 22, 2021
|
|
Formatting Date Cheat Sheet
|
|
0
|
209
|
August 12, 2021
|
|
Extract/Trunc WEEK starting on Mon (not Sun)
|
|
0
|
78
|
August 9, 2021
|
|
Generate Uniform Distribution
|
|
0
|
172
|
July 16, 2021
|
|
Last day of the month
|
|
4
|
319
|
August 5, 2021
|
|
First row of each group
|
|
2
|
245
|
August 4, 2021
|
|
UDF: Weekday
|
|
0
|
108
|
August 4, 2021
|
|
UDF: Quarter
|
|
0
|
55
|
August 4, 2021
|
|
UDF: Month of Year
|
|
0
|
70
|
August 4, 2021
|
|
Compound growth rates
|
|
0
|
137
|
July 16, 2021
|
|
Cohort Analysis
|
|
0
|
505
|
July 26, 2021
|
|
UDF: Least Value in an Array
|
|
0
|
103
|
July 26, 2021
|
|
PIVOT in BigQuery
|
|
0
|
218
|
July 28, 2021
|
|
Identify Outliers in BigQuery
|
|
0
|
338
|
July 26, 2021
|
|
Extract repeating word from string
|
|
0
|
127
|
July 26, 2021
|
|
Split a string on uppercase characters
|
|
0
|
62
|
July 26, 2021
|
|
Least/Greatest value in an array
|
|
0
|
96
|
July 26, 2021
|
|
Replace or Strip out multiple different string matches from some text
|
|
0
|
82
|
July 24, 2021
|
|
Yearly cohorts
|
|
1
|
221
|
July 26, 2021
|
|
Concatinate text handling nulls
|
|
1
|
87
|
July 26, 2021
|
|
Count NULLs
|
|
0
|
258
|
July 16, 2021
|
|
Bar Chart
|
|
0
|
181
|
July 16, 2021
|
|
Horizontal Bar Chart
|
|
0
|
135
|
July 16, 2021
|
|
100% Stacked Bar Chart
|
|
0
|
160
|
July 16, 2021
|
|
Median
|
|
0
|
152
|
July 16, 2021
|
|
Rank by Group
|
|
0
|
140
|
July 16, 2021
|
|
Regex: Email validation
|
|
0
|
155
|
July 16, 2021
|
