|
About the BigQuery Snippets category
|
|
0
|
362
|
July 16, 2021
|
|
Year over Year % difference
|
|
3
|
591
|
January 24, 2023
|
|
Latest Row (deduplicate)
|
|
4
|
2035
|
December 11, 2021
|
|
Random Number Between 2 Integers
|
|
1
|
1622
|
September 9, 2021
|
|
Advanced Date Dimension with Fiscal Calendar
|
|
1
|
522
|
August 23, 2021
|
|
Basic Date Dimension
|
|
0
|
468
|
August 22, 2021
|
|
Formatting Date Cheat Sheet
|
|
0
|
521
|
August 12, 2021
|
|
Extract/Trunc WEEK starting on Mon (not Sun)
|
|
0
|
246
|
August 9, 2021
|
|
Generate Uniform Distribution
|
|
0
|
553
|
July 16, 2021
|
|
Last day of the month
|
|
4
|
1763
|
August 5, 2021
|
|
First row of each group
|
|
2
|
954
|
August 4, 2021
|
|
UDF: Weekday
|
|
0
|
392
|
August 4, 2021
|
|
UDF: Quarter
|
|
0
|
203
|
August 4, 2021
|
|
UDF: Month of Year
|
|
0
|
238
|
August 4, 2021
|
|
Compound growth rates
|
|
0
|
340
|
July 16, 2021
|
|
Cohort Analysis
|
|
0
|
1554
|
July 26, 2021
|
|
UDF: Least Value in an Array
|
|
0
|
263
|
July 26, 2021
|
|
PIVOT in BigQuery
|
|
0
|
599
|
July 28, 2021
|
|
Identify Outliers in BigQuery
|
|
0
|
2207
|
July 26, 2021
|
|
Extract repeating word from string
|
|
0
|
336
|
July 26, 2021
|
|
Split a string on uppercase characters
|
|
0
|
288
|
July 26, 2021
|
|
Least/Greatest value in an array
|
|
0
|
1813
|
July 26, 2021
|
|
Replace or Strip out multiple different string matches from some text
|
|
0
|
715
|
July 24, 2021
|
|
Yearly cohorts
|
|
1
|
415
|
July 26, 2021
|
|
Concatinate text handling nulls
|
|
1
|
228
|
July 26, 2021
|
|
Count NULLs
|
|
0
|
416
|
July 16, 2021
|
|
Bar Chart
|
|
0
|
331
|
July 16, 2021
|
|
Horizontal Bar Chart
|
|
0
|
318
|
July 16, 2021
|
|
100% Stacked Bar Chart
|
|
0
|
350
|
July 16, 2021
|
|
Median
|
|
0
|
266
|
July 16, 2021
|