Summary: Use the growth keyword to compute growth of metrics. Add the interval keyword such as Monthly to calculate growth in each month.
You can compute growth of a certain metric using the keyword “Growth”. This compares the value of the metric between two dates, and displays either the absolute or percentage value of the increase of decrease. Same as with other keywords, AnswerDock understands synonyms and you can use any of the growth keyword synonyms:
- Growth, Increase, Grow, Percentage growth, percent growth , percent increase, decline, decrease, etc..
Growth of metric comparing between two dates
For computing growth between two dates, you can use the compare keyword “Vs” to separate the two dates. Your question will take the form of :
Growth metric date1 vs date2
Alternatively, if you do not mention any dates, AnswerDock will take the default date period for the dataset and compare it to the previous equivalent period.
If you mention only one date, AnswerDock will automatically compare it with the previous period
Growth Metric date1
If you mention one date, and add a date comparison keyword like year on year, month on month, etc.. AnswerDock will compare it to the previous period as per the date comparison keyword, instead of the previous equivalent period
Growth Metric date1 year on year
Below are some examples:
|Growth in revenue||Will compute increase in revenue of the default date period vs the previous periode|
|Growth of revenue Feb 2018 vs jan 2018||Will compute increase in revenue (revenue in feb – revenue in jan)|
|Percent Growth of revenue Feb 2018||Will automatically compare feb 2018 to the equivalent previous period (Jan 2018)|
|Percent Growth of revenue Feb 2018 year on year||Will compare feb 2018 to the equivalent period previous year (feb 2017)|
|Growth of revenue this year||Will compare revenue this year to previous period (last year) and compute the growth|
|Percentage Growth of revenue quarter to date||Will compare revenue this quarter up to the current day to the equivalent duration in last quarter (not the whole quarter)|
Growth of metric over a time interval
If you combine the growth keyword with an interval keyword (e.g. monthly), you can compute growth over a period of time for each interval value. For example
|Growth of revenue this year Monthly||Will compute growth every month comparing to the previous month|
|Percentage Growth of revenue quarterly year on year||Will compute growth every quarter comparing to the same quarter previous year|
The default graph for the above is a waterfall chart, which shows the growth at every interval, green bar showing growth and red bar showing decrease in the metric.
Calculating Growth for Every Segment in a Dimension
Note that you can add dimensions to any of the above examples to get the growth by each segment of the mentioned dimension, for example:
- Percentage Growth of revenue quarter to date by country
Sorting by Growth
You can also use the top/bottom keyword to rank segments of a certain dimension by their growth. Also you can compute growth for number of records rather than a metric, as below:
- Top growing categories in number of orders this month
- Least growing teams in leads this month
Calculating Growth for Multiple Metrics
You can also compute growth for a number of metrics:
- Growth in sales profit number of orders last month compared to same month last year