Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hi,
I have created one custom record field where it calculated sum of all the event points present in the table.But I'm trying to display this data in the grid based on the date range selection so basically if that date range has only one row with event point = 10, it should display only row with value 10 but it is displaying the sum of all 100 rows in a single row. How to handle single row data calculation in appian records?
Discussion posts and replies are publicly visible
Don't use custom record fields for filtered aggregations, they calculate across entire dataset regardless of UI filters.https://docs.appian.com/suite/help/25.3/custom-record-fields.html?utm_source=chatgpt.com#sync-time-evaluationsYou can try below 2 methods.Display the source eventPoint field directly in grid and apply date range filters in a!recordData() query(custom fields bypass grid filters)Query filtered records using date filters, then calculate sum in the interface instead of custom field.
I tried referencing the eventPoint field directly in the grid and applied date range filters using a!recordData(). However, I’m only getting the first 10 rows of data, even though there are over 500+ rows for that date range. Is there any restriction causing this?
eventPoint
a!recordData()
I hope you are using 25.2 as it has default limit of 10.You can increase this limit using a!relatedRecordData() parameter.