[KNOX-2310] Add aggregate method to KnoxShellTable

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0
• Component/s: KnoxShell
• Assignee: Larry McCay
• Reporter: Larry McCay
• Created: 23/Mar/20 17:38
• Updated: 27/Mar/20 03:56
• Resolved: 27/Mar/20 03:56

Description

A simple method for producing a meaningful mathematical report of a dataset would allow the user to quickly determine some basic metrics of a dataset.

For instance, given a dataset with time series data across columns, an aggregation of:

• min
• max
• mean
• median
• mode
• sum

for specific columns would provide a way to visualize the changes across time.

knox:000> hopkinsC19.filter() name "Country/Region" equalTo "US" aggregate() columns "3/15/20, 3/16/20, 3/17/20, 3/18/20, 3/19/20, 3/20/20, 3/21/20" functions "min, max, mean, median, mode, sum" title "Confirmed COVID-19 US Cases over the last Week"
===> Confirmed COVID-19 US Cases over the last Week
+----------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          |       3/15/20        |       3/16/20        |       3/17/20        |       3/18/20        |       3/19/20        |       3/20/20        |       3/21/20        |
+----------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|   min    |         0.0          |         0.0          |         1.0          |         1.0          |         2.0          |         3.0          |         3.0          |
|   max    |        732.0         |        967.0         |        1706.0        |        2495.0        |        5365.0        |        8310.0        |       11710.0        |
|   mean   |  62.482142857142826  |  82.71428571428568   |  114.66071428571433  |  138.98214285714295  |  244.23214285714275  |  341.0714285714283   |  455.1607142857145   |
|  median  |         20.0         |         24.0         |         31.0         |         40.5         |         56.0         |         79.0         |        120.0         |
|   mode   |         1.0          |         1.0          |         3.0          |         18.0         |         44.0         |         14.0         |         15.0         |
|   sum    |        3499.0        |        4632.0        |        6421.0        |        7783.0        |       13677.0        |       19100.0        |       25489.0        |
+----------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

Issue Links

• links to: GitHub Pull Request #302