Calculation Condition and Detached

[#1]

Hi I have hopefully have a simple question I have a Chart with a straight table list of Projects, there is a field [Project Status] that can have a number of variables ,  Initialized, Approved, started and Closed.

For my chart I’m only interested where the [Project Status] = ‘Approved’.

So I thought it was a simple case of adding “if([Projects Status]= 'Approved',1,0)”  to the Calculation Condition.

But this only seems to work if first filter for “Approve using a list box etc., and then changing the properties to Detached, otherwise all I get is “Calculation condition unfulfilled”

What I want is for my Chart to only show Approved Projects without setting any filters.

[MK_QSL]

Use Calculated Dimension as below

If([Projects Status]= 'Approved',[Projects Status])

And tick suppress when value is null

[#3]

Thanks Manish but this just gives me every Option

[#4]

Did you tick the "Supress when value is null" as Manish mentioned? It should work.

If still doesn't work, you can attach the file for us to check.

[MK_QSL]

Count({<[Project Status] = {'Approved'}>}Activity)

===========================================================

For Calculated Dimension, you have more than one dimension, so use as below

IF([Project Status] = 'Approved', Dimension1)

IF([Project Status] = 'Approved', Dimension2)

IF([Project Status] = 'Approved', Dimension3)

Where Dimension1, Dimension2 and Dimension3 are the name of your fields...

Now you can use Count(Activity) or Count(Distinct Activity)

===========================================================

Or simply use

Dimension1

Dimension2

Dimension3

and The Expression I have provided at the top

[#6]

Hi sorry dont understand why this should be so complicated

Have enclosed the file

Thanks

Mark

[#7]

Please see attached. Hope this is what you are looking for.

[MK_QSL]

Create a Chart

Dimension

1)

use Calculated Dimension

=IF([Projects Status] = 'Approved', [PROJECT ID])

2) use Calculated Dimension

=IF([Projects Status] = 'Approved',[Projects Status])

Tick suppress when value is null for both of the above Calculated Dimennsion

Expression

Count([Activity ACTUAL START])

[MK_QSL]

Or

Create a Chart

Dimension

Project ID

Project Status

Expression

Count({<[Projects Status] = {'Approved'}>}[Activity ACTUAL START])

[Anonymous · Accepted solution]

you don't need calculated dimension for your issue...simply use [PROJECT ID] as dimension and update your expression to the following:

Count({<[Projects Status]={'Approved'}>} [Activity ACTUAL START])