Zoho Analytics Formula Columns, Aggregate Formulas, & Basic SQL

This Zoho Analytics tutorial shows how to create and use formula fields and columns. We also cover a brief introduction to SQL and how it would be used to combine data from leads and deals.


  • 0:00 Intro
  • 1:18 Creating a formula column
  • 10:25 Creating an aggregate formula
  • 16:58 Introduction into basic SQL


Web Developer

Billy is a Wordpress Developer with an eye for design. His knowledge will help our company website and client sites meet their goals. Billy and his young family have just moved to Ashland Oregon, and are looking forward to exploring the area’s amazing beer, wine, and food. He also has a passion for synthesizers and drum machines.

Lucas Sant'Anna


With a background in Operations Research and Data Analysis, Lucas is a Brazilian programmer that likes to get stuff done quickly and reliably. In previous jobs, he implemented industrial job scheduling, fleet management and detailed long-haul route optimization – among other data-driven processes – to reach objectives of increased profit and reduced wasted resources. His goal is to make Zoho fully automated and with more meaningful data for spot-on decisions.