Report Recipe: Booth by Pavilion

Purpose of Report: See the Booth Inventory list by the Pavilion that each booth has been assocuated with on the floor plan. 

Fields included:

• Pavilion
• Booth Id
• Event Name
• Booth Label
• Booth Size
• Booth Type
• Company Name
• Date Assigned
• Booth Status

Variations:

1. Sub Group by:
   • Booth Status: click the Radial Dial for Booth Status, and then select the Group Icon at the top of the dial to group the booths in each hall by their status (Occupied, Reserved, Available
   • Hall: In the Fields list on the left, search for Hall, and drag over the Booth>Hall option. Then click the Radial Dial for Hall, and select the Group Icon at the top of the dial to group the booths in each hall by their hall
   • SubExpo: In the Fields list on the left, search for SubExpo, and drag over the Booth>SubExpo option. Then click the Radial Dial for SubExpo, and select the Group Icon at the top of the dial to group the booths in each hall by their SubExpo. 
2. Add a Visualization
   • Booth Size Compare - Choose the Visualization configuration on the right, and then select a Bar chart type.  
     • Over all 
       • Label=Booth.Pavilion from Group Headings
       • Value= Sum: Booth.Booth Size from Group Footers
     • By Status - First use the Booth Status variation listed above. 
       
       • First Label=Booth.Pavilion from Group Headers
       • Second Label=Booth.Status from Group Headers
       • Value=Sum:Booth.Booth Size from Group Footers. 
   • % of Booths in each pavilion - Choose the Visualization configuration on the right and then select a Pie Chart type. 
     • Count
       • Label=Booth.Pavilion from Group Headers
       • Value=Count:Booth.Booth Id from the Group Footers
     • Size
       
       • Label=Booth.Pavilion from Group Headers
       • Value=Sum:Booth.Booth Size from Group Footers.