Tellius
  • ๐ŸšฉGetting Started
    • ๐Ÿ‘‹Say Hello to Tellius
      • Glossary
      • Tellius 101
      • Navigating around Tellius
      • Guided tours for quick onboarding
    • โšกQuick Start Guides
      • Search
      • Vizpads (Explore)
      • Insights (Discover)
    • โœ…Best Practices
      • Search
      • Vizpads (Explore)
      • Insights (Discover)
      • Predict
      • Data
    • โฌ‡๏ธInitial Setup
      • Tellius architecture
      • System requirements
      • Installation steps for Tellius
      • Customizing Tellius
    • Universal Search
    • ๐Ÿ Tellius Home Page
  • Kaiya
    • โ™Ÿ๏ธUnderstanding AI Agents & Agentic Flows
      • Glossary
      • Composer
      • ๐Ÿ—๏ธTriggering an agentic workflow
      • The art of possible
      • Setting up LLM for Kaiya
    • ๐ŸคนKaiya conversational AI
      • โ“FAQs on Kaiya Conversations
      • Triggering Insights with "Why" questions
      • Mastering Kaiya conversational AI
  • ๐Ÿ”Search
    • ๐Ÿ‘‹Get familiar with our Search interface
    • ๐Ÿค”Understanding Tellius Search
    • ๐Ÿ“Search Guide
    • ๐Ÿš€Executing a search query
      • Selecting a Business View
      • Typing a search query
      • Constructing effective search queries
      • Marketshare queries
    • ๐Ÿ”‘Analyzing search results
      • Understanding search results
      • Search Inspector
      • Time taken to execute a query
      • Interacting with the resulting chart
    • ๐Ÿ“ŠKnow your charts in Tellius
      • Understanding Tellius charts
      • Variations of a chart type
      • Building charts from Configuration pane
      • List of chart-specific fields
      • Adding columns to fields in Configuration pane
      • Absolute and percentage change aggregations
      • Requirements of charts
      • Switching to another chart
      • Formatting charts
      • Advanced Analytics
      • Cumulative line chart
    • ๐Ÿง‘โ€๐ŸซHelp Tellius learn
    • ๐Ÿ•ต๏ธโ€โ™‚๏ธSearch history
    • ๐ŸŽ™๏ธVoice-driven search
    • ๐Ÿ”ดLive Query mode
  • ๐Ÿ“ˆVizpads (Explore)
    • ๐Ÿ™‹Meet Vizpads!
    • ๐Ÿ‘‹Get familiar with our Vizpads
    • #๏ธโƒฃMeasures, dimensions, date columns
    • โœจCreating Vizpads
    • ๐ŸŒApplying global filters
      • Filters in multi-BV Vizpads
      • Filters using common columns
    • ๐Ÿ“ŒApplying local filters
    • ๐Ÿ“…Date picker in filters
      • Customizing the calendar view
    • โœ…Control filters
      • Multi-select list
      • Single-select list
      • Range slider
      • Dropdown list
    • ๐Ÿ‘๏ธActions in View mode
      • Interacting with the charts
    • ๐Ÿ“Actions in Edit mode
      • ๐Ÿ—จ๏ธViz-level actions
    • ๐Ÿ”งAnomaly management for line charts
      • Instance level
      • Vizpad level
      • Chart level
    • โณTime taken to load a chart
      • Instance level
      • Vizpad level
      • Chart level
    • โ™Ÿ๏ธWorking with sample datasets
    • ๐Ÿ”Swapping Business View of charts
      • Swapping only the current Vizpad
      • Swapping multiple objects
      • Configuring the time of swap
    • ๐Ÿค–Explainable AI charts
  • ๐Ÿ’กInsights (Discover)
    • ๐Ÿ‘‹Get familiar with our Insights
    • โ“Understanding the types of Insights
    • ๐Ÿ•ต๏ธโ€โ™‚๏ธDiscovery Insights
    • โž•How to create new Insights
      • ๐Ÿ”›Creating Discovery Insight
      • ๐Ÿ”‘Creating Key Driver Insights
      • ใ€ฐ๏ธCreating Trend Insights
      • ๐Ÿ‘ฏCreating Comparison Insights
    • ๐ŸงฎThe art of selecting columns for Insights
      • โžก๏ธHow to include/exclude columns?
  • ๐Ÿ”ขData
    • ๐Ÿ‘‹Get familiar with our Data module
    • ๐Ÿฅ‚Connect
    • ๐ŸชนCreate new datasource
      • Connecting to Oracle database
      • Connecting to MySQL database
      • Connecting to MS SQL database
      • Connecting to Postgres SQL database
      • Connecting to Teradata
      • Connecting to Redshift
      • Connecting to Hive
      • Connecting to Azure Blob Storage
      • Connecting to Spark SQL
      • Connecting to generic JDBC
      • Connecting to Salesforce
      • Connecting to Google cloud SQL
        • Connecting to a PostgreSQL cloud SQL instance
        • Connecting to an MSSQL cloud SQL instance
        • Connecting to a MySQL Cloud SQL Instance
      • Connecting to Amazon S3
      • Connecting to Google BigQuery
        • Steps to connect to a Google BigQuery database
      • Connecting to Snowflake
        • OAuth support for Snowflake
        • Integrating Snowflake with Azure AD via OAuth
        • Integrating Snowflake with Okta via OAuth
        • Azure PrivateLink
        • AWS PrivateLink
        • Best practices
      • Connecting to Databricks
      • Connecting to Databricks Delta Lake
      • Connecting to an AlloyDB Cluster
      • Connecting to HDFS
      • Connecting to Looker SQL Interface
      • Loading Excel sheets
      • ๐ŸšงUnderstanding partitioning your data
    • โณTime-to-Live (TTL) and Caching
    • ๐ŸŒทRefreshing a datasource
    • ๐ŸชบManaging your datasets
      • Swapping datasources
    • ๐ŸฃPreparing your datasets
      • ๐ŸคพActions that can be done on a dataset
      • Data Pipeline
      • SQL code snippets
      • โœ๏ธWriteback window
      • ๐ŸงฉEditing Prepare โ†’ Data
      • Handling null or mismatched values
      • Metadata view
      • List of icons and their actions
        • Functions
        • SQL Transform
        • Python Transform
        • Standard Aggregation
        • Creating Hierarchies
      • Dataset Scripting
      • Fusioning your datasets
      • Scheduling refresh for datasets
    • ๐ŸฅPreparing your Business Views
      • ๐ŸŒŸCreate a new Business View
      • Creating calculated columns
      • Creating dynamic parameters
      • Scheduling refresh for Business Views
      • Setting up custom calendars
    • Tellius Engine: Comparison of In-Memory vs. Live Mode
  • Feed
    • ๐Ÿ“ฉWhat is a Feed in Tellius?
    • โ—Alerts on the detection of anomalies
    • ๐Ÿ“ฅViewing and deleting metrics
    • ๐Ÿ–ฒ๏ธTrack a new metric
  • Assistant
    • ๐Ÿ’Introducing Tellius Assistant
    • ๐ŸŽคVoice-based Assistant
    • ๐Ÿ’ฌInteracting with Assistant
    • โ†–๏ธSelecting Business View
  • Embedding Tellius
    • What you should know before embedding
    • Embedding URL
      • ๐Ÿ“ŠEmbedding Vizpads
        • Apply and delete filters
        • Vizpad-related actionTypes
        • Edit, save, and share a Vizpad
        • Keep, remove, drill sections
        • Adding a Viz to a Vizpad
        • Row-level policy filters
      • ๐Ÿ’กEmbedding Insights
        • Creating and Viewing Insights
      • ๐Ÿ”ŽEmbedding Search
        • Search query execution
      • Embedding Assistant
      • ๐Ÿช„Embedding Kaiya
      • Embedding Feed
  • API
    • Insights APIs
    • Search APIs
    • Authentication API (Login API)
  • โœจWhat's New
    • Release 5.4
      • Patch 5.4.0.x
    • Release 5.3
      • Patch 5.3.1
      • Patch 5.3.2
      • Patch 5.3.3
    • Release 5.2
      • Patch 5.2.1
      • Patch 5.2.2
    • Release 5.1
      • Patch 5.1.1
      • Patch 5.1.2
      • Patch 5.1.3
    • Release 5.0
      • Patch 5.0.1
      • Patch 5.0.2
      • Patch 5.0.3
      • Patch 5.0.4
      • Patch 5.0.5
    • Release 4.3 (Fall 2023)
      • Patch 4.3.1
      • Patch 4.3.2
      • Patch 4.3.3
      • Patch 4.3.4
    • Release 4.2
      • Patch 4.2.1
      • Patch 4.2.2
      • Patch 4.2.3
      • Patch 4.2.4
      • Patch 4.2.5
      • Patch 4.2.6
      • Patch 4.2.7
    • Release 4.1
      • Patch 4.1.1
      • Patch 4.1.2
      • Patch 4.1.3
      • Patch 4.1.4
      • Patch 4.1.5
    • Release 4.0
