Postcode Sum from a range

Hi Rowan,

Normally with something like that I'd create 2 values and add a filter on a range ie: >=7000 or <7210 

But y'know ... trying it Postcodes aren't Numbers - they are strings which makes it a bit tricky.

I'll keep thinking

H

Hi Ronan,

2 quick thoughts for you...

If this is a one-off reporting need, you could pull Primary Address Postcode and Ticket Count in a Pivot Table and then download that widget as CVS or Excel, and do some quick manipulation there ... even just highlighting the Ticket Count value across the postcodes you're interested in and seeing the sum preview in the status bar.

If you'd like to keep it Analytics, and I recommend you do if you have any need to do this again, then you might try a Text filter on postcode. For Southern Tasmania, an OR set of criteria that looks like:

• Starts with 70
• Starts with 71
• Starts with 720

Then for the Northern Tasmania count, a Text filter AND criteria set that looks something like

• Starts with 7
• Doesn't start with 70
• Doesn't start with 71
• Doesn't start with 720

You could either have separate widgets for these, using widget level filters. Or to have both values in the same widget use a formula like:

( [Total Ticket Count] , [Primary Address Postcode] )

And for one instance of the formula, filter Primary Address Postcode for Southern Tasmania. Then duplicate the value and edit the filter to reflect the criteria for Northern Tasmania.

Thanks Chris. That's worked beautifully

Thanks Heath. Yep that's the stumbling block, but the solution below has worked adequately for this purpose

One day I'll get Geo area sorted and this kind of thing will be a moot point for me.