Hengshi Documentation
Table of Contents generated with DocToc
Year-over-Year and Sequential Growth Comparison
The smallest dimension aggregation supported for year-over-year and sequential growth comparison calculations is "day," with the largest being "year."
The location of the year-over-year and sequential growth comparison menu is shown in the image below:
Year-over-year and sequential comparison not only support comparison with the previous period but also support specifying a relative date, as shown in the image below:
Currently, a major highlight of our product is that the table supports "trend indication," as shown in the image below. When calculating the year-over-year and sequential comparison, after checking the "trend indication," the displayed trend indication is as follows:
Interactive Year-over-Year and Sequential Growth Comparison in Time Dimension
When switching the time dimension's aggregation unit (day, week, month, quarter, year), the contents of the "Comparison Type" drop-down list will automatically adjust:
| Time Dimension Aggregation | Sequential | Week | Month | Year | Relative Date |
|---|---|---|---|---|---|
| Daily | Sequential | Same week last year | Same month last year | Same year last year | Previous N days |
| Weekly | Sequential | - | - | Same year last year | Previous N weeks |
| Monthly | Sequential | - | - | Same year last year | Previous N months |
| Quarterly | Sequential | - | - | Same year last year | Previous N quarters |
| Yearly | Sequential | - | - | - | Previous N years |
When the time dimension's aggregation unit (day, week, month, quarter, year) is switched, the previously selected "Comparison Type" content will be adjusted accordingly and recalculated.
If the "Comparison Type" cannot be found in the drop-down list when switching the aggregation unit of the time dimension, advanced calculations are canceled and changed to "none."
For example, if the time dimension was aggregated daily and we chose "Same week last year," then if we switch to a weekly aggregation, we can't find the "Same week last year" comparison type, so advanced calculations should be canceled and changed to "none."
Interactive Year-over-Year and Sequential Growth Comparison in Non-Time Dimensions
Comparative types associated with different time dimension aggregation units:
| Aggregation Unit of Time Dimension | Sequential | Same Week Last Year | Same Month Last Year | Same Year Last Year | Relative Date | Fixed Date |
|---|---|---|---|---|---|---|
| Daily | Sequential | Same week last year | Same month last year | Same year last year | Today/Yesterday/Previous N days, compared to M days before | Specified days, compared to those days |
| Weekly | Sequential | - | - | Same year last year | This week/Last week/Previous N weeks, compared to M weeks before | |
| Monthly | Sequential | - | - | Same year last year | This month/Last month/Previous N months, compared to M months before | |
| Quarterly | Sequential | - | - | Same year last year | This quarter/Last quarter/Previous N quarters, compared to M quarters before | |
| Yearly | Sequential | - | - | - | This year/Last year/Previous N years, compared to M years before |
When switching the time dimension's aggregation unit (day, week, month, quarter, year), if there is a corresponding option, then switch to it (for example, if comparing relative dates, when aggregating by day, yesterday compared to 3 days before, when switching to weekly aggregation, it can change to last week compared to 3 weeks before). If there is no corresponding option, then switch directly to "Sequential."