• Replies 3 replies
  • Subscribers 961 subscribers
  • Views 163 views
  • Users 0 members are here
Related

Combine Postcode Geo Areas in Analytics

Emily Johnson
$organization

Hi all,

I was wondering if anyone had any clever formula they could share for combining some Postcode Geo Areas in Analytics? Basically I want to be able to see all geo areas in the same chart, but group some and leave others as they are. Some of our more local areas are split out with a level of granularity that isn't always useful.

Thanks in advance!

Emily

Parents
  • $organization

    Just a thought but you could bucket them -  an example off the top of my head. Hope this helps and apologies it it's a little basic.

    Below (on the left) is the sales by top 10 postcodes for a performance last year.

    We might want to look at how those postcode groups are distributed over performances (maybe traffic is bad mid week?)

    Buckets are

    1. Postcode 200 and 2010
    2. Postcode 2011, 2026, 2021
    3. Postcode 2031

    When you pop them in the bucketing filters you get the pivot on the right which you can then turn into a chart if you like.  

    So how did I get the buckets?

    Opening up the widget we can see that each column is a simple value with a filter.  I'm going to edit the first column 

    The formula for each of them is the same but with slightly different filters 

    (sum([Ticket  Count]) ,  [Primary Address Postcode1] )

    1. In the first bucket the filter is postcode equals 2000 OR 2010
    2. Second bucket is 2011 OR 2026 OR 2021
    3. etc.

    And here they are in a bar graph by Performance Day of Week

Reply
  • $organization

    Just a thought but you could bucket them -  an example off the top of my head. Hope this helps and apologies it it's a little basic.

    Below (on the left) is the sales by top 10 postcodes for a performance last year.

    We might want to look at how those postcode groups are distributed over performances (maybe traffic is bad mid week?)

    Buckets are

    1. Postcode 200 and 2010
    2. Postcode 2011, 2026, 2021
    3. Postcode 2031

    When you pop them in the bucketing filters you get the pivot on the right which you can then turn into a chart if you like.  

    So how did I get the buckets?

    Opening up the widget we can see that each column is a simple value with a filter.  I'm going to edit the first column 

    The formula for each of them is the same but with slightly different filters 

    (sum([Ticket  Count]) ,  [Primary Address Postcode1] )

    1. In the first bucket the filter is postcode equals 2000 OR 2010
    2. Second bucket is 2011 OR 2026 OR 2021
    3. etc.

    And here they are in a bar graph by Performance Day of Week

Children
No Data