|
About the Formulas and Functions category
|
|
0
|
53
|
March 18, 2020
|
|
Removing duplicate rows in a worksheet
|
|
14
|
162
|
July 25, 2021
|
|
Extracting Characters From a String
|
|
16
|
92
|
July 25, 2021
|
|
Show all rows when Data Source Parameter is empty
|
|
15
|
95
|
July 25, 2021
|
|
Joining multiple datasets so they add new rows instead of columns
|
|
19
|
190
|
July 25, 2021
|
|
Expected Date Format
|
|
15
|
70
|
July 24, 2021
|
|
Pacing Formula - Useful for tracking budgets and other monthly goals
|
|
16
|
94
|
July 24, 2021
|
|
Replacing Nulls With Zeros
|
|
16
|
93
|
July 24, 2021
|
|
Total Sum for Previous Three Months
|
|
14
|
96
|
July 24, 2021
|
|
Non-Alphabetical Custom Sorting
|
|
16
|
88
|
July 24, 2021
|
|
Removing Space on Column Values
|
|
16
|
78
|
July 23, 2021
|
|
Listing Values in a Group
|
|
16
|
119
|
July 23, 2021
|
|
Cannot filter out nulls for numerical column with limit filter
|
|
16
|
86
|
July 23, 2021
|
|
Group value as bins and rename the bins
|
|
10
|
79
|
July 23, 2021
|
|
Converting Seconds into Hours and Minutes
|
|
16
|
89
|
July 23, 2021
|
|
Using a date spine
|
|
0
|
7
|
July 23, 2021
|
|
Create a bar chart where each bar represents a separate table column
|
|
16
|
79
|
July 22, 2021
|
|
Counting business/weekdays between two dates
|
|
16
|
87
|
July 22, 2021
|
|
Integer data source parameters
|
|
10
|
83
|
July 22, 2021
|
|
Filtering on JSON fields
|
|
16
|
81
|
July 22, 2021
|
|
Year over Year period to date analysis
|
|
16
|
116
|
July 22, 2021
|
|
How to Drop a Row
|
|
16
|
87
|
July 21, 2021
|
|
Top 5 for each country
|
|
16
|
89
|
July 21, 2021
|
|
How to represent the number of seconds as hours, minutes and seconds
|
|
4
|
36
|
July 21, 2021
|
|
Format text column to sentence case
|
|
16
|
106
|
July 21, 2021
|
|
Pivot table percentage calculations
|
|
10
|
128
|
July 21, 2021
|
|
Sum distinct function
|
|
17
|
158
|
July 20, 2021
|
|
EPOCH timestamps
|
|
16
|
115
|
July 20, 2021
|
|
Nested JSON objects
|
|
16
|
75
|
July 20, 2021
|
|
Relative Date Filter with Timezones
|
|
14
|
67
|
July 20, 2021
|
