Skip to main content

Search using growth over time

You can easily visualize the growth of a measure over time using the growth of keyword in your Chart Builder.

Written by Connor Stallings
Updated this week

The growth of keyword compares data across different date periods and provides the percentage of growth. You should enter growth of at the beginning of your query.

Note that you can only use the growth of keyword once per query.

Growth of Measure by Year

To search using growth over time, follow these steps:

  1. Type growth of into the Chart Builder, and then select a measure for which you want to see the growth.


    You will see a list of suggested choices based on your data source. You can also manually type a different column name that contains numeric data for comparison.

  2. Type by, followed by a date column name.

    Trends AI calculates the growth of a measure as a positive or negative percentage for each period relative to the last period in the series. The calculation involves dividing the difference between the value of a measure at two dates by the value of the earlier date, then multiplying by 100 to yield a percentage.

    While a line chart provides a clear display of your data, the waterfall chart is particularly effective for visualizing growth:

  3. You can also perform a year-over-year analysis, which compares each time period to the corresponding time period in the previous year. To perform this, simply add monthly year-over-year after your growth of phrase in the Chart Builder.

    The year-over-year keyword compares data for the same period across different years. For example, it allows you to compare giving from June of the current year to giving from June of the previous year. Please note that for the first year, values are labeled as "{Blank}" in the Data View because there is no prior data to compare them to.

  4. Add an attribute to your search to see a breakdown of how each grouping within the attribute contributed to the overall growth of your measure.

    Select Layout from the side menu and select an attribute to Slice with color. Once you have the desired attribute selected and added to the Slice with color section, Apply your changes:


    Once you have the desired attribute selected and added to the Slice with color section, Apply your changes.

Display Periods (Daily) Over Time (Year-over-year)

The growth of keyword also supports more hierarchical date buckets and period calculations. The general syntax for a growth query is as follows:

growth of <measure_column> by <date_column> <bucket> <period-over-period>


The table below shows the possible buckets and the period-over keywords you can combine:

quarterly

monthly

weekly

daily

hourly

year-over-year

year-over-year

year-over-year

year-over-year

quarter-over-quarter

quarter-over-quarter

quarter-over-quarter

month-over-month

month-over-month

week-over-week

day-over-day

For example, consider the query growth of Amount by Daily Transaction Date month-over-month:

Did this answer your question?