I want to display the number of tickets that I have with 2 different statuses:
1-Open
2-Closed
Now, I have created 2 different measures like this:
=Count([Ticket ID]) Where ([Ticket Status]="Closed") and
=Count([Ticket ID]) Where ([Ticket Status]="Open")
and the dimension will be the ticket status. However, the chart does not work with the above logic.
Can someone please help me on this? I want to have something like the attached picture.
Thanks,