/ Growth of Query

Growth of Query

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 get started, type “growth of” into the search bar. 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. Then, type “by”, followed by a date column name. Now in this case, we’re going to add filter to make the data more presentable.

Switch to the Chart view for a visual representation of your search. 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.

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”. 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} since there are no previous data to compare them to.

Let’s add the attribute “department description” to see the breakdown of how each department contributed to the overall growth of sales. Click the Chart axes icon and add Department Description to the Legend field. It looks like March 2015 was a much more productive month for a number of categories compared to a year ago.

Look in the Help Center to see more examples of how to use the growth of keyword, under Date keywords.