Hi
I regularly make use of a workflow query and group/count the results by:
* Adding Data
* Adding the output column i'm interested in (and select "group" box)
* Adding another output column and using the count(@id) expression.
* On advanced parameters removing duplicate rows and disabling the automatic adding of primary keys of the targeting dimension.
I was looking to do something almost similar, but instead of using a query, I wanted to group by some temp schema data (because i need to make use of other activities to get it how i want before grouping).
When using enrichment, I again add data and select the output columns:
1) field i'm interested in getting counts on (ticking group box)
2) count expression
* On advanced parameters removing duplicate rows
However the option to select "Disable the automatic adding of primary keys of the targeting dimension" option is not available.
The enrichment activity therefore errors.
Can anyone advise if there is a setting i am missing or an alternative approach to group/count temp schema data
Thanks in advance
David