Project

General

Profile

Actions

Feature #7727

open

Pivot table visualization

Added by Pavel Kácha 2 months ago. Updated about 2 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Development - Core
Target version:
Start date:
04/10/2024
Due date:
% Done:

0%

Estimated time:
To be discussed:
No

Description

Both analysts and managers would benefit from being able to calculate pivot tables (tables showing calculated values for all relations between two atrributes).

Examples:

  • Give me the number of events for all the combinations of abuse groups and categories.
  • Give me the number of the portscan connections for combinations of ports and days in last month.

So, in the first case, rows would be the abuse groups, columns would be the categories, cells would contain the numbers of the events bearing both the row's abuse group and column's category.

In the second case, query would be run on dataset filtered by category (portscan), rows would be the ports, columns would be days/dates, cells would contain the connection sums for particular port and day.

Table could be even heatmapped (for example by color coded value backgrounds).

(Most of this should most probably be computable on db, similar to Timeline.)

Actions

Also available in: Atom PDF