Powered by GitBook

ยฉ 2025 Tellius

On this page
  • Example Query
  • Starting with Basic Queries
  • Moving to Intermediate Queries
  • Exploring Complex Queries

Was this helpful?

Export as PDF
  1. Search
  2. Executing a search query

Constructing effective search queries

Search techniques to craft queries that yield the most relevant and comprehensive results.

From basic to complex queries, Tellius' powerful search engine is designed to interpret and analyze a vast array of questions, paving the way for informed decision-making.

This guide explores the skillful and strategic use of search techniques to leverage the full potential of Tellius Search.

Example Query

To demonstrate the query structure, consider the example below:

total revenue by product for New York monthly

Components of the query

  1. Aggregation: Specifies the mathematical operation to be performed on the data.

    • Keyword: total

    • Measure: revenue

  2. Grouping: Defines how data should be grouped.

    • Keyword: by

    • Dimension: product

  3. Filtering: Applies conditions to narrow down the data.

    • Keyword: for

    • Value: New York

  4. Time Resolution: Determines the time frame for the data.

    • Value: monthly

Query keywords and values

  • Groupby Keyword: by Used to group data based on a specific dimension.

  • Combined Groupby: and Allows for grouping by multiple dimensions.

  • Filter Keyword: for, in Applies a filter to narrow down the data.

  • Time Resolution: monthly, yearly, quarterly, daily, weekly Specifies the temporal granularity of the data.

  • Comparison between Values: compared to, vs Used to set up a comparison between different data sets.

  • Time-based Filters: Examples include last year, March 2020, this week, Q4 2019 Filters the data based on specific time periods.

  • Additional Logical Functions: contains, = Provides additional logical operations to refine the data.

