filtered display on Heatmap

[sayadutt]

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

[maxgro · Accepted solution]

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