|
About the Formulas and Functions category
|
|
0
|
200
|
March 18, 2020
|
|
Remove duplicates/dupes based on the value in a single column (dedupe)
|
|
4
|
38
|
October 5, 2022
|
|
Aggregate Calculations in Pivot Table using Rollup
|
|
0
|
9
|
October 4, 2022
|
|
Sorting by weekday in a visualization
|
|
0
|
9
|
October 4, 2022
|
|
Calculate net working days/business days between dates like Excel’s networkdays
|
|
1
|
101
|
September 22, 2022
|
|
CountIf - an easy way to test certain conditions within a group
|
|
0
|
46
|
September 7, 2022
|
|
Formula to calculate current age in years based on a date of birth / birthday date
|
|
0
|
65
|
August 24, 2022
|
|
Joining multiple datasets so they add new rows instead of columns
|
|
5
|
976
|
August 24, 2022
|
|
A formula to check if a day date occurred consecutively (1 day after) the previous date in the column
|
|
0
|
44
|
August 18, 2022
|
|
Custom Comparison Formula and Percent of Previous Value In a Single Value Viz
|
|
0
|
45
|
August 18, 2022
|
|
Parameter Date Truncation
|
|
2
|
514
|
August 10, 2022
|
|
Cumulative or Running Total
|
|
7
|
192
|
August 3, 2022
|
|
Median value changing with sort order
|
|
1
|
63
|
July 20, 2022
|
|
Period-over-period analysis
|
|
2
|
525
|
July 1, 2022
|
|
How to calculate the number of calendar days between a date and the start of the year
|
|
1
|
73
|
July 1, 2022
|
|
Relative Date Filter with Timezones
|
|
1
|
359
|
October 23, 2020
|
|
How to create a running total/cumulative sum
|
|
2
|
124
|
June 30, 2022
|
|
Sliding window calc
|
|
16
|
236
|
June 30, 2022
|
|
Multiple Values for Contains Filter
|
|
3
|
705
|
November 30, 2020
|
|
How to adapt Quarter function for use with a non-standard fiscal calendar
|
|
31
|
456
|
June 30, 2022
|
|
Replacing Strings that Contain Escape Characters
|
|
17
|
299
|
June 29, 2022
|
|
Can I save a complex formula for reuse?
|
|
29
|
421
|
June 29, 2022
|
|
How can I change a week to start on Monday instead of Sunday? ( DateTrunc Truncate Date )
|
|
1
|
1218
|
June 4, 2020
|
|
Sigma functions for list values
|
|
0
|
297
|
October 8, 2020
|
|
How to create a linear regression in Sigma
|
|
1
|
286
|
May 2, 2022
|
|
Converting Text to Date shows Null
|
|
4
|
448
|
October 22, 2020
|
|
Adding Leading Zeros
|
|
30
|
422
|
June 28, 2022
|
|
Finding Sum for Previous 7 Days not Including Today
|
|
29
|
403
|
June 28, 2022
|
|
Non-Alphabetical Custom Sorting
|
|
32
|
473
|
June 28, 2022
|
|
Naming Days of the Week
|
|
29
|
520
|
June 27, 2022
|