Assistance needed for counting sensors per day in AppSheet using GROUPBY

[Adolfo_Enrique_]

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:

IdActividadPlanificadaSensores	Fecha
f8c4ed31	11/02/2025 15:25:39
f0014afb	17/02/2025 11:18:03
49299316	17/02/2025 11:28:51
2dec8fa2	17/02/2025 12:40:30
9dac04fa	17/02/2025 14:39:45

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

Fecha	CantidadSensores
11/02/2025	1
17/02/2025	4

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

GROUPBY( [SensoresDisponibles], [SensoresDisponibles][FECHADATE], "CantidadSensores", COUNT( [SensoresDisponibles][IdActividadPlanificadaSensores] ) )

But I’m getting the following error message:

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

Could you help me with this?