Unlock the TRUE POWER of Zoho Analytics with SQL Query Tables
What are Query Tables and How Do They Work?
The Smartest Ways to Learn SQL On Your Own
The Activities Query Table
The Query Table Builder
What is the Basic Structure of a Query Table?
Look at the Finished Product
Renaming and Line Up Your Columns
Build an Activities Chart
Build Your Own Query Table From Scratch
Why Do We Need a Query Table For This?
Start With the Leads Data
Hard-Code Data Into Your Query Table
Build the Contacts Sub-query
Start on the Deals Sub-query
Join the Contacts Table to Deals
ESSENTIAL: Understand Table Aliases
Add Comments to Your Query and Review
Build the Instance for Closed Deals (Intro to Filtering)
Create Flippin’ Cool Charts with Your Query Table!
Reviewing the ABUNDANT Benefits of Query Tables
Previous Topic
Next Topic

Build Your Own Query Table From Scratch

Unlock the TRUE POWER of Zoho Analytics with SQL Query Tables Build Your Own Query Table From Scratch

Picture this: one report that can show you how many new leads, converted leads, new deals, and closed deals your business had for any given time period (with a dynamic date filter).

You guessed it; you can’t build a report like this without a query table with all the right base data!

Lesson Content
0% Complete 0/11 Steps
Why Do We Need a Query Table For This?
Start With the Leads Data
Hard-Code Data Into Your Query Table
Build the Contacts Sub-query
Start on the Deals Sub-query
Join the Contacts Table to Deals
ESSENTIAL: Understand Table Aliases
Add Comments to Your Query and Review
Build the Instance for Closed Deals (Intro to Filtering)
Create Flippin’ Cool Charts with Your Query Table!
Reviewing the ABUNDANT Benefits of Query Tables
Previous Topic
Back to Course
Next Topic
Unlock the TRUE POWER of Zoho Analytics with SQL Query Tables Build Your Own Query Table From Scratch
close
  • Pricing
  • Get Help With Zoho
  • Free Zoho Learning Paths
  • Zoho Resources
    • Zoho Codebase
    • Zoho App Guides
Login
Lesson Content
0% Complete 0/11 Steps
Why Do We Need a Query Table For This?
Start With the Leads Data
Hard-Code Data Into Your Query Table
Build the Contacts Sub-query
Start on the Deals Sub-query
Join the Contacts Table to Deals
ESSENTIAL: Understand Table Aliases
Add Comments to Your Query and Review
Build the Instance for Closed Deals (Intro to Filtering)
Create Flippin’ Cool Charts with Your Query Table!
Reviewing the ABUNDANT Benefits of Query Tables
Previous Topic
Back to Course
Next Topic