Good Morning,
I am trying to find the Count of occurrences of a particular metric that are above the average of that metric.
So I can "Avg" the metric in my query (that works easily), but then I'm trying to pull the Count of that metric and in the Criteria field I'm using >Avg("Metric"). It seems to recognize what I want to do, but when I run the query I get "Data type mismatch in criteria expression."
Any help on fixing this would be greatly appreciated. Is it possible?
Thanks,
Ben
Bookmarks