topic Re: Max of count for each month in App Development

Max of count for each month

BI_Dev — Fri, 28 Feb 2025 18:49:52 GMT

Month	Weekday	# Distinct COUNT	Max OUTPUT
Dec 2024	Tue	982	982
Dec 2024	Tue	968
Nov 2024	Wed	931	931
Nov 2024	Tue	888
Oct 2024	Tue	915	915
Oct 2024	Tue	894

I need the max output in the chart by Month and I have the below expression

max(aggr(count(distinct [ID]),[Month])) and it is not working

Re: Max of count for each month

rubenmarin — Sat, 01 Mar 2025 07:07:25 GMT

Hi, you can use: Max(TOTAL <Month> [# Distinct COUNT])

Or, if you want to show the values only on the max value row: If(Max(TOTAL <Month> [# Distinct COUNT])=[# Distinct COUNT],Max(TOTAL <Month> [# Distinct COUNT]))

Re: Max of count for each month

PrashantSangle — Sat, 01 Mar 2025 09:43:33 GMT

If you want to do same in script then use Window ()

Load *, Window(Count(ID),Month) as max_month_count

Re: Max of count for each month

Chanty4u — Sat, 01 Mar 2025 14:45:18 GMT

Try this

Max(Aggr(Count(Distinct [ID]), [Month], [Weekday]))

Re: Max of count for each month

BI_Dev — Mon, 03 Mar 2025 00:57:18 GMT

@Chanty4u @rubenmarin @PrashantSangle That did not work - expressions gave the below result -

Max number of sales is 982.

Now I want to show Max # of sales for each month - her for Dec 982 and Nov 931.

Expression for Mac overall is

max(total aggr(count(distinct [ID]),[Date]))

Re: Max of count for each month

poklegoguy — Mon, 03 Mar 2025 03:29:55 GMT

Try this:

IF(AGGR(count(distinct [ID]),Month,Weekday) = MAX(TOTAL <Month> AGGR(count(distinct [ID]),Month,Weekday)), count(distinct [ID]))

Re: Max of count for each month

PrashantSangle — Mon, 03 Mar 2025 04:49:13 GMT

using @rubenmarin solution

max(total<Month> aggr(count(distinct [ID]),[Date])).

Regards,

Prashant Sangle

Re: Max of count for each month

BI_Dev — Mon, 03 Mar 2025 15:09:29 GMT

@PrashantSangle - Thank you. That worked.