topic Re: Document status (Count function) in App Development

Document status (Count function)

danimarc12 — Fri, 15 Nov 2024 23:30:09 GMT

Hello everyone!

I have an issue with a Count() expression.

In this image you can see a Document which has different status. Basically I want to count how many documents are in status idstep=80 but if I write Count( {< idstep={80} >} numpratica) it will display all the documents that had this status ("numpratica" is the ID of the document).

I think I have to add also the condition UltimaModifica={$=(Max(UltimaModifica))} but it doesn't work.

Maybe that's not correct as well.

Could anyone help me please?

Thank you all!

Re: Document status (Count function)

stevejoyce — Fri, 19 Nov 2021 13:14:49 GMT

Do you want the max/last UltimaModifica for each numpratica? or the max/last UltimaModifica for the entire data set?

I don't 100% follow with the language difference...

if it's max value for entire set:

= Count( {< idstep={80}, UltimaModifica={"$(=date(Max(UltimaModifica)))"} >} numpratica)

if it's for each numpratica, it's:

=Count(aggr(if(date(Max(total<nupmractica> UltimaModifica))) = UltimaModifica, numpratica), numpratica, UltimaModifica))

Re: Document status (Count function)

danimarc12 — Fri, 19 Nov 2021 13:16:36 GMT

I want to count how many numpratica are in the status "80". I have 1.200 numpratica in different status. I want to know how many of theese are in that status.

Re: Document status (Count function)

stevejoyce — Fri, 19 Nov 2021 13:21:00 GMT

Ok, try this.

=sum(aggr(if(date(Max(total<nupmractica> UltimaModifica))) = UltimaModifica, count( {< idstep={80} >} 1)), numpratica, UltimaModifica))

Re: Document status (Count function)

danimarc12 — Fri, 19 Nov 2021 14:05:56 GMT

it's not correct 😞

Re: Document status (Count function)

danimarc12 — Fri, 19 Nov 2021 14:34:13 GMT

Hi must see "2" in my KPI Verifica Preventivo".

In the straight table I've used "FirstSortedValue" function to show "Ultimo Step".

=FirstSortedValue(NomeStep, -UltimaModifica)