Aggregate based on paging

Xano Support Chat

Hi there, I have a question, in this video you explain how to use aggregate, how could I use only 2 records for that aggregate function instead of all?

Xano Support Chat

Because the aggregation is happening before the paging, this is why you are still seeing the full average instead of the average for the records only on that page.

I've put together a video example of a workaround for you here: https://www.loom.com/share/f92553e3ec5b4b4f99db4048e0e52da5

Xano Support Chat

and Paging doesn't work to limit the amount of item when using aggregate-avg

Xano Support Chat

I just want it to run agregate-avg function on just the first 2 records, instead of all of them.

Xano Support Chat

the total of the records is 3, in the first part of the video I use the function without paging, and it gives me the correct avg of the 3 records, then I apply paging to limit it to 2 records, and it doesn't work, it keeps giving me the avg of the 3