How to get a summary table

[Sandro_Ingrao]

I have created a table that contains the following fields:

[IDRECEIPT] [NUMBER], [DATE], [IDMEDICO], [IDPATIENTE], [METHOD], [PAYMENT], [MACHINERY], [IDPRESTMEDICO], [PRICE]

I would like to obtain a view that in a row groups data showing the same date. Example:

[DATE] 16/10/2021 - Sum ([PRICE]): € 100.00 - Min ([NUMBER]): 1 - Max ([NUMBER]) 5 - SumIf ({condition If [PRICE]}): € 80.00 - SumIf ({condition If [PRICE]}): € 20.00

[DATE] - Sum([PRICE]) - Min([NUMBER]) - Max([NUMBER]) - SumIf([PRICE]) -SumIf([PRICE])
1/10/21------€ 100,00----------1------------------------5-----------------------€ 80,00--------------€ 20,00
2/10/21------€ 150,00----------6------------------------7-----------------------€ 90,00--------------€ 60,00
8/10/21------€ 350,00----------8------------------------15----------------------€ 200,00------------€ 150,00
9/10/21------€ 80,00----------16------------------------16-----------------------€ 80,00-------------€ 0,00

[WillowMobileSys]

Sandro_Ingrao:

I would like to obtain a view that in a row groups data showing the same date. Example:

A summary table would first need to be generated for the view to use. You can create process(s) in AppSheet to create the desired rows and data you need. There are two general ways:

1. Keep the summary table updated with every new row and/or update made to the source table. Use actions on save activity to apply updates to the summary table.

2. Create an Automation process to generate the table as needed. This could be a Scheduled Bot or a Data Change Bot ran on request.

I hope this helps!