|
About the Formulas and Functions category
|
|
0
|
361
|
March 18, 2020
|
|
Filter results by keywords on an Input Table
|
|
2
|
34
|
June 2, 2023
|
|
IRR and NPV functions
|
|
4
|
933
|
May 25, 2023
|
|
Date Range Functions
|
|
0
|
55
|
May 23, 2023
|
|
How to filter from a comma-separated list of text values or Textbox inputs using pass-through functions or CustomSQL (exact matches only)
|
|
0
|
118
|
March 16, 2023
|
|
Multiple Values for Contains Filter
|
|
4
|
1307
|
May 18, 2023
|
|
Search text for multiple comma-separated values
|
|
0
|
72
|
May 18, 2023
|
|
Convert Time Zone
|
|
6
|
99
|
May 17, 2023
|
|
Calculate net working days/business days between dates like Excel’s networkdays
|
|
3
|
393
|
April 5, 2023
|
|
How to display currency values in $K units
|
|
0
|
64
|
March 31, 2023
|
|
Naming Days of the Week
|
|
30
|
776
|
February 23, 2023
|
|
How to create dynamic table grouping using parameter control
|
|
0
|
167
|
February 10, 2023
|
|
Weighted Average
|
|
0
|
214
|
January 30, 2023
|
|
Relative Date Filter with Timezones
|
|
1
|
535
|
October 23, 2020
|
|
Subtracting Current month value from Previous month
|
|
1
|
118
|
January 18, 2023
|
|
Counting business/weekdays between two dates
|
|
30
|
828
|
January 4, 2023
|
|
Trailing 12 Month Calculations
|
|
3
|
155
|
December 9, 2022
|
|
How to represent the number of seconds as hours, minutes and seconds
|
|
18
|
429
|
October 21, 2022
|
|
How can I change a week to start on Monday instead of Sunday? ( DateTrunc Truncate Date )
|
|
2
|
1749
|
October 21, 2022
|
|
Aggregate Calculations in Pivot Table using Rollup
|
|
2
|
197
|
October 13, 2022
|
|
Calculate Previous Year to Date (YTD)
|
|
0
|
293
|
October 11, 2022
|
|
Remove duplicates/dupes based on the value in a single column (dedupe)
|
|
5
|
385
|
October 7, 2022
|
|
Sorting by weekday in a visualization
|
|
0
|
158
|
October 4, 2022
|
|
CountIf - an easy way to test certain conditions within a group
|
|
0
|
200
|
September 7, 2022
|
|
Formula to calculate current age in years based on a date of birth / birthday date
|
|
0
|
244
|
August 24, 2022
|
|
Joining multiple datasets so they add new rows instead of columns
|
|
5
|
1510
|
August 24, 2022
|
|
A formula to check if a day date occurred consecutively (1 day after) the previous date in the column
|
|
0
|
181
|
August 18, 2022
|
|
Custom Comparison Formula and Percent of Previous Value In a Single Value Viz
|
|
0
|
209
|
August 18, 2022
|
|
Parameter Date Truncation
|
|
2
|
751
|
August 10, 2022
|
|
Cumulative or Running Total
|
|
7
|
460
|
August 3, 2022
|