calculated dimesnion

[manoranjan_d]

Hi,

I have a field of passfailflag,

I want to create chart for the fail, so in the dimension how can i create calculated dimension for fail.

[sunny_talwar]

I think its better to use set analysis in your chart. May be like this:

{<passfailflag = {'fail'}>}

or if you still want to use dimension, you can try this:

If(passfailfalg = 'fail', passfailflag)

UPDATE: Just made sure to check 'Suppress When Value Is Null' option on the dimensions tab if you plan to use the calculated dimensions

[Anonymous]

Create a dimension as :

=if(passfailflag = 'fail' , 'Fail' , Null())

and uncheck the suppress null values checkbox .

[manoranjan_d]

{<passfailflag = {'fail'}>} its showing garbage error, will that set analysis will work?

[sunny_talwar]

Using that alone will not work, it needs to be added to you current expression's set analysis. What is the current expression/s you are using?

[manoranjan_d]

garbage after expression "='

[sunny_talwar]

You are getting this for the set analysis or the dimensions?