Day 17 - growth, part 02
You already know how to use the growth function and we even made a cool visualisation of what growth looks like from month to month. Today we'll add some power and expand on the possibilities. I invite you to join us for the next part of the #ThoughtSpotAdventCalendar. Door 17 is waiting to be opened.
You can use the growth function in different time frames. I bet one of the more frequent questions from your CFO now is what the year-on-year growth looks like and whether we will beat the previous year. We work at ThoughtSpot so analysing the data has to be available to everyone so You need only to change one keyword in command. In the example below you can see the analysis for different time periods. The only difference is the use of the keyword yearly, quarterly, monthly, weekly or daily instead monthly.
If you wish, you can use a field containing time and apply the keyword growth in terms of hours. In addition, we have filtered the results to Sunday only.
In past calculation, we have always changed the interval at which we present and compare periods simultaneously. By default, they are equal to each other. But perhaps you want to present data on a monthly basis but for each month compare how it changes from quarter over quarter? No problem. As you do by default, just add this phrase to the end of the command - quarter over quarter.?
领英推荐
Below you can see the difference without and after applying this additional command. The top image shows the situation when we present growth on a monthly basis and compare to the previous month. The bottom image is also the monthly bars but compared to the corresponding month of the previous quarter.
Other options such as month over month or week over week are available. The only thing you need to remember is that the reference period cannot be smaller than the one on which the data is presented. So, for example, you cannot show monthly bars and compare week to week. This is technically impossible.
In this way, we learnt more about the possibilities of analysing data from #SpeedOfThought and you didn't even realise we are in the block I described as advanced. See you tomorrow.