Period over Period in a table

mdileo

I'm attempting to do a Period over Period in a table, but want to keep the date range to previous week/month/quarter to keep it auto-updating and grouping the data in a particular way. My idea was to create a new column in ETL that is the same as the column I'm trying to do a Period over Period calculation, but from the previous years value. Then I can make the Period over Period calculation myself in Beast Mode. I'm having trouble doing this in the ETL does anyone know how to perform this? Or another solution to this problem?

GrantSmith

You can utilize a custom date dimension / period dataset to calculate the different metrics for each date and then utilize a beast mode to create the columns for last month / last year / quarter etc. I've done a write up on this method here: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest