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.
Maybe like
=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)
as calculated dimension, and check supress when Value is NULL in dimension tab.
Maybe like
=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)
as calculated dimension, and check supress when Value is NULL in dimension tab.
Thanks swuehl, as usual you got it! Only thing is I'm still left with an empty spot in addition to the 'hot' and 'cold' field. How would I suppress that?
Have you checked the 'Suppress when Value is NULL' in dimension tab?
If so, how does your table look like? What do you mean with empty spot?
Awwh swuehl! A smart one you are!