How to create a pie chart that shows number of requests by status?
Visualization:
![](https://storage.crisp.chat/users/helpdesk/website/27f699bfcd0cb800/image_2necxa.png)
Steps:
Choose "Room Requests" explore.
Add "Deal Title" under the the "Deal" view as a filter by clicking on the filter icon next to the field and choose a room/deal you would like to check. Add "Name" under the "Request Status" view as a filter too and choose "Status Name is not null".
![](https://storage.crisp.chat/users/helpdesk/website/27f699bfcd0cb800/image_mutzgg.png)
Under the view "Request", choose "Num of Requests" field. Under the view "Request Status", choose "Name".
Run the report.
In the Visualization Pane, choose Pie Chart as the visualization type.
![](https://storage.crisp.chat/users/helpdesk/website/27f699bfcd0cb800/image_bmhg4a.png)
Choose Edit -> Series -> Customizations and you could change the colors of the pie chart.
![](https://storage.crisp.chat/users/helpdesk/website/27f699bfcd0cb800/image_7ngccd.png)
Updated on: 16/05/2023
Thank you!