📄️ Percent change from previous
The percent change gives you the percent change in a value compared to the value in the row above it.
📄️ Percent of previous value
The percent of previous value gives you the percent of a value compared to the value in the row above it.
📄️ Percent of column total
The percent of the column total will give you the percentage of each value in the column out of the total sum of the values in the column.
📄️ Percent of group/pivot total
The percent of the group/pivot total will give you the percentage of each value in a group out of the total sum of the values for that group.
📄️ Rank in column
Ranking values in a column is when you set every value as a number either higher than or lower than the other values. The lowest value (rank = 1) indicates the value with the first rank in your set of values.
📄️ Running total
Running totals give you the sum of a value + all of the previous values in that column.
📄️ Rolling window
Rolling windows, or lookbacks, calculate metrics like rolling averages using the current row combined with N previous rows. This can be useful for smoothing out volatile time series data to better understand long term trends.