Forum Discussion

MarkEvansHW's avatar
MarkEvansHW
Icon for Helper II rankHelper II
6 years ago

DISTINCTCOUNT in Aggregation table?

The composite data model using the "Manage aggregations" feature seems potentially very useful, but I'm really struggling with the lack of support for DISTINCTCOUNT.   It maybe the nature of the da...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

DISTINCTCOUNT can not be aggregated it needs to be calculated from based data only. That is why not supported.

See if at a few places you can avoid that. Other you have to get it from the base table only.