COUNT DISTINCT returns invalid values

My datasource (coming from a partner connector I made) lists uniqueIDs per date (to summarize...). I would like, in a score card, to count distinct values of uniqueIDs, but the result is far too high. My guess is that Looker Studio does not properly handle the date field.

Trying to troubleshoot the score card, I ended up building a table and found an issue with COUNT DISTINCT by filtering on a particular uniqueID. When I show the underlying data, the result is fine. But in the table, it shows much more.

maerlin9_0-1725622274289.png

I think I have an issue with the date field. The table shows a warning: reaggregation of the data response is invalid.

 

0 7 1,102