When a device name is changed, will need to update the Camera Zone Report

Step 1

Zone Name Dropdown: (Note: This pulls zone names for the past 2 years)

1. FORK: https://redash.sitemetric.com/queries/2553/source?p_Date=d_now
2. Change site_id
3. Change Query Name
4. Tag site_id

(Original from Turner https://redash.sitemetric.com/queries/2120/source)

Step 2

Zones (page 1):

1. FORK: https://redash.sitemetric.com/queries/2554/source?p_Date=d_now&p_Timeframe=d_this_week#4517
2. Change site_id
3. Tag site_id

(Original from Turner IAD 11 https://redash.sitemetric.com/queries/2118/source?p_Date=d_now#3779)

Step 3

Zone Times (page 2):

1. FORK: https://redash.sitemetric.com/queries/2555/source?p_Date=d_now&p_Zone=Gate-1#4530
2. Change site_id
3. Change Zone Query Based Dropdown List to “Zone Name Dropdown” (below)
4. Change Query Name
5. Tag site_id

(Original from Turner IAD 11 https://redash.sitemetric.com/queries/2119/source?p_Date=d_now&p_zone_group=Auxiliary Camera#3780)

Step 7

Create Dashboards with Queries from Steps 2, 3

1. Tag with Site_id
2. Allow Public Access
3. Publish

Step 8

1. Change Zone Headcount 1 Query Link to Zone Headcount 2 Dashboard number
2. And include random characters from secure link
3. Change Zone Headcount 2 Query Link to Zone Headcount 3 Dashboard number
4. And include random characters from secure link
5. Change Zone Headcount 3 Query Link to Zone Headcount4 Dashboard number
6. And include random characters from secure link

Hours Dropdown:

1. Nothing to do here, just in case ever need to type hours

https://redash.sitemetric.com/queries/2124/source

DISTINCT CASE
    WHEN location ILIKE '%no.1-cantina-bathrooms-SAP%' THEN 'Cantina Bathrooms'
    WHEN location ILIKE '%no.18-cantina-bathrooms-OP%' THEN 'Cantina Bathrooms'
    WHEN location ILIKE '%no.3-West-bathrooms-SAP%' THEN 'West Bathrooms'
    WHEN location ILIKE '%no.20-west-bathrooms-OP%' THEN 'West Bathrooms'
    WHEN location ILIKE '%no.10-East-bathrooms-SAP%' THEN 'East Bathrooms'
    WHEN location ILIKE '%no.19-East-bathrooms-OP%' THEN 'East Bathrooms'
    WHEN location ILIKE '%no.13-Trailer-City-Camera-Stand-SAP%' THEN 'Turner & Sub Trailers'
    WHEN location ILIKE '%no.22-Trailer-City-Camera-Stand-OP%' THEN 'Turner & Sub Trailers'
    WHEN location ILIKE '%no.21-auxiliary-camera-stand-OP%' THEN 'Auxiliary Camera'
    WHEN location ILIKE '%no.12-Auxiliary-Camera-Stand-SAP%' THEN 'Auxiliary Camera'
    WHEN location ILIKE '%Gate-B%' THEN 'Gate B Bathrooms'
    ELSE ' '
  END AS zone_group

--
WHERE
(zone_group = 'Cantina Bathrooms'
OR zone_group = 'West Bathrooms'
OR zone_group = 'East Bathrooms'
OR zone_group = 'Turner & Sub Trailers'
OR zone_group = 'Auxiliary Camera'
OR zone_group = 'Gate B Bathrooms')