50 STEPS
1. This tutorial will show you how to search for sites in the database. It will also demonstrate features of the interactive menu.
To get started, click on the arrow next to Settings in the menu to expand the dropdown.
2. Click Sites
3. Note the Sites page is only showing the list of Sites that your account is currently referencing in your Competitions and Schedules.
In this example, we will focus on Sites in Michigan.
4. You can sort, search, and filter from any of the columns in the report or set more complex filters from the Actions button.
5. If a Site is "also known as" a different name, it will be listed in the Also Known As column.
6. To do a general Search across all rows and columns, type in your search term in the top search field and hit the Enter key on your keyboard or click Go next to the search bar.
7. To see the verified Fields associated with a Site, click the magnifying glass next to your chosen Site.
8. A list of verified Field Names and a Description for these Fields is displayed on the right side of the page.
9. Click Cancel to return to the Sites page
10. You can check if your site has been entered into the master database.
To see all sites in the master database, click All Sites.
11. Let's review some of the sort, search, and filter options that are available using the interactive menus.
In this example, let's start by filtering the State. Click on the column heading.
12. You can either scroll down the list or Click inside this Search bar to type in your search term.
13. In this example, we will search for Sites in the State of Michigan
14. Note the filter that now appears at the top of the report, indicating we have a State filter for Michigan applied.
Temporarily remove this filter by unchecking the box on the left or remove the filter entirely by clicking the x on the right.
15. If you want to filter for multiple items, use the more advanced Filter function within the Actions area.
Click Actions to expand the dropdown
16. Click Filter
17. Click the dropdown under Column to change the column you will use for your filter.
18. Click State
19. Click Operator to choose how you want the filter to operate.
20. In this example, we want our report to show Michigan or Ohio.
The platform uses the in operator as the equivalent of or
Click in
21. Click the arrow below Expression to show the dropdown list of the Column, in this case, "States".
22. Click Michigan
23. Scroll down and Click Ohio
24. Your choices will be listed in the Expression box, separated by commas.
Click Apply when you have added all your choices.
25. Sites in both Michigan and Ohio are now displayed. Note the filter at the top of the report indicates the States we have chosen in the previous step.
26. Let's focus again on Michigan and add another filter for City.
27. Repeat the same steps as described earlier to look for sites in a specific City.
In this example we will search for Sites in Detroit.
28. Note the filter for Detroit is shown above the report.
29. If you would like to alphabetically sort columns with string variables from A-Z, click on the column heading at the top of the report, then click the up arrow to Sort Ascending.
In this example, we will sort the Site Name alphabetically.
30. In this example, we are sorting the cities from A-Z within Michigan.
31. If you would like to see what Sites are listed for each city in one view, use the Control Break function.
To apply a Control Break, click the Actions button.
32. Click the arrow next to Format, then click Control Break.
33. Click Column 1 to expand the dropdown and display your columns.
34. Click City
35. Click Apply when finished.
36. Your report now shows each City and the Sites within that City.
You can do additional searches and filters from the Control Break report, either from the search bar to look across the report, or from a specific column.
37. For example, you can search by various zip codes or parts of Zip Codes.
Click the column Zip to search and filter Zip Codes.
38. Type what you want to search for in the Filter bar and hit Enter on your keyboard.
39. In this example, we are searching for Sites that have 4 9 3 in the Zip code.
40. Sites are now displayed with this Zip filter.
Click the X to Remove the Filter when finished.
41. If you set up a display you will use often, you can Save it as a Report.
To save your settings as a report, click Actions
42. Click Report then Save Report
43. Type in the Name of your Report and Click Apply
44. We named our report "Sites by City". Click the Reports toggle between the primary default report and your saved reports.
45. Click 1. Primary Report to see the default settings of the All Sites page.
46. Click Reports to see a dropdown list of your saved reports.
47. Click 1. Sites by City to see the saved report we created earlier.
You can save as many reports as you like and they are private to you.
48. The report you choose will display here, along with its settings.
49. The interactive menu can be used in this way in many other areas of the platform.
If you need a Site added to the master database, contact your account administrator.
50. Thank you for watching the tutorial on how to view Sites and Fields referenced in your account and across All Sites in the platform.
