-
Hi Paul,
thank you for your reply! I have read all of your posts again and you are spot on!
I donīt want to double count and I donīt want to use the A way.
I have condensed my metrics down to two metrics.
Metric A is the score of city vs city. Metric B is the score of city vs state. I am planning to weight my metrics 50% and 50%. So city01 vs city02 in metric A could be 55 and metric B could be 77. Metric A is a combination of other metrics and a score of 55 means that there are 55 comparisons where metric A is above the City 2 value and 77 is also a combination of metrics where metric B is above or equal to the state mean.
Ex. City01 has a value of size that is greater then City02 and also greater then the state mean. The state mean is calculated from all cities in that state.
So what I am trying to do now is to get my output (in the attachment above) to be as in your example.
But I am not sure how?
Last edited by waimea; 04-19-2019 at 01:21 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules