Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I only use certain records of my dimension field? Example I have a field with (Hot, Cold, Warm) as the possible values. I want to only have Hot and Cold as the ones that show up in my graph fot that dimension.
Hi Brandon,
just try function:
ValueList('Hot', 'Cold')
as a calculated dimension.
- Ralf
Try
=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)
edit:
Oh, I just thought I have already answered the question but forgot to commit 😉