Any idea why a QuickSight visual is not recognizing a calculated field as an aggregate when it is pulled into a direct query dataset?
The calculation sits in a parent dataset; I have a direct query that pulls these calculated fields into a new dataset. But when I try to add to a Pivot Table visual, it treats the field like a typical number and tries to apply a “SUM” aggregation in the pivot table, and creates this error:
Field in parent dataset:
Field in child dataset:
Any ideas or workarounds?