not activate a bar in the chart

[Anonymous]

In Sheet 4 there is a ''Assignee status'' chart i f i click on ''Assigned ticket'' bar below ticket details table showing Assigned tickets but when i click on ''Not Assigned'' ticket bar, it is not activating and not showing any data in ticket details table..

please look at attached dashboard and replay back

Thanq,

Devendar

[JonnyPoole]

its because the dimension is a calculated dimension that checks if assignee is null or not... and you can't generate a selection on NULL assignees because if you just look at assignees there are no null values.

BUT... if you look at incidents AND assignees then you can have incidents with a null assignee value ..

So change the calculated dimension expression in the chart to reference incident as well. Something like this will work:

=IF(IsNull(Assignee) and not isnull(Incident_Number),'Not Assigned','Assigned')