Create dataviews

You can create custom dataviews to join and filter data in ArcGIS Monitor and use them to power indicators and charts in analysis views.

To create a dataview, complete the following steps:

1. Access Monitor if necessary.

   The Home page appears.

2. Click Analysis.

   The Analysis page appears with a list of analysis views.

3. Click the Dataviews tab.

   The Dataviews page appears with a list of dataviews.

4. Click Create dataview.

   The Create dataview dialog box appears.

5. Provide a name for the dataview in the Name text box.
6. Optionally, provide a description for the dataview in the Description text box.
7. Click Create dataview.

   The dataview is created and appears in the list.

8. Click the name of the dataview.

   The dataview's Overview page appears.

9. Click Edit.

   The expression builder switches to edit mode.

10. Use the expression builder to build a data query.

    For example, to build an expression that contains the number of open critical alerts for all components with a Production label, do the following:

    1. Click Resource, and choose Alerts.
    2. Next to Alerts, click Where.

       The where clause appears under Alerts.

    3. Click the Select a field drop-down arrow, and choose Status.
    4. Leave the operator set to is.
    5. Click the Select drop-down arrow, and choose Critical.

       Tip:

       To use a custom value, click Source type: Choose value , click Enter value, and provide a value.

    6. Under Alerts, click Rule.

       The clause appears under Alerts.

    7. Click the Select a field drop-down arrow, and choose Closed at.
    8. Click the operator drop-down arrow, and change it from is on to never.
    9. Next to Alerts, click Having, and click Labels.

       The Having clause appears under Alerts.

    10. Next to Labels, click Where.

        The clause appears under Labels.

    11. Click the Select a field drop-down arrow, and choose Name.
    12. Leave the operator set to is.
    13. Click Source type: Choose value , click Enter value, and type Production in the text box.
11. Optionally, click Test, and click the Results tab to view data that matches the dataview expression.
12. Click Save when you finish creating the dataview.

    The dataview is saved and can be used in analysis view elements.