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.
Here's an example of a percent of previous value calculation:
And here's the SQL that was used to generate it:
${orders.total_order_amount} /
LAG(${orders.total_order_amount}) OVER (
ORDER BY
${orders.order_date_week},
${orders.status}
)
In general, the SQL used for calculating the percent of the previous value has two bits (with an optional third bit):
column_I_want_to_compare
- this is the column with the values you want to comparecolumn_I_want_to_order_by
- this is the column you want to use to order the values you want to compareoptional_other_column_I_want_to_order_by
- this column is optional and you can add as many moreorder by
columns as you need. Normally, you'll need to add every dimension in your results table to theORDER BY
bit in your SQL. And, the order of these will need to be the same as the ordering you've added to the columns in your results table.
Here's the SQL you can copy-paste to calculate the percent of the previous value​
${table.column_i_want_to_compare} /
LAG(${table.column_i_want_to_compare}) OVER (
ORDER BY
${table.column_I_want_to_order_by},
${table.optional_other_column_I_want_to_order_by}
)
Make sure to add percent formatting to your calculation​
In the format
tab, make sure to update the format to percent
so that your table calculation is shown as a percentage value (instead of a number).