Hello, I understand you want to create this table in the backend, right?

I think that can easily be achieved in SQL using the order by function, here i leave a sample query that may come in handy:

WITH RankedRecords AS (

  SELECT 

    Innercode,

    Weight,

    Timestamp,

    ROW_NUMBER() OVER (PARTITION BY Innercode ORDER BY Timestamp DESC) AS rn

  FROM 

    YourTableName

)

, RecentRecords AS (

  SELECT 

    Innercode,

    Weight

  FROM 

    RankedRecords

  WHERE 

    rn <= 10

)

SELECT 

  Innercode,

  AVG(Weight) AS AverageWeight

FROM 

  RecentRecords

GROUP BY 

  Innercode;