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?

[WillowMobileSys]

AppSheet does not have a GROUPBY() function.   You can apply grouping to a Table or Deck view.  The Grouping feature also provides for Aggregate functions so you can see the Count within the Grouping.  This is the simplest and easiest way to visualize the Group and Count. See image below.

If you want to retain the Count to be used elsewhere such as in calculation, then you can adjust your virtual Column expression to use the data assigned to the row and provide a count for that date.

COUNT(SELECT(ActividadPlanificadaSensores[IdActividadPlanificadaSensores], [Fecha] = [_THISROW].[Fecha]))

I hope this helps!

Where to apply Grouping with Count to a Table or Deck View