Memory Threshold Issue in Production Dashboard with Large data

[CarolWilks 0]

We are facing a production issue in an application with a large volume of data. We display case counts using Expression Rules (ERs) and category-wise metrics using a Record Type-based Bar Chart. Although we apply filters on a few columns, when users select a 1-year date range, the queries process a significant amount of data and the ERs fail with:

"Memory threshold reached during output conversion"

The bar chart performance is also impacted due to the large dataset. We are looking for best practices to handle large-scale reporting and dashboard aggregation in Appian. Has anyone implemented an effective approach for such scenarios in production? Any suggestions or recommendations would be greatly appreciated.

[GermanStein 0]

You will have to reduce the volume of data queried. You might have to rebuild the record based Bar Chart by querying the data yourself and manually feed it into a bar chart.

[Ullani 0]

I ran into a similar wall with high row counts and found that pre-aggregating data in a stored procedure helped a lot. For plant floor visibility, we use an andon board to track production metrics in real time, which keeps our reporting lean. Have you checked the exact row count your query hits, even with filters?