Hi Gaston,
When I select multiple data items in the query, I can set the Detail aggregation. It is not possible when selecting the items in the page design.
------------------------------
Thomas van der Meer
------------------------------
Original Message:
Sent: Tue June 29, 2021 09:31 AM
From: Gaston Pouliot
Subject: Count Distinct Multiple Fields
Tried that one also. But in the in the properties now I no longer see Detail Aggregation. I do not think in Cognos we have a way to select multiple fields and assign them the same detail aggregation values.
------------------------------
Gaston Pouliot
Original Message:
Sent: Mon June 28, 2021 04:43 PM
From: Zach Zeman
Subject: Count Distinct Multiple Fields
You can CTRL + Click multiple data objects and set the aggregation.
------------------------------
Zach Zeman
Original Message:
Sent: Thu June 17, 2021 11:28 AM
From: Gaston Pouliot
Subject: Count Distinct Multiple Fields
Hello,
Does anyone have a way in Cognos Analytics to be able to select multiple 20+ field and simply apply count distinct? Today we are having to select field by field and it's very time consuming. We are building a bunch of reports in order to do some testing using MotioCI and have hundreds of dimensions to test and create reports.
Thanks
------------------------------
Gaston Pouliot
------------------------------
#CognosAnalyticswithWatson