topic Re: Nested Aggregations in App Development

Nested Aggregations

bradley_isaacs — Sat, 16 Nov 2024 17:29:14 GMT

Good day

I need some help with a possible nested aggregation.

I have the following :

1) One measure which has an aggregate function(lets call it A)

2) Another measure with a normal aggregation (lets call it B)

I want to count (in another measure), how many values in A is greater than the value in B. See picture below

Re: Nested Aggregations

Lauri — Tue, 16 Feb 2021 21:24:32 GMT

It would be helpful to see your two functions...

Re: Nested Aggregations

MayilVahanan — Wed, 17 Feb 2021 04:07:28 GMT

Hi @bradley_isaacs

You can use

If(Column(1) > Column(2), 1, 0)

And make total function as "Sum"

Re: Nested Aggregations

bradley_isaacs — Wed, 17 Feb 2021 09:26:12 GMT

Thanks for Reply Lauri

SUM(Aggr(SUM({$<[KPI Class ID] = {5}>} [KPI Value]) * SUM({$<[KPI Class ID] = {9}>} [KPI Value]), [%KEY_SHIFT] ))
/
sum( {$<[KPI Type ID] = {5}, [KPI Type]=>}[KPI Value])

B: IF(iSNULL((Avg({<Config_Description={'SV', 'TA'}>}TARGET_VALUE))), Round($(vTA_Target), 0.01),
Round((Avg({<Config_Description={'SV', 'Technical Availability'}>}TARGET_VALUE) ), 0.01)
)