filtered display on Heatmap

sayadutt — Wed, 18 Jun 2014 15:32:08 GMT

Hi All,

I have created one heatmap which shows all the project details.

Now I need to display the heatmap only for those projects which has status as Open.

Note, there is a field which holds these project statuses - Open, Closed, Future etc.

I tried with below expression, but somehow its not giving me correct data.

if([Overall Project Status ]='Open', Count([Project Name ]))

Can you please help here.

Thanks

Re: filtered display on Heatmap

maxgro — Wed, 18 Jun 2014 18:33:13 GMT

if you have a Project dimension you can try to change in

if([Overall Project Status ]='Open', [Project Name])

and then check suppress when value is null

or post your heatmap

thanks