Skip to main content

 

ThoughtSpot

Search using growth over time

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

You can show growth over time by using the "growth of" keyword in your search. This keyword compares the data from different date periods, and returns a percentage of growth.

To search using growth over time:
  1. Type growth of into the search bar, and choose a measure you're interested in seeing the growth of.
    File:01_The_Basics/end_user_guide_bookmap/030/010/010/growth_of_suggestions.png

    Growth of suggestions

    You will see a list of suggestions to choose from based on your sources. You can also type a different column name containing numeric data to compare.
  2. Then, type by, followed by a date column name.
  3. Switch to the Chart view for a visual representation of your search.
    File:01_The_Basics/end_user_guide_bookmap/030/010/010/growth_of_waterfall_chart.png

    Growth of total sales waterfall chart

    The growth is calculated as a positive or negative percentage, for each period relative to the last period in the series. The line chart is a good way to display your data, but the waterfall chart is especially effective to show growth.
  4. You can also do year-over-year analysis, which compares each time period to the corresponding time period in the prior year. This type of growth analysis is more common in retail and other seasonal businesses. To do this, type monthly year-over-year after your growth of phrase in the search bar.
    File:01_The_Basics/end_user_guide_bookmap/030/010/010/growth_of_year_over_year.png

    Growth of by monthly year-over-year

    This compares data between the same month from different years. For example, it will allow you to compare sales from June of this year to the sales from June of last year. Note that for the first year, values are labeled as "{Blank}" in the Data View since there are no previous data to compare them to.
  5. Add an attribute to your search see the breakdown of how each grouping of the attribute contributed to the overall growth of your measure. Click Configure Chart and add your attribute to the Legend field.
    File:01_The_Basics/end_user_guide_bookmap/030/010/010/growth_of_attribute_breakdown.png

    Growth of broken out by category

    It looks like Q4, FY 15 was a much more productive period for a number of categories compared to a year ago.
 

Growth of query video

  • Was this article helpful?