Latest Sigma Formulas and Functions topics

Topic	Replies	Views	Activity
About the Formulas and Functions category	0	446	March 18, 2020
How to use the Period over Period Feature YearOverYearAnalysis	4	161	December 5, 2023
Convert Time Zone Timezones	8	269	December 4, 2023
Calculating Percent Diff Year / Month Formulas , Dates , dashboard	4	62	November 1, 2023
How to display currency values in $K units functions	2	183	November 1, 2023
Sort by Smallest to Largest Incorrect Number , sort	5	60	October 31, 2023
How to compare data between two custom date ranges, or Year over Year Dates	1	532	October 22, 2023
Popular Date Formats Formatting , Dates	1	299	October 22, 2023
Rank over partition functions , rank	2	937	October 22, 2023
How to convert a text date into a Sigma date type using Substring and MakeDate Text , Dates	1	270	October 22, 2023
How to calculate percentages in a chart or pivot (Dashboards and Worksheets) percentage	24	1040	October 20, 2023
Avg if, median if Formulas , avgif	31	911	October 20, 2023
How to reference a single individual value in a table Summary	1	47	October 19, 2023
How to adapt Quarter function for use with a non-standard fiscal calendar Fiscal-Date	20	785	October 17, 2023
Custom Comparison Formula and Percent of Previous Value In a Single Value Viz Formulas	1	343	October 17, 2023
A formula to check if a day date occurred consecutively (1 day after) the previous date in the column Formulas , Dates	1	300	October 17, 2023
Formula to calculate current age in years based on a date of birth / birthday date Formulas , DateDiff	1	404	October 17, 2023
CountIf - an easy way to test certain conditions within a group Formulas , CountIf	1	293	October 17, 2023
Sorting by weekday in a visualization Visualizations , sort	1	258	October 17, 2023
Calculate Previous Year to Date (YTD) Formulas , Dates	1	471	October 17, 2023
Weighted Average Formulas , average	2	362	October 13, 2023
How to create dynamic table grouping using parameter control Groupings , Parameters	1	337	October 13, 2023
Date Range Functions Dates , functions	1	216	October 12, 2023
How to create custom fiscal year and fiscal quarters! Formulas , Fiscal-Date , DateTrunc	1	52	October 5, 2023
Search text for multiple comma-separated values FiltersControls	1	316	August 29, 2023
How to format numbers with custom labels (metric) after them Formatting , Text	4	281	September 9, 2023
Parameter Date Truncation FiltersControls , Parameters , DateTrunc	3	884	September 9, 2023
What is the monthly 80th percentile of customer’s total transactions at retailer A in a rolling last 6 months? Chart	3	93	August 29, 2023
How can I change a week to start on Monday instead of Sunday? ( DateTrunc Truncate Date ) Dates	7	2134	August 29, 2023
FAQ: How to remove the time from the display of dates faq , Formulas , Dates	1	48	August 10, 2023