Skip to main content

Grid

Concept​

The Grid is a dynamic and customizable grid listing all communications matching your filters.

You may:

  • Select the data to show
  • Resize columns to see better
  • Reorder columns
  • Filter & sort on data
  • Open unitary communications
  • Select and add coms throughout your searches (as a shopping basket)
  • Compare two or more coms
  • Export selected coms in Excel or JSON

The grid uses infinite scroll for pagination

  • Use filtering rather than scrolling down ;-)

Layout​

Grid.png

Columns selection and ordering​

Columns.png

The Select columns icon opens the columns selection popin.

You may:

  • Search for a column
  • Select what columns to display
    • A tooltip explains what is the data displayed for almost each column
  • Reorder columns by dragging them up or down in the list
note

Some columns may be disabled:

  • They are displaying extracted tag values, count or cardinality
  • But those tags are not extracted on all Whisperers
  • If you have selected such a column to display before, it will appear in your list, but disabled on Whisperers not extracting this tag
  • This avoids messy behaviors when reordering columns

ColumnsDragDrop.png

Color scale on numeric columns​

Any numeric column — duration, size, row count, error count — can render a background color scale. The cell color is proportional to the column's value range: the highest value gets the darkest shade, zero gets none.

This turns a plain table into a heat map with no configuration. Outliers jump out without sorting or filtering first.

ColorScale.png

Selecting records​

In the grid, yuu may select records in order to:

  • Compare records
  • Export records to Excel

Records selection is independent of search or view changes:

  1. Search
  2. Browse for records
  3. Select them
  4. Search again
  5. Find other records
  6. Select them
  7. Click to see only selected items
  8. And then view, compare or export them

Filters​

The list offers easy access to filters in the header.
Those filters are exactly the same as elsewhere in Spider. Only faster to access.

  1. The filter icon appear when moving the mouse over the header.
  2. On click, a popin shows the values list or the distribution histogram.

Items filter​

SelectFilter.png

Range filter​

RangeFilter.png

Records export​

Export formats​

Export.png

You may export the selection in two formats:

  • Download in JSON - Complete content in JSON format

    • Useful to import it back in an upload Whisperer later or in another platform
    • Used by integration teams to save integration campaigns
    • See OpenAPI format description

  • Excel - Only visible data columns

    • Useful to export in a report

How to​

  1. Select all lines to export
  2. Click the export button
  3. The file is generated in your browser and triggered for download

Excel content​

Excel export includes a header sheet and the data sheet.

  • Time selection
  • Selected Whisperers
  • Current view
  • Current filters
  • Total items matching the filters
  • Count of exported items

ExcelHeaders.png

Excel export is meant to be usable straight: all formatting is done for you

  • Autofilter is on
  • Dates are exported as Excel dates and formatted as in UI
  • Numbers are exported as numbers, but displayed with specific formats

ExcelContent.png