Constructing a query

When constructing a query, it is essential to combine these components logically to ensure accurate data retrieval. Here's the structure to follow:

  1. Start with an aggregation keyword and the measure you want to analyze.

  2. Use the groupby keyword to define how to break down the measure.

  3. Apply filters using filter keywords and values to specify the subset of data you need.

  4. Define the time resolution to determine the period over which the data should be aggregated.

Starting with Basic Queries

Basic queries that involve direct data retrieval serve as the foundation for any search. Try these straightforward questions, which are excellent starting points for deeper analysis.

Simple data requests

  • "Show total profit"

  • "Show average profit in 2023"

Combining multiple parameters

  • "Show revenue and quantity_sold"

  • "Show sales and profit by category"

Regional or category-specific queries

  • "Show count profit for California"

  • "Show total profit by category by region"

Keywords such as "from", "before", and "after" can be used for time-period-related queries. Example: Show me profit after January 2023 and before September 2023.

Moving to Intermediate Queries

These queries incorporate multiple elements like time frames, filters, or comparison metrics, offering more refined results.

Filters

Queries that extract data based on specific conditions or criteria.

  • "Show average profit by country for furniture"

  • "Show total sales by ProductName for Texas"

  • "Show total hours worked by Department"

Dates and time ranges

Queries focusing on data within a specified date or time period.

  • "Show minimum users for the last 2 months"

  • "Show top 3 performers by sales region this year"

  • "Show bottom 5 Profit by Country for the last quarter"

Resolution

Queries that break down data into specific time intervals.

  • "Show total training hours completed by employees monthly"

  • "Show yearly progression of employee satisfaction scores across all departments"

  • "Show average sales and average profit quarterly"

Percentages

Queries that calculate and compare data in percentage terms.

  • "What's the percentage profit for technology compared to furniture?"

  • "What is the percentage of employees meeting performance targets by department?"

  • "Give me the percentage profit for electronics compared to apparel for all categories"

Absolute change and Percentage change

  1. Absolute change: This refers to the direct difference in a metric's value between two time periods, not considering the size of the initial value. It is useful for understanding the exact increase or decrease in a metric.

  2. Percentage change: In contrast, percentage change provides the proportional change in a metric, relative to its original value. It's expressed as a percentage, offering a sense of the scale or significance of the change, especially in relation to the starting point.

  • "What is the percentage change in annual employee satisfaction scores from 2020 to 2023?"

  • "Show the percentage change in the number of new hires in the Sales department in 2019 vs 2023"

  • "Absolute change in customer support tickets resolved in 24 hours"

Time-Based

Queries focusing on data related to specific time frames.

  • "Show me the total Profit for 2022"

  • "Show the total helpdesk tickets resolved in January 2022"

  • "Show total cybersecurity incidents reported in Q2 2022 compared to Q2 2023"

Contains

Queries that filter data based on the presence of specific terms or phrases.

  • "Show total discount by region for suppliers containing Global"

  • "Show total sales by region where product_name contains Panasonic"

  • "List employees whose job title contains 'Manager'"

"Since" or "From"

The terms "Since" and "From" are equivalent to the "greater than or equal to" (>=) operator, which will be applied to the subsequent date/time value. The data following "since" or "from" can specify a year, a month, or a specific date.

  • "List all transactions for product_abc since April 1, 2021"

  • "Show sales growth in New York since January 2020."

  • "Show employee turnover rates since 1/11/2021."

Compared to

Queries that perform comparative analysis between different data sets or values.

  • "Show sum profit by country for technology compared to furniture"

  • "Show average sales in Q1 compared to Q2"

  • "Show total sales by category for Ohio compared to Texas"

Top N and Bottom N

Queries to identify the highest or lowest-performing data points.

  • "Show bottom 5 employee turnover rates by department for the last 3 years."

  • "Show top 10 employee performance ratings by role and location."

  • "Show top 3 revenues by region this quarter."

Exploring Complex Queries

Complex queries combine multiple conditionals and elements such as filter, resolution, time range, and compared to, for in-depth analysis.

  • "Show sum Profit by Country for Technology compared to Furniture monthly for the last 4 years."

  • "Show daily number of customer support calls for Software A in 2020 compared to 2021."

  • "Show quarterly data breach incidents for North American operations compared to European operations for the last 2 years."

Combining trends, growth, and segments

Queries aimed at analyzing trends, growth patterns, and segmenting data.

  • "Show segments of average sales and average revenue by category."

  • "Show trend of average employee retention rates monthly for this year."

  • "Show trend of average customer ticket resolution time monthly for this year."

Top N and Bottom N comparison with GroupBy

Advanced queries that rank Top N or Bottom N dimensions based on specified segments or trends.

  • "What are the top 5 Product Categories by Subscription rate in the region?"

  • "Show top 3 customers with the most returns yearly."

  • "List the bottom 10 vendors by revenue in the last 6 months."

Query for the immediate preceding time period

Users can compare a chosen period against its immediate predecessor to gain insights into short-term performance, identify emerging trends, and monitor current growth against recent historical data.

The query can be used for days, weeks, months, years, and quarters.

Other variations:

  • Show me sales of last n [days/weeks/months] this year [vs/compared to] prior n [days/weeks/months] last year

  • Show me sales of last n [days/weeks/months] [vs/compared to] the preceding period

  • Show me sales of last n [weeks/months] [vs/compared to] the prior n [weeks/months]

Query for YoY time period comparison

Users can assess the performance against the same time period from the previous year to understand seasonal trends, benchmark against the previous year's performance, and measure yearly growth/decline in a more granular manner.

The query can be used for days, weeks, months, years, and quarters.

Other variations:

  • Show me sales for the last x [days/weeks/months/quarters] this year [vs/compared to] last year

  • Show me sales for the last x [days/weeks/months/quarters] this year [vs/compared to] x days last yearย 

  • Show me sales by segment for the last x [days/weeks/months/quarters] this year [vs/compared to] x [days/weeks/months/quarters] last year

PreviousTyping a search queryNextMarketshare queries

Last updated 15 days ago

Was this helpful?

๐Ÿ”
๐Ÿš€
"Show total profit"
"Show sales and profit by category"
"Show total profit by category by region"
"Show total sales by ProductName for Texas"
"Show bottom 5 Profit by Country for the last quarter."
"Show average sales and average profit quarterly."
"What's the percentage profit for technology compared to furniture?"
"Percentage change in profit for 2013 vs 2014"
"Show the total Profit for Jan 2013 compared to Feb 2013"
"Show total sales by region where Product_Name contains Panasonic Inkjet, Red"
"Show me monthly profit for Panasonic since 2013"
"Show sum profit by country for technology compared to furniture"
"Show top 3 revenues by region this quarter."
Show avg profit by segment for technology compared to furniture monthly for the last 3 quarters
"Show segments of average sales and average profit by category"
"Show top 3 customers with the most returns monthly"
"Show me sales of last 2 months vs the prior 2 months"
"Show me sales by segment for the last 4 weeks this year vs 4 weeks last year"