|
About the Formulas and Functions category
|
|
0
|
290
|
March 18, 2020
|
|
Weighted Average
|
|
0
|
21
|
January 30, 2023
|
|
Relative Date Filter with Timezones
|
|
1
|
448
|
October 23, 2020
|
|
Subtracting Current month value from Previous month
|
|
1
|
51
|
January 18, 2023
|
|
Multi-select Parameters in Workbooks (hand-written SQL source)
|
|
13
|
1421
|
January 6, 2023
|
|
Counting business/weekdays between two dates
|
|
30
|
705
|
January 4, 2023
|
|
Using pass-through functions to identify if parameter selections are listed in string column
|
|
0
|
223
|
December 19, 2022
|
|
IF Statements, do's and don'ts
|
|
0
|
303
|
December 15, 2022
|
|
Trailing 12 Month Calculations
|
|
3
|
73
|
December 9, 2022
|
|
How to use the PercentOfTotal function
|
|
0
|
310
|
November 28, 2022
|
|
How to represent the number of seconds as hours, minutes and seconds
|
|
18
|
341
|
October 21, 2022
|
|
How can I change a week to start on Monday instead of Sunday? ( DateTrunc Truncate Date )
|
|
2
|
1474
|
October 21, 2022
|
|
Aggregate Calculations in Pivot Table using Rollup
|
|
2
|
117
|
October 13, 2022
|
|
Calculate Previous Year to Date (YTD)
|
|
0
|
137
|
October 11, 2022
|
|
Remove duplicates/dupes based on the value in a single column (dedupe)
|
|
5
|
171
|
October 7, 2022
|
|
Sorting by weekday in a visualization
|
|
0
|
96
|
October 4, 2022
|
|
Calculate net working days/business days between dates like Excel’s networkdays
|
|
1
|
205
|
September 22, 2022
|
|
CountIf - an easy way to test certain conditions within a group
|
|
0
|
134
|
September 7, 2022
|
|
Formula to calculate current age in years based on a date of birth / birthday date
|
|
0
|
133
|
August 24, 2022
|
|
Joining multiple datasets so they add new rows instead of columns
|
|
5
|
1281
|
August 24, 2022
|
|
A formula to check if a day date occurred consecutively (1 day after) the previous date in the column
|
|
0
|
117
|
August 18, 2022
|
|
Custom Comparison Formula and Percent of Previous Value In a Single Value Viz
|
|
0
|
131
|
August 18, 2022
|
|
Parameter Date Truncation
|
|
2
|
640
|
August 10, 2022
|
|
Cumulative or Running Total
|
|
7
|
314
|
August 3, 2022
|
|
Median value changing with sort order
|
|
1
|
136
|
July 20, 2022
|
|
Period-over-period analysis
|
|
2
|
754
|
July 1, 2022
|
|
How to calculate the number of calendar days between a date and the start of the year
|
|
1
|
141
|
July 1, 2022
|
|
How to create a running total/cumulative sum
|
|
2
|
319
|
June 30, 2022
|
|
Sliding window calc
|
|
16
|
322
|
June 30, 2022
|
|
Multiple Values for Contains Filter
|
|
3
|
1002
|
November 30, 2020
|