|
About the BigQuery Snippets category
|
|
0
|
399
|
July 16, 2021
|
|
Year over Year % difference
|
|
3
|
823
|
January 24, 2023
|
|
Latest Row (deduplicate)
|
|
4
|
2925
|
December 11, 2021
|
|
Random Number Between 2 Integers
|
|
1
|
2489
|
September 9, 2021
|
|
Advanced Date Dimension with Fiscal Calendar
|
|
1
|
614
|
August 23, 2021
|
|
Basic Date Dimension
|
|
0
|
577
|
August 22, 2021
|
|
Formatting Date Cheat Sheet
|
|
0
|
611
|
August 12, 2021
|
|
Extract/Trunc WEEK starting on Mon (not Sun)
|
|
0
|
291
|
August 9, 2021
|
|
Generate Uniform Distribution
|
|
0
|
684
|
July 16, 2021
|
|
Last day of the month
|
|
4
|
3604
|
August 5, 2021
|
|
First row of each group
|
|
2
|
1355
|
August 4, 2021
|
|
UDF: Weekday
|
|
0
|
480
|
August 4, 2021
|
|
UDF: Quarter
|
|
0
|
240
|
August 4, 2021
|
|
UDF: Month of Year
|
|
0
|
283
|
August 4, 2021
|
|
Compound growth rates
|
|
0
|
434
|
July 16, 2021
|
|
Cohort Analysis
|
|
0
|
1929
|
July 26, 2021
|
|
UDF: Least Value in an Array
|
|
0
|
341
|
July 26, 2021
|
|
PIVOT in BigQuery
|
|
0
|
823
|
July 28, 2021
|
|
Identify Outliers in BigQuery
|
|
0
|
2835
|
July 26, 2021
|
|
Extract repeating word from string
|
|
0
|
432
|
July 26, 2021
|
|
Split a string on uppercase characters
|
|
0
|
386
|
July 26, 2021
|
|
Least/Greatest value in an array
|
|
0
|
2314
|
July 26, 2021
|
|
Replace or Strip out multiple different string matches from some text
|
|
0
|
1228
|
July 24, 2021
|
|
Yearly cohorts
|
|
1
|
488
|
July 26, 2021
|
|
Concatinate text handling nulls
|
|
1
|
268
|
July 26, 2021
|
|
Count NULLs
|
|
0
|
466
|
July 16, 2021
|
|
Bar Chart
|
|
0
|
369
|
July 16, 2021
|
|
Horizontal Bar Chart
|
|
0
|
377
|
July 16, 2021
|
|
100% Stacked Bar Chart
|
|
0
|
400
|
July 16, 2021
|
|
Median
|
|
0
|
289
|
July 16, 2021
|