After you have created a search for the Analytics data that you want to visualize, you can configure a widget to display the results of the search graphically.

Access the Analytics Widget Builders

You can access the Analytics visualization widgets from the Analytics Search UI or directly from Dashboards & Reports.

To access the Analytics widget builder from Analytics:

  1. Select Analytics > Searches to view the saved searches list.
  2. Double-click the search that you want to visualize or add a new search.

To access the Analytics widget builder from a Custom Dashboard:

  1. From the top navigation bar, click Dashboards & Reports to see the custom dashboard list.
  2. Either double-click the dashboard where you want to add the Analytics widget or click Create Dashboard to create a new dashboard.
  3. In the custom dashboard, click Edit, then Add Widget.
  4. Click AnalyticsSaved Searches, or Experience Levels.
  5. Add Analytics widgets as needed to your dashboard.

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 Builder 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. 
    In this example, the percentile function is applied to HTTP Time (ms)
    Custom Widget Builder
    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 truefalsenull, 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.

Conversion Analysis Using Funnel Widget

Funnel analysis include a series of events that lead towards a defined goal. For example, tracking user activity in a mobile app, a sale on an eCommerce website, online advertisements, and eventual purchase.

The funnel widget visualizes use cases such as:

  • Retail application checkout drop-off rates from the point of adding items to the shopping cart to the actual purchase
  • Business Journey drop-off rates from the point of applying for a loan to approving the loan
  • Home mortgage loan approval drop-off rates from submitted application to approved applications
  • Impact from performance issues by total sales, customer segment, location, and purchased products are gauged in a funnel with other health rule widgets

In this custom dashboard, the impact from performance issues by total sales, customer segment, location, and purchased products are gauged in a funnel with other health rule widgets. 
Funnel Widget

Funnels return the number of unique actors that successfully (or unsuccessfully) make it through a series of steps. Actors could mean users, devices, or any other identifiers that are meaningful to you. A funnel analysis reveals where a given flow loses the most actors. This helps identify areas for improvement, as well as the overall health of your business.  

The first step in the funnel is the anchor step, and always represents 100% of the results. The filter criteria for the first step creates a set of unique values, and every subsequent step results in a subset of the values from the previous step and renders the corresponding drop-offs. The second and later steps describe the number of events that match the criteria for each step towards the goal. This number is typically less than 100%, but could be 100% if every event matches the subsequent steps. 

Build a Funnel Widget

  1. From the Analytics Search page using Drag and Drop (Basic) Mode, select the Visualization tab.
  2. Click Add Widget > Funnel Widget Builder.
    Funnel Widget Builder
  3. In the Funnel Definition pane, click the down arrow to select the unique field representing the items that you are counting. In this example, following the steps of a loan approval process, LoanId is used. The fields depend on your application. There is a limit of 50,000 unique values for the first step. If you encounter this limit, you can try decreasing the global time range and look at fewer values at a time.
    Funnel Definition

    Filtering on fields with null and empty values may cause more records in subsequent levels.

  4. Label the first step and continue to add steps as needed for your application process.
    Add Funnel Step
    For this example, the first step represents the number of submitted loan applications. The search criteria include the AD-Capital application and the /portal/SubmitApplication business transaction.
    Funnel Search Criteria
    Alternatively, you can set SubmitApps.milestoneReached to true.
    Criteria Values
  5. Continue to add and label your steps. This step represents the number of loan applications that reached the stage "Documents Verified." 
    Criteria Steps
    Alternatively, use the milestoneReached field and set it to true.
  6. After you have added all the necessary steps, click Add & Close Widget Builder to save the completed funnel widget. This example contains two additional steps representing loans that reached the credit check and approval stages.

    If you want to cancel editing and revert to the previous version, click Close Widget Builder.
    Close Widget Builder
    If the funnel steps need a rearrangement you can simply reorder them by simply dragging and dropping each step into appropriate positions. 
  7. Once you finish building your funnel, remember to name and save your search result. 
    Save Search
  8. To add the finished funnel widget to a custom dashboard, click Actions > Add to Dashboard.
    Add to Dashboard

Use the Funnel to Troubleshoot 

The finished funnel widget for the above example shows the drop-offs (Abandoners) in unique loan IDs from submission to approval. When creating the funnel, you can also select Show Health in the properties pane to display a health overlay that correlates application health data with the business conversion data. This helps to visualize performance for each step of the funnel widget.

Funnel Widget

The health overlay is supported for these events types with a user experience value:

  • Transaction Events – userExperience
  • Browser Records – pageexperience
  • Mobile Snapshots (Network Requests) – networkrequestexperience
  • Web Session Records (Browser Sessions) – experience
  • Mobile Session – networkrequest.networkrequestexperience

For enhanced troubleshooting, you can drill down to event data from any of the funnel steps by double-clicking the numbers on conversions and abandoners or by using Health Overlay and clicking on each health segment.

Configure Custom Widgets

To configure custom widgets for your analytics searches:

  1. From the Analytics Search page using Drag and Drop Search (Basic) Mode, select the Visualization tab.
  2. Click Add Widget > Custom Widget Builder.
    Custom Widget Builder
  3. To add a field to a widget, drag the field from the Fields panel on the left to the Y-axis or X-axis on the right. The available fields are based on the fields returned by the search.
    Fields Widget
  4. From the Chart Types panel on the right, click the widget type to use for the display. The widget is previewed in the main panel. You can experiment previewing which widget type is best for visualizing a particular data set.
    Widget Types
    • Usage for the X and Y axes depends on the chart type. The UI prevents you from adding more fields than the widget supports. Different widgets have different limits for the maximum number of fields permitted on each axis.
    • For the time series widgets (area, line, scatter, and histogram), you can use the Resolution field that appears on the X-axis to customize the frequency displayed if you do not want the widget to automatically select a default resolution based on the current time range. This time resolution field is not counted toward the field limit. The granularity of resolutions that can be chosen depends on the Global time range.

Custom Widget Builder Data Type and Field Restrictions

Widget Type

Data Type

Number of Fields on Y-axis

Number of Fields on X-axis

Column (simple)

any

zero

up to two

one

up to two

two or three

zero or one

Pieanyoneup to two
Tableanyoneup to ten
Tree Mapanyoneup to two

Time Series (Area, Line, Points, Column)

any

zero

one

one

one

two or three

zero

Percentile Histogram
(Not available in Advanced Mode)

numericzeroone
Numeric (Univariate)anyonezero

Upgraded Funnel

Contact your administrator for access to the upgraded funnel experience.