topic Re: Calc Last and First data in App Development

Calc Last and First data

spividori — Tue, 06 Sep 2022 23:55:16 GMT

Hi.

I have the following table and I need to calculate the last "Peso" - the first "Peso" of each IdAnimal in a KPI. This has to be dynamic. In the first example I have selected the years 2021 and 2022 and in the second example I only have the year 2021 selected.

Regards.

Re: Calc Last and First data

sidhiq91 — Wed, 07 Sep 2022 02:16:04 GMT

@spividori Please look at the Script used in the back end. Have a look at it and let me know if this something that you are looking for:

NoConcatenate
Temp:
Load IdAnimal,
Date(Date#(Date,'DD/MM/YYYY'),'MM/DD/YYYY') as Date,
Peso
Inline [
IdAnimal, Date, Peso
30695,13/05/2021,500
30695,19/08/2021,259
30695,22/09/2021,370
30695,03/12/2021,346
30695,02/08/2022,414
30772,21/01/2021,314
30772,15/04/2021,403
30772,29/06/2021,436
30772,19/08/2021,432
30772,15/10/2021,465
30772,25/11/2021,469
];

NoConcatenate
Temp1:
Load IdAnimal,

FirstSortedValue(Peso,Date) as FirstValue,
FirstSortedValue(Peso,-Date) as lastValue

Resident Temp
group by IdAnimal;

NoConcatenate
Temp2:
Load IdAnimal,
FirstValue,
lastValue,
lastValue-FirstValue as Difference

Resident Temp1;

Drop table Temp,Temp1;

Exit Script;

Re: Calc Last and First data

Digvijay_Singh — Wed, 07 Sep 2022 02:19:36 GMT

May be in the front-end like this -

Re: Calc Last and First data

spividori — Wed, 07 Sep 2022 13:27:02 GMT

Thanks for answering.
The total by IdAnimal is correct but I need the general total to be the sum of the result of each IdAnimal. in the example of the image it should be: 69, not 100.

Re: Calc Last and First data

Digvijay_Singh — Wed, 07 Sep 2022 13:53:12 GMT

Try changing this property to sum -

OR expression to as below -

sum(Aggr(FirstSortedValue(Peso,-FechaEvPS)-FirstSortedValue(Peso,FechaEvPS),IdAnimal))

Re: Calc Last and First data

spividori — Wed, 07 Sep 2022 14:53:16 GMT

Hi.

Yes. It's what I needed. Thank you very much!.

Regards.