Display Different Statuses

In this scenario, the Table widget counts events for the different HTTP methods, which have registered HTTP status errors, like this:

Count by Status

Figure 221. Count by Status


  1. From the Search tab, type this query in the Query Editor:

    logscale
    groupBy([method, status])

    A table is created that has fields method, status and _count as its columns.

  2. Save your widget as explained at Create Widgets

  3. Click the menu icon on top-right of the widget and select Styling, the Styling panel is displayed:

    Properties Panel - Example 1

    Figure 222. Properties Panel - Example 1


  4. Click the field method in the Columns section and set these properties:

    • Formatting → Show as Go to events link: creates links to the Event List for each entry in method , to show the corresponding result (in the example, all results for query * | method=DELETE will be displayed).

    • SizeFit to data

    • Cell colorsStatic.

  5. Click the field status in the Columns section and set these properties:

    Cell colorsCondition+Add condition → color red if the value in the field status contains 04

  6. Click the field _count in the Columns section and set these properties:

    Cell colorsThresholds→ choose a color palette → +Add threshold : different nuances in the palette (light green, dark green, etc.) will highlight the different thresholds (below 1,000, above 100,000, etc.).

For more information on the available properties that you can use to customize your widget, see Table Property Reference.