HI there
I have a mini application (advanced list) built over a join table with filters for it to be utilized in a dashboard card. I have added a vizualization to the mini app, but I get the error: “Aggregation calculations had a problem. Try refining filters to reduce query results.”
Even if I filter that it only shows 1 record, it still shows the error.
I do have work fields which are being set on the Load Event List Form event, but the aggregate field is a field on the join table. Can you confirm if aggregates should work on joins?
Thank you.
Hi Claire. Aggregations over join tables are limited. They are not supported on the primary table of the join, and in some other cases depending on the join cardinality. However, if an aggregate over a certain field is not allowed, the UI should be preventing you from adding the field to your visualization as an aggregate. I would potentially discuss logging a bug with support.
2 Likes
Thanks, @calvin.fisher - will do.
@calvin.fisher After playing around some more, it was due to the fact that the field being included in the vizualization was not in the list view. Once I added it, the chart showed. Thanks for the help!
1 Like