I am working in a Mega Table transposing beast modes to get daily kpis. I would like to get the comparison of these daily kpis to avg for the 7 days preceding them: (current value - 7 day avg) / 7 day avg
I'd like this beast mode to appear in a column next to the daily value for each day. I'm just not sure how to get this to come through or if it's possible outside of an ETL. We attempted the ETL route but because of the filtering capability we'd like to use on the dashboard, an ETL will not work for us as the formulas need to be dynamic with the filterable fields.
Any suggestions?