Crystal Scherba
Posts
Recent activity by Crystal Scherba
Sort by recent activity
-
Remove "Undefined" in Calculation
I'm using the following calculation for % change week over week: (sum(0, 0, m1) - sum(-1, 0, m1)) / sum(-1, 0, m1) However, the first week is showing "Undefined". I just need to hide that value. I ...
-
How do I calculate the average for each day of the week?
I need to be able to calculate the average visits per location for each day of the week. Any help is greatly appreciated! I haven't been able to figure it out. See example below. The yellow highlig...