Is it possible to calculate ROAS and WoW change in the same beast mode formula?
I'm working on a pivot table and I want to show the % change of ROAS from last week vs. two weeks ago. My dataset does not contain a 'ROAS' column so I'm trying to calculate it within the WoW beast mode formula. If I breakout the formula below into two parts (LW ROAS vs. 2WA ROAS), the first part will correctly give me…
Pivot Table Week over Week % Change
I want to show the WoW % change for my data but not really sure how to go about it. My raw data is daily and I grouped it into weeks in the pivot table. I want to add a column to my table where it will show the % change of sales from the previous week.
Top N items in tree map
I'm working on a tree map and its way too clutter due to the large number of items in the data. Is there way to limit the number of items showing in a tree map? I want the top N items based off sales.
Issues with filtering different datasets
I'm having issues where filtering in my dashboard isn't working correctly between two datasets. I'm trying to use a filter that is based off of 'campaigns', so whenever I choose a product I want the filter to show keywords that are in that specific campaign and vice versa (keywords will show what products are in the…