showing two bars with one dimension and two expressions

[Anonymous]

In Sheet 4 there is a Assignee status bar chart it is showing one bar (tickets not assigned) so i want to show one more bar for (tickets assigned ) so please look at below dashboard and give a response..

Thank you,

Devendar

[robert_mika]

Add Calculated Dimension

=IF(IsNull(Assignee),'Not Assigned','Assigned')

The Expression:

=COUNT(DISTINCT(Incident_Number))

[Gysbert_Wassenaar]

See attached example.

[Anonymous]

It is fine but if i select 'Not Assigned ' Bar below ticket details table not showing 'Not Assigned ' Tickets ...

[Anonymous]

It is fine but if i select 'Not Assigned ' Bar below ticket details table not showing 'Not Assigned ' Tickets ..