Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a massive list of suburbs for some data. I want to be able to filter for :
** Mount Isa
** Not Mount Isa
so that my audience can explore the data not in the main block. Mount Isa is the greatest amount of data, but we are also interested in what happens outside of it.
I know within the front end we can use the sum({$<Suburb-={'MOUNT ISA'}>}Count) to pick those which aren't Mount Isa with the -= syntax
How do I set it up in the load script to basically say
If the suburb = 'MOUNT ISA', 'MOUNT ISA' ,
otherwise if it is NOT 'MOUNT ISA' then 'Not MOUNT ISA'
as MtIsa_or_Not (Fieldname)
so I can create a filter list with just 'MOUNT ISA' and 'Not MOUNT ISA' for my audience to explore the data in these 2 areas.
Thanks
May be this?
If(Suburb = 'MOUNT ISA', 'MOUNT ISA', 'Not MOUNT ISA') AS MtIsa_or_Not
May be this?
If(Suburb = 'MOUNT ISA', 'MOUNT ISA', 'Not MOUNT ISA') AS MtIsa_or_Not
Last time I went to Mount Isa I swallowed a fly.
Lol poor fly
So simple I can't believe I missed it - thanks - Doh!
Hello Clea,
Please close the thread if it answered your query. 🙂