Advanced Calculations in Charts
Types of Advanced Calculations
Advanced data supported in charts includes percentages, percentiles, year-over-year/month-over-month comparisons, cumulative, moving, repetition, retention, activity, and window calculations.
- Percentages
- Percentiles
- Year-over-Year/Month-over-Month Comparisons
- Cumulative
- Moving
- Repetition
- Retention
- Activity
- Window Calculations
Data Sources Supported for Advanced Calculations
| Data Source | Percentages | Percentiles | Year-over-Year/Month-over-Month | Cumulative | Moving | Repetition | Retention | Activity | Window Calculations |
|---|---|---|---|---|---|---|---|---|---|
| Engine | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Postgresql | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Oracle | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Mysql8 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SQL Server 2017-CU8 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Redshift | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Impala | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Presto | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Greenplum | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Hive | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Spark SQL | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| DB2 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| MaxCompute | ✓ | ✗ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Note:
- "Engine" refers to datasets with the engine enabled.
- Tidb, Mysql 5, and MongoDB do not support advanced calculations. MaxCompute does not support percentile calculations.
Interaction Rules for Advanced Calculations
- For calculations involving "XX rate," the display format automatically switches to "percentage with two decimal places" when selected, and all formats are canceled when "XX rate" is deselected.
- For "Year-over-Year/Month-over-Month Comparisons," "Cumulative," "Moving," "Activity," and "Retention," they only appear when there is a date field in the dataset.
- When in the time dimension calculation mode for "Year-over-Year/Month-over-Month Comparisons," "Cumulative," "Moving," "Activity," and "Retention" (time-related advanced calculations), if the time dimension is selected as an aggregation method other than "day, week, month, quarter, year," or if the time dimension is removed, the advanced calculation is canceled (becomes "none" or the numeric field reverts to the default aggregation calculation, such as "sum").
- When the time dimension is selected as "week," the week division method follows the ISO 8601 date and time representation, meaning that if January 1st is from Monday to Thursday, the week containing January 1st is considered the first week of the year.
- When adding a new dimension for advanced calculations, the added dimension can serve as a filtering condition.