Using Quick Table Calculations to Analyze Data


>> Concept: Table calculations

Table calculations are

  • computations that are applied to the values in the data table for the view
  • and calculations available often dependent on the table structure itself

>> Quick Table Calculations

Quick Table Calculations:

  • Running Total (汇总)
  • Difference (差异)
  • Percent Difference (百分比差异)
  • Percent of Total (合计百分比)
  • Rank (排序)
  • Percentile (百分位)
  • Moving Average (移动平均)
  • YTD Total : same as Running Total, but is running along the date dimension and restarting for event Year part of the date dimension (YTD总计)
  • Compound Growth Rate (통합 성장률 / 复合增长率)
  • Year over Year Growth (전년대비 성장률 / 年度同比增长)
  • YTD Growth : compares the YTD Total of current year with YTD Total for the previous year (YTD增长)

Running Total vs YTD Total vs YTD Growth

YTD (Year to Date): The period from the beginning of a fiscal year to the end of a reporting period. (올해 초부터 현재까지)


>> Calculation Scope and Direction

Scope: Table / Pane / Cell (Scope: the segment of the table that the calculation is applied to)

image-20210531090118121


Direction: across / down / across then down / down then across