ANSWER: =SUM(OFFSET($A$1,COUNTA(A)−9,0,10))

thank you!!!

My solution for now is to create a second table that holds the mood value and the count. When a user tracks their mood, I will make 1 insert into the transactional/detail record type and then update the count in the 1 record in the second table. The pie chart is sourced from the new table and the list view displays data from the transactional table This seems to work for me. If anyone has a better way to do this, I am open to suggestions.

Thank you for this information. I am running into the same thing with my app.

Hi Michael, did this trial to purchase flow work for you? I would like incorporate a similar offer with my app.