I have a data set that updates daily and contains 28 days of logs. It contains unique identifiers and concatenated call letters and frequency band.
It has two columns End Date Events and Unique panelists that need a few averages calculated for each:
7 day average, last 4 day of week average
How would I structure a multi-row calculation to check if the call-ltr-band is the same and the media date to calculate these?
Attached is a sample. I looked at this:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-the-7-day-trailing-avg-given-a-specific-date/td-p/16769 but it uses a row count, not all the stations report all 7 or 28 days so using this assumption would result in miscounts
