How to create a single value card that shows the number of resolved requests?
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.
Choose "Num of Requests" in the Request view.
Click on "Add" next to Custom Fields and choose "Custom Measure". Create a custom measure that calculates the number of resolved requests in the room as shown below:
Run the report.
In the Visualization Pane, choose "Single Value" as the visualization type. Choose Edit -> Value Labels -> choose "Calculate Progress (with Percentage)".
Updated on: 25/06/2023