![]() If I switch the aggregation of these three metrics to AVERAGE it’s more representative but not exact. Two issues I face, are the New users, Returning users and Total user amount aggregate as SUM. I want to add a 4th series, as the 3-month moving average using your formula provided:ĭATE_DIFF(ISO week of ISO year (spare),ISO week of ISO year (main)) = 0 Field (TU – NU)) (Series 2 Stacked Bar), Total users (Line with no line to list total users for the week (data label)) ![]() – Metrics: New users (Series 1 Stacked Bar), Returning users (Calc. This is going to be a ridiculously stupid question, but I’m going for it…Ĭontext: I’m creating a weekly website traffic report for a running 53 week view.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |