Hi,
I’ve built a simple 5 button user satisfaction app which when a button is pressed the data is patched in to a SharePoint list.
Im now creating another app to pull the data back out. I’ve got different tabs for different time scales E.G last today, last 7 days, last 30 days and last 90 days
I’ve managed to count how many responses have been submitted over each time scale but now I want to calculate the average for each response.
I used the following formula to get the number of responses per time scales but not sure how to get the average of the ‘score’ column for each of the time scales.
With(
{
wSRM:
Sort(
'SRM Results',
ID,
Descending
)
},
CountRows(
Filter(
wSRM,
'Received on'>= DateAdd(Today(), -0))))
