Report Recipe: Booth by Hall

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

Fields included:

• 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
   • Pavilion: In the Fields list on the left, search for Pavilion, and drag over the Booth>Pavilion option. Then click the Radial Dial for Pavilion, and select the Group Icon at the top of the dial to group the booths in each hall by their pavilion. 
   • 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.Hall from Group Headings
       • Value= Sum: Booth.Booth Size from Group Footers
     • By Status - First use the Booth Status variation listed above. 
       
       • First Label=Booth.Hall from Group Headers
       • Second Label=Booth.Status from Group Headers
       • Value=Sum:Booth.Booth Size from Group Footers. 
   • % of Booths in each hall - Choose the Visualization configuration on the right and then select a Pie Chart type. 
     • Count
       • Label=Booth.Hall from Group Headers
       • Value=Count:Booth.Booth Id from the Group Footers
     • Size
       
       • Label=Booth.Hall from Group Headers
       • Value=Sum:Booth.Booth Size from Group Footers.