Average on Average

[Tech_Service]

Hi I’m creating a Carbs Counting App. The table will be list of foods in all the meals, and dates. From the UX we can create a SUM/Average Carbs for each Meals, Dates, that is no problem. but now I want to average of each meal or each day in a month?? How can I do that?

Please Help

[Marc_Dillon]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

AVERAGE()

Arithmetic average of list items

You won’t be able to do it with the Group Aggregate functionality within a UX>View. You’ll have to write expressions to get your specific answers, use the articles I’ve linked above.