Ashley Bennett

Sigma Architect with Aimpoint Digital

2024 Week 14 | Sigma: It’s a Bird… It’s a Plane… It’s Lookup Functions!

Sigma, Workout Wednesday / By

Introduction Welcome to Week Fourteen! This week, you’re going to learn about Sigma’s Lookup function.  Lookups are very useful for joining information from one data source to another, without accidentally fanning your data.  Sigma also has a Lookup Wizard for a foolproof way of utilizing this function. When I book a flight, I am particularly concerned …

2024 Week 14 | Sigma: It’s a Bird… It’s a Plane… It’s Lookup Functions! Read More »

2024 Week 11 | Sigma: Can you find the Subtotal?

Sigma, Workout Wednesday / By

Introduction Welcome to Week Eleven! This week, you’re going to learn about Sigma’s Subtotal, PercentOfTotal, and GrandTotal functions.  I find these functions particularly useful in adding context to ToolTips or Pivot tables. In this challenge, you will explore the various types of subtotaling functions.  As you work through this challenge, think about the story the different …

2024 Week 11 | Sigma: Can you find the Subtotal? Read More »

A Line Graph that changes between different date granularities

2024 Week 7 | Sigma: Can you recreate this Line Graph?

Sigma, Workout Wednesday / By

Introduction Welcome to Week Seven! This week, you’re going to create a line graph that can change its date granularity.  With a dynamic x-axis, this graph allows users to view trends at the level that makes sense for their current needs, without duplicating work. Also in this challenge, you’re going to learn how to show …

2024 Week 7 | Sigma: Can you recreate this Line Graph? Read More »