|
About the Formulas and Functions category
|
|
0
|
143
|
March 18, 2020
|
|
Changing Timezone of Data
|
|
28
|
314
|
May 28, 2022
|
|
Formatting Dates to be Similar
|
|
27
|
267
|
May 27, 2022
|
|
Adding Values Resulting in Nulls
|
|
29
|
328
|
May 27, 2022
|
|
Right Click Expand
|
|
27
|
260
|
May 27, 2022
|
|
Grouping by more than one dimension the same level
|
|
27
|
288
|
May 27, 2022
|
|
Converting Hstore to JSON
|
|
21
|
206
|
May 27, 2022
|
|
What are Pass Through functions?
|
|
22
|
300
|
May 26, 2022
|
|
H lookup within sigma?
|
|
27
|
309
|
May 26, 2022
|
|
Filling in a Column with Coalesce not Working
|
|
29
|
401
|
May 26, 2022
|
|
Changing Date into "YYYY-Q"
|
|
28
|
320
|
May 26, 2022
|
|
Do excel downloads include column formulas?
|
|
26
|
231
|
May 25, 2022
|
|
Multi-select Parameters in Workbooks (Calculated Fields)
|
|
10
|
402
|
May 25, 2022
|
|
Multi-select Parameters in Workbooks (hand-written SQL source)
|
|
10
|
581
|
May 25, 2022
|
|
Finding Customers First Purchase
|
|
28
|
237
|
May 25, 2022
|
|
IRR and NPV functions
|
|
28
|
409
|
May 25, 2022
|
|
Avg if, median if
|
|
28
|
359
|
May 24, 2022
|
|
Trend forecast formula/function
|
|
27
|
401
|
May 24, 2022
|
|
If contains, then xyz
|
|
28
|
393
|
May 24, 2022
|
|
Product Aggregation
|
|
27
|
246
|
May 24, 2022
|
|
I have a one- or two-digit number that I want to convert to text, retaining the leading zero
|
|
28
|
317
|
May 24, 2022
|
|
Random Pass-Through Function (Snowflake)
|
|
0
|
15
|
May 24, 2022
|
|
"OR" Condition on Filters
|
|
28
|
330
|
May 23, 2022
|
|
Why lead function does not work on my worksheet?
|
|
22
|
221
|
May 23, 2022
|
|
Parameter Date Truncation
|
|
28
|
345
|
May 23, 2022
|
|
How to build a hyperlink with a custom title
|
|
29
|
313
|
May 23, 2022
|
|
Filling in Missing Days per Grouping Level
|
|
28
|
408
|
May 23, 2022
|
|
Adding a Row Count
|
|
28
|
292
|
May 22, 2022
|
|
Counting Values From This Month
|
|
28
|
256
|
May 22, 2022
|
|
How to calculate percentages in a chart or pivot (Dashboards and Worksheets)
|
|
21
|
359
|
May 22, 2022
|