topic Re: Count the first occurrences using set analysis in App Development

Count the first occurrences using set analysis

Micki — Sat, 16 Nov 2024 01:18:52 GMT

Hi folks, have a table

My measure:

count( aggr( if( {< [State] ={'Closed', 'Resolved'}, >} FirstSortedValue([Id], -[Week]), 1,0), [Id]))

And it's not working what i want to count 1 in 21-Sep-2020 and that it, Could you please help ?

thank you in advance

Vegar — Mon, 12 Oct 2020 11:10:40 GMT

Your SET modifier is misplaced outside of the aggregation function.

Try it like this.

count( aggr( if( FirstSortedValue({< [State] ={'Closed', 'Resolved'}, >} [Id], -[Week]), 1,0), [Id]))

Micki — Mon, 12 Oct 2020 11:28:12 GMT

not working:(

sunny_talwar — Mon, 12 Oct 2020 11:40:09 GMT

@Micki May be try this

Sum(Aggr( If(Week = Min({<State = {'Closed', 'Resolved'}>}TOTAL <Id> Week), 1, 0) , Id, Week))

Micki — Mon, 12 Oct 2020 11:49:37 GMT

@sunny_talwar Thank you so much!!!