|
How to Do Fuzzy Matching with a Snowflake UDF
|
|
0
|
92
|
November 25, 2023
|
|
How to Use Groupings & Aggregate Calculations
|
|
3
|
943
|
December 6, 2022
|
|
Calculating Percent Diff Year / Month
|
|
4
|
63
|
November 1, 2023
|
|
Avg if, median if
|
|
31
|
911
|
October 20, 2023
|
|
Custom Comparison Formula and Percent of Previous Value In a Single Value Viz
|
|
1
|
343
|
October 17, 2023
|
|
A formula to check if a day date occurred consecutively (1 day after) the previous date in the column
|
|
1
|
300
|
October 17, 2023
|
|
Formula to calculate current age in years based on a date of birth / birthday date
|
|
1
|
404
|
October 17, 2023
|
|
CountIf - an easy way to test certain conditions within a group
|
|
1
|
293
|
October 17, 2023
|
|
Calculate Previous Year to Date (YTD)
|
|
1
|
471
|
October 17, 2023
|
|
Weighted Average
|
|
2
|
363
|
October 13, 2023
|
|
How to create custom fiscal year and fiscal quarters!
|
|
1
|
53
|
October 5, 2023
|
|
Customize Total Text
|
|
1
|
243
|
August 18, 2023
|
|
Have Autofill options continue to work in formula bar when you add a space
|
|
1
|
201
|
August 18, 2023
|
|
Add IfNull() Function
|
|
1
|
404
|
August 17, 2023
|
|
Use a Switch to quickly show and hide rows with Nulls
|
|
0
|
73
|
August 10, 2023
|
|
FAQ: How to remove the time from the display of dates
|
|
1
|
48
|
August 10, 2023
|
|
How to Start Weeks with Any Day of the Week (DateTrunc, Date Truncate)
|
|
2
|
215
|
August 12, 2023
|
|
Calculating number of weekdays from end of month (or net work days - number of business days between two dates )
|
|
7
|
1276
|
August 9, 2023
|
|
FAQ: How to do "like" string comparison?
|
|
1
|
57
|
July 27, 2023
|
|
How to Calculate Monthly Active Users from a Table with Start and End values (solving "The Classic HR Headcount Problem")
|
|
2
|
209
|
November 17, 2023
|
|
How to use the PercentOfTotal function
|
|
1
|
610
|
July 25, 2023
|
|
How to use Sigma's regular expression functions to standardize and extract data from a text column
|
|
1
|
386
|
July 25, 2023
|
|
How to use pass-through functions to identify if parameter selections are listed in a string column
|
|
1
|
553
|
July 25, 2023
|
|
Using or logic in If formula
|
|
4
|
151
|
August 29, 2023
|
|
How to cast Text type financial numbers that use parentheses to valid Number type numbers
|
|
1
|
81
|
July 20, 2023
|
|
FAQ: How to filter a aggregate without filtering the table?
|
|
3
|
50
|
August 30, 2023
|
|
How to calculate latest full week, month, or quarter etc
|
|
1
|
397
|
July 19, 2023
|
|
How to format a telephone number using regular expressions with RegexpReplace
|
|
1
|
244
|
July 19, 2023
|
|
How to convert epoch/unix time to human readable date format
|
|
1
|
227
|
July 19, 2023
|
|
How to structure a table to use lead/lag functions per use case requirements
|
|
1
|
263
|
July 19, 2023
|