How to get the populer distribution channel by geographicaly

[gajananh999]

Dear All,

I have a data of insurance i want to check which is most popular channel of distribution by state.

Thanks and regards
Gajanan Hiroji

[Ayn · Accepted solution]

Well...

<yourbasesearch> | stats count by Channel,US_State

?

[gajananh999]

Hey Ayn Thank you so much i got it what i want.

[Ayn]

There we go, it's easier to know what you mean when you give direct examples...

... | top 1 Channel by US_State

should give you what you want.

[gajananh999]

This will give you all the channel with all the states i want all state with popular channel

it should be like

albama Direct
alaska Online
texas Broker

[gajananh999]

Hey Ayn,
I Have Channel like
1. Direct
2. Agent
3. Broker
4. online

Every Policy created by using any one of this Channel.

So i have residency address of Policy Holder so i want find which Channel is popular in which all states

I extracted the US_State from the address of the Policy Holder

I think this will give you all you wanted.

[Ayn]

We need way more details than this. What does your data look like? What did you do so far (create field extractions, setup sourcetypes, ...?) What "channels of distributions" are you talking about? What exactly would be your desired end result?