Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
can anyone help with following. I have a dimension (status) that has following content: Idea, IN-Progress.
on a scatter plot chart I want use "status" dimension but only for the "Idea" dimension values.
Using this formula for dimension but no luck. Can anyone help?
=({<Status={'Idea'}>}Status)
or
=Status{<Status={'Idea'}>}
Thanks a million!
Jose
Jose,
What you wrote above is set analysis which is alone of no use. Set analysis can only be used along with an aggregation function, like: Sum( <your set analysis> Sales) or Count(.... That means, you are trying with an incomplete expression. Other part of discussion would be here that, if you are trying to use this restriction in dimension, you don't need set analysis; you could use a simpler expression with If, like:
=If(Status='Idea', Status)
Jose,
What you wrote above is set analysis which is alone of no use. Set analysis can only be used along with an aggregation function, like: Sum( <your set analysis> Sales) or Count(.... That means, you are trying with an incomplete expression. Other part of discussion would be here that, if you are trying to use this restriction in dimension, you don't need set analysis; you could use a simpler expression with If, like:
=If(Status='Idea', Status)
Thanks a million for your reply and explanation.
it help a lot!