I am looking for a way to show a bar graph with sales data by period and a growth rate line with period over period percent change. I have a detailed dataset with a large amount of sales data spanning over multiple years. I am having trouble with how to get the prior period data to be on the same line and to be dynamic so that if it is filtered by region or by product line, the totals will change accordingly.
See below for example of final product I want to achieve - bars are total sales by quarter and the line is the QoQ growth rate. Right now I have a quick manual fix for a presentation (this is not real data), but it sums the total prior period and does not change if other variables are adjusted. Is this possible using a Magic ETL? A friend suggested using a method that grouped / ranked data, but I am not that sophisticated in Domo, so I am not sure how to achieve that, although I am trying to learn. Any help would be appreciated.