MAX(AGGR(COUNT(Expression),Dimension)) is not working properly

julioarriaga — Sat, 16 Nov 2024 05:38:20 GMT

Hi,

I'm losing my mind over this issue. The expression MAX(AGGR(COUNT(Operation_Idnum),Daynum)) is not working in a simple inline table as it is bringing me nulls in one of the dimensiones (that's not correct according to the data) and I'm losing my sanity searching for the reason.

I am really grateful for the help in advance. Kind regards.

I attach the qvf file wih the object and the issue.

The expression is MAX(AGGR(COUNT(Operation_Idnum),Daynum)), the dimension is OrderType.

The inline table is:

Test:
LOAD * Inline [OrderType,Daynum,Operation_Idnum
B,1,8923,Oct
B,1,8924,Oct
B,1,8925,Oct
B,2,8926,Oct
B,2,8927,Oct
A,1,8928,Oct
A,1,8929,Oct
A,2,8930,Oct
A,2,8931,Oct
A,2,8932,Oct
B,1,8933,Nov
B,1,8934,Nov
B,1,8935,Nov
B,2,8936,Nov
B,2,8937,Nov
A,1,8938,Nov
A,1,8939,Nov
A,2,8940,Nov
A,2,8941,Nov
A,2,8942,Nov
];

Re: MAX(AGGR(COUNT(Expression),Dimension)) is not working properly

lironbaram — Mon, 10 Jun 2019 05:08:15 GMT

when using aggr function the function disregards the dimensions of the table

so if you want to include the order type in the results you need to change the function to

MAX(AGGR(COUNT(Operation_Idnum),Daynum,Order_Type))

or if you want to get the same result to all order type change to this one

MAX(AGGR(nodistinct COUNT(Operation_Idnum),Daynum))

topic MAX(AGGR(COUNT(Expression),Dimension)) is not working properly in App Development

MAX(AGGR(COUNT(Expression),Dimension)) is not working properly

Re: MAX(AGGR(COUNT(Expression),Dimension)) is not working properly