topic Re: Considering Max value based on Period in App Development

Considering Max value based on Period

bhargavikn — Fri, 15 Nov 2024 21:34:13 GMT

Hi,

we have below table have Value for currency for different periods.

Need to show the max value if we are working Month wise, and also if we are showing the data for Quarter wise it should show max value for Quarter.

Can you please suggest me on this.

Thank you.

Or — Tue, 18 Jul 2023 10:48:54 GMT

Seems like you should be using Max(Value) with a dimension of month or quarter as appropriate?

bhargavikn — Wed, 19 Jul 2023 09:31:46 GMT

Hi, Thank you for reply.

Yes, I have used Max(value) using group by month, Quarter.

with this approach it is showing max value only for Month,

but for Quarter it is showing max values of each 3 month values.

I need to have only one max value for Quarter selection.

Please suggest me.

BrunPierre — Wed, 19 Jul 2023 11:25:57 GMT

=Only({$<Value= {"$(=Max(Value))"}>}Value)

bhargavikn — Wed, 02 Aug 2023 09:27:05 GMT

Thank you all for your reply.

I have tried with below kind of script and it working.

T1:

Load

Max(Month) as Month, Quarter, Currency

Group by

Quarter, Currency ;

Left Join(T1)

Load Currency, Quarter, Value;