Dashboard Table showing Average of a Column

Hi I have a Excel Sheet imported into Mendix with 5 columns. The Sheet will be appended with new values periodically. I need to find the Average Value of those 5 columns as they get updated every time and show the results in the form of Table. Please help on how to proceed.
1 answers

When importing the data make sure the data is associated with an entity that contains the average values.

Then create an event to retrieve the average object and for this retrieve the other data to calculate the averages and update the averages object. This could be a after commit event on the record you are importing.

Or if the actual values are not needed, why not calculate the average in excel and import the averages only, but this depends on your specific situation.