Displaying most frequent field as color in scatter plot
Hi QVers,
Question: How can I display the most frequent of a certain field by another dimension?
I am looking at displaying the most used channel by zip code. In the example below I have 3 zip codes: 90210, 90211, 90212, and 90213. In the first, Internet is most common channel, and it is Store and Call Center, and Call Center respectively for the last two. I want to represent this phenomenon by the color of the dot. I can't figure out how to get the first sorted value when I need two dimensions in an aggr. Any ideas?
