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
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
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] )
And here they are in a bar graph by Performance Day of Week
Thanks so much Heath - I haven't had a chance to try this yet but it looks like it'll do the job. Not used bucketing filters before so this'll no doubt be useful in other areas too.
Glad to help. Bucketing can be a game changer
I recommend listening to the smooth sounds of Chris Wallingford on Take Your Tessitura Analytics Skills to the Next Level here - bucketing is 7:20 in
https://www.tessituranetwork.com/en/Items/Videos/Webinars/2019/Tessitura_Analytics_Skills