You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@knox.apache.org by "Larry McCay (Jira)" <ji...@apache.org> on 2020/03/23 17:39:00 UTC
[jira] [Created] (KNOX-2310) Add aggregate method to KnoxShellTable
Larry McCay created KNOX-2310:
---------------------------------
Summary: Add aggregate method to KnoxShellTable
Key: KNOX-2310
URL: https://issues.apache.org/jira/browse/KNOX-2310
Project: Apache Knox
Issue Type: Improvement
Components: KnoxShell
Reporter: Larry McCay
Assignee: Larry McCay
Fix For: 1.4.0
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.
{code}
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 |
+----------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)