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
Add comment