Skip to Content
0
Jun 28, 2019 at 04:50 PM

Having a pie chart with 2 measures and one dimension

179 Views Last edit Jun 28, 2019 at 05:07 PM 2 rev

pie.jpgHi,

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,

Attachments

pie.jpg (14.9 kB)