Table of Contents generated with DocToc
Advanced Chart Calculations
Types of Advanced Calculations
Data Sources Supported by Advanced Calculations
| Data Source |
Percentage |
Percentile |
Year-on-Year |
Cumulation |
Shifting |
Repetition |
Retention |
Activity |
Window Calculation |
| Engine |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Postgresql |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Oracle |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Mysql8 |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| SQL Server |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Redshift |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| SQL Server |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Impala |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Presto |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Greenplum |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Hive |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| Spark SQL |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| DB2 |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| MaxCompute |
✓ |
✗ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
Note:
- Engine refers to datasets with the engine enabled.
- Tidb, Mysql 5, MongoDB do not support advanced calculations. MaxCompute does not support percentile calculations.
Interaction Rules for Advanced Calculations
- When involving rates, upon selection, the display format automatically switches to the percentage format with two decimal places. Upon deselecting the rate, all formats are cancelled.
- For Year-on-Year comparisons, cumulation, shifting, activity, and retention, they only appear when there are date fields in the dataset.
- When in time dimension calculation mode for time-related advanced calculations (Year-on-Year, cumulation, shifting, activity, retention), if the time dimension is selected with an aggregation method other than "day, week, month, quarter, year," or the time dimension is removed, the advanced calculation is cancelled (returns to "none" or the numeric fields revert to default aggregation calculations, such as "sum").
- When the time dimension is selected as "week," the division method for the week is based on the ISO 8601 time and date representation, i.e., if January 1st falls between Monday and Thursday, the week of January 1st is considered the first week of the year.
- When a new dimension is added in advanced calculations, the added dimension can function as a filtering condition.