How to create a pie chart that shows number of requests by status?
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".
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.
Choose Edit -> Series -> Customizations and you could change the colors of the pie chart.
Updated on: 16/05/2023