Open
Description
When creating a number card record with average and sum functions and adding it to the dashboard, an error occurs when attempting to display the dashboard:
psycopg2.errors.GroupingError: column "tabDoctype Name.modified" must appear in the GROUP BY clause or be used in an aggregate function
LINE 5: order by "tabDoctype Name"."modified" DESC
Steps to reproduce the issue
- Create a number card record.
- Configure the record with average and sum functions.
- Add the record to the dashboard.
- Display the dashboard.
Expected Behavior:*
The dashboard should be displayed without any errors, showing the number card with the configured average and sum functions.
Actual Behavior:
The mentioned error occurs when attempting to display the dashboard, preventing the proper rendering of the number card.