Formula Challenges

Formula Challenges

Cloud

rate limit

Code not recognized.

About this course

Description

This course lets you practice using formulas directly in ThoughtSpot. Formulas can help create new searchable information for users - information that isn't inherently available in the raw data.

Topics covered

  • Practice using formulas to add searchable fields to your data

Prerequisites

Completion of the Business User learning path and previous courses in the Business Analyst learning path. Completion of Introduction to Formulas is highly recommended.

 

Curriculum

  • Welcome
  • Course Overview
  • Review of formula types
  • Formula Challenges
  • Calculate average sales per quantity purchased
  • Create a Hyperlink
  • Compare to average
  • 3-period moving average
  • Past cumulative sum
  • Sales as a percent of total
  • Quantity sold by price range (histogram)
  • String to date conversion
  • Month to date for a previous year
  • Average days between sales
  • Review
  • Feedback

About this course

Description

This course lets you practice using formulas directly in ThoughtSpot. Formulas can help create new searchable information for users - information that isn't inherently available in the raw data.

Topics covered

  • Practice using formulas to add searchable fields to your data

Prerequisites

Completion of the Business User learning path and previous courses in the Business Analyst learning path. Completion of Introduction to Formulas is highly recommended.

 

Curriculum

  • Welcome
  • Course Overview
  • Review of formula types
  • Formula Challenges
  • Calculate average sales per quantity purchased
  • Create a Hyperlink
  • Compare to average
  • 3-period moving average
  • Past cumulative sum
  • Sales as a percent of total
  • Quantity sold by price range (histogram)
  • String to date conversion
  • Month to date for a previous year
  • Average days between sales
  • Review
  • Feedback