How to create period over period calculations in Sigma

Learn how to add a period over period comparison to a Sigma table in a few clicks, then make the time period dynamic with a segmented control. In this walkthrough, Paul from Sigma’s technical training team uses Plugs Electronics hands-on lab data to cover: Adding a column with the period over period comparison option Choosing the field, aggregation, date column, and comparison time frame (such as same month last year) Showing month-to-date calculations Automatically calculating the difference and percentage difference between periods How Sigma groups the table and builds each calculation, including the date lookback function Adding a segmented control to switch between year, quarter, and month Naming controls with a ctrl_ prefix so they’re easy to find, especially in Sigma apps Using the control in the date trunc function to make the period dynamic New to Sigma? Request a demo: https://www.sigmacomputing.com/go/request-a-demo?utm_medium=organic-social&utm_source=youtube&utm_campaign=request-a-demo&utm_content=request-a-demo&utm_term=request-a-demo Free trial: https://www.sigmacomputing.com/go/free-trial?utm_medium=organic-social&utm_source=youtube&utm_campaign=free-trial&utm_content=free-trial&utm_term=free-trial