Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a field called Specialty groups (in the load script) which contains a number of units within it. How do I create a formula to just bring through one of the specialty groups in my analysis?
E.g. Specialty Groups = Surgical, Medical, Paediatrics, Mental Health. I only want to bring through data for 'Medical'. If I use Speciality Groups = 'Medical' it will bring through medical but group all the others into a separate column.
@Fig1 wrote:If I use Speciality Groups = 'Medical' it will bring through medical but group all the others into a separate column.
And what happens if you also uncheck the "Include null values" setting for that dimension?