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:
Type
growth ofinto 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.
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:
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-yearkeyword 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.
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For example, consider the query growth of Amount by Daily Transaction Date month-over-month:





