Assistance needed for counting sensors per day in AppSheet using GROUPBY

Hello everyone, I need help to resolve this situation. Let me explain:

I have created a table called ActividadesPlanificadas [IdActividadPlanificada] which contains all the activities to be carried out. This table is related to another table called ActividadPlanificadaSensores [IdActividadPlanificadaSensores], where the sensors manufactured for a specific activity are stored daily. My requirement is as follows: in the detail of a planned activity, I need to be able to see the quantity of sensors manufactured per day.

For example: If you have the following data:

The formula should return a grouped list by date with the sensor quantity:

For this, in the ActividadesPlanificadas table, I created a virtual column with the following formula:

But I’m getting the following error message:

Unable to find function 'GROUPBY', did you mean 'ORDERBY'?

Could you help me with this?