Hi All,
I'm new to using formulas in analytics, and I have a problem that I think should be easy to solve.
I've added elements primary address postcode (PAA) and ticket count (TC).
I would like to make a formula that returns two rows
(i'm ok if we don't get the row's renamed, just need those totals).
Any ideas?
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
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.