Finding the Max Average
Can someone help me build a beastmode to locate the max average?
I am trying to return the average day with that, on average, shares the highest value of the week.
By taking the max average of days, with the max average of days with the highest values, is it possible to discover the day that returns the highest avg?
I understand this may be a combination of the Magic ETL+Analyzer, but I'm stumped where to start.
Should I create another dataset that just includes the date and the values?