Table of Contents

Search - Quick Guide

Ramya Priya Updated by Ramya Priya

Search offers a smart, Google-like interface that enables users to ask ad-hoc questions and effortlessly drill down to the granular details. Prioritizing user convenience and efficiency, Search eliminates the need for navigating through pre-established dashboards or generating SQL scripts to access data.

Understanding keywords

In your search queries, incorporate the following keywords as required to gain an in-depth analysis of your data.

  1. For filtering data: 'FOR' and 'IN'
  • 'FOR': "Show me sales for 2022"
  • 'IN': "Show me sales in Canada"
  1. For grouping data: 'BY'
  • 'BY': "Show me sales by product category"
  1. For comparing datasets or values: 'COMPARED TO' or 'VS'
  • 'COMPARED TO': "Show me Q1 sales compared to Q2 sales"
  • 'VS': "Show me sales of Product A vs Product B"
  1. For analyzing trends: Specify a date
  • Specify a date: "Show me sales trend since January 2023"
  1. For analyzing time series: 'BY MONTH' or 'BY WEEK'
  • 'BY MONTH': "Show me sales by month for 2022"
  • 'BY WEEK': "Show me weekly revenue for Q1 of 2023"
  1. For analyzing differences or variations: 'GROWTH' and 'CHANGE'
  • 'GROWTH': "Show me growth in sales from 2022 to 2023"
  • 'CHANGE': "Show me the change in profit from Q1 to Q2 of 2023"

Commonly used keywords and their applications

  1. avg (Average)

To get the average value, such as average sales, use 'avg'. Example: What are the avg sales?

  1. total

For summation, use 'total'. Example: Show me total sales in the US

  1. min (Minimum)

To find the smallest value, use 'min'. Example: What are the min sales in 2022?

  1. max (Maximum)

To determine the highest value, use 'max'. Example: What is the max sales in June 2023?

  1. growth

For monthly growth analysis, use 'growth'. Example: Monthly growth of sales last year

  1. market share

For market share analysis, use 'market share'. Example: Market share of dollar sales for BrandABC

  1. unique count

To count distinct items, use 'unique count'. Example: Unique count of returning_customers

  1. percentage change

To find the percentage change in sales between two periods, phrase your query as follows: Percentage change of sales for this year vs last year

  1. absolute change

To determine the absolute change in sales between two periods, phrase it as: Absolute change of sales for 2020 vs 2021

  1. top/bottom N

To filter by top or bottom performers, use 'top/bottom N'. Example: Show me top 5 products in sales by retailer

  1. contains

To search for a specific substring in your data, use 'contains'. Example: Show me sales for brand contains "fit"

  1. after/before

To filter data after or before a certain date, use 'after/before'. Example: Show me sales after March 2020

  1. between

To filter data between two specific dates, use 'between'. Example: Sales between March 2020 and March 2021

  1. trend

These queries help track changes over time or identify patterns within your data. Example: Show trend of monthly sales for New York vs Los Angeles

Did we help you?

Vizpads (Explore) - Quick Guide