Primary key doesn't seem to be recognised

Has anyone dealt with this error before?

957ee65d-af60-47bc-9ae5-7f179ae2ccc9.png

I understand what it’s saying, but I have primary_key: yes defined in both of the tables I’m using. The join is one_to_many and I’m trying to use a count type measure in the joined table, which is resulting in COUNT(*) instead of what should be a count of the primary key.

I don’t understand why the primary keys being present doesn’t resolve this issue. I have another table joined in with the same relationship and it works fine.

I’m kinda suspicious it might be a bug but also it’s possible I’ve missed something obvious

0 0 78
0 REPLIES 0
Top Labels in this Space
Top Solution Authors