Build a Widget

To use the Analytics widget builder:

  1. Click the Visualization tab.
  2. In the Visualization canvas, you can create widgets with one of the following modes:
    • In Drag and Drop Search (Basic) mode you can create multiple widgets on the canvas.
    • In Query Language Search (Advanced) mode you can generate one widget from your ADQL query at a time. In addition, when you use the Visualization tab in this mode, the order of functions and fields in the query matters. For all widgets (except table), the aggregate functions, such as count(*), avg(), sum(), percentile and so on, should always be preceded by a field. If the fields and functions in the query are not in this order, some visualizations do not work.
    See Conversion Analysis for an example of creating a conversion analysis using the funnel widget.
  3. Click Add Widget, then select Custom Widget Builder or Funnel Widget Builde r depending on the type of widget that you want to create.In Basic mode, you can build custom widgets and drag fields to the canvas, which uses X and Y axes for configuration. After dragging a field to the axes, select a function from the drop-down next to the field name. The funnel widget is configured differently from the other custom widgets, which use the Y and X axes as the basis of the configuration. A funnel widget is used to display data of progressively-staged proportions in a color-coded funnel. You can add a title to the widget by over-writing Widget Title on the canvas.
  4. After adding a widget and fields, you can right-click menu widget values to see other options. Select Apply a global filter for <field_value>to add a value to the existing search criteria.The supported boolean operators are true, false, null, and is not null. Use is not null to check both boolean and non-boolean fields, such as loan amount or IsReached .
  5. Click Save & Close to save the widget configuration.