on 03-16-2017 5:06 PM
dear all
i am trying to sum a few records, then perform a minimum on the sum, and it just wont work.
here is my table of data
Instance Host Epoch Day FP
BP5 a 1 2016-02-03 11
BP5 b 1 2016-02-03 86
BP5 c 1 2016-02-03 69
BP5 a 2 2016-02-03 42
BP5 b 2 2016-02-03 55
BP5 c 2 2016-02-03 33
BP5 a 3 2016-02-03 78
BP5 b 3 2016-02-03 24
BP5 c 3 2016-02-03 97
as you can see, they are split into Hosts are split with Epoch.
Instance and Day are just here in the example.
Epoch 1 sums as 166, Epoch 2 sums as 130, and Epoch 3 sums as 199 as below
2016-02-03 1 BP5 166
2016-02-03 2 BP5 130
2016-02-03 3 BP5 199
next i want to get the minimum which is record 2, ending in 130
something like this
2016-02-03 BP5 130
and most of all, i wish to do it in a Calculation view (or two), but i just cannot get the aggregation, node types, or whatever, right, and does not return 130.
this can be done using an hdbtablefunction, i know, but surely a graphical calculation view should be able to do this
any help or pointers would be great.
thanks in advanced
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.