Sigma data and column types

Calculations in Sigma

Mandy Gray

Solutions and Enablement Lead, Aimpoint Digital

Welcome!

Mandy_and_Aimpoint.png

Calculations in Sigma

Welcome!

Mandy_Aimpoint_Sigma.png

Calculations in Sigma

Welcome!

Full_Instructor_Image.png

Calculations in Sigma

Oakmark Bank needs your help

Oakmark_bank_logo.png

Calculations in Sigma

How does Sigma classify data types?

  • Sigma classifies data types for proper function use
  • Numeric data supports calculations, text does not
  • Data types influence sorting and appearance

 

numeric_data_vs_text_data.png

Calculations in Sigma

How does Sigma classify data types?

Text_only_image.png

Calculations in Sigma

How does Sigma classify data types?

Text_and_number.png

Calculations in Sigma

How does Sigma classify data types?

Text_Number_Date.png

Calculations in Sigma

How does Sigma classify data types?

Text_Number_Date_Logical.png

Calculations in Sigma

How does Sigma classify data types?

All_except_geography.png

Calculations in Sigma

How does Sigma classify data types?

All_icons_included.png

Calculations in Sigma

How does Sigma classify data types?

Four_icons_covered_in_course.png

Calculations in Sigma

Text data in Sigma

Text_data_representation.png

Calculations in Sigma

Numeric data in Sigma

Numeric_data_types.png

  • Numeric data includes numbers and decimals
  • No hard-coded currency symbols or commas
  • Formatting adds symbols for clarity
  • Precision from data platform, decimals adjustable
Calculations in Sigma

Date data in Sigma

Date_data_images.png

  • Date data includes dates, timestamps, and time zones
  • Formatting menus change date appearance
  • Sigma stores full original date internally
Calculations in Sigma

Logical data in Sigma

  • Logical data type represents Boolean values
  • Sigma accepts
    • 1 and 0
    • true and false

Boolean_data_numbers_and_words.png

Calculations in Sigma

DEMO

Calculations in Sigma

Let's practice!

Calculations in Sigma

Preparing Video For Download...