Forum Discussion
Complex Dynamic Ranking
Yesterday when I posted this question, I couldn't tell if it actually got posted or not because the post woudn't show up anywhere. At any rate, I ended up figuring out that if I remove market_area from my table visual, the ranking would work appropriately. The ranking measure was basically ranking the VPs against one another based on the Selected Results BUT by Market Area as opposed to a whole.....if that makes sense. So I ended up replacing market_area (which is a column name) with a measure that returned the market_area, and the ranking measure worked as it should. I'm not sure why this worked, but it did.
Super UserI would consider normalizing the data somewhat, and I would probably also unpivot the metrics to make the selection and calculation easier. But it will be some effort - not sure if you are willing to invest that.
Yesterday when I posted this question, I couldn't tell if it actually got posted or not because the post woudn't show up anywhere. At any rate, I ended up figuring out that if I remove market_area from my table visual, the ranking would work appropriately. The ranking measure was basically ranking the VPs against one another based on the Selected Results BUT by Market Area as opposed to a whole.....if that makes sense. So I ended up replacing market_area (which is a column name) with a measure that returned the market_area, and the ranking measure worked as it should. I'm not sure why this worked, but it did.