Dear Celonis Community,
I have a problem with the Casecount of certain items. Attached you find my data-model where I have linked the Casetable to the Masterdata Tables (Articles, Adresses, Projects and Shipments) and the Activitytable.
If I now display the Casecount for different features (see file “Problem Casecount Article- and Adress-Table”), the Casecount is displayed as having a lot of missing data for the Article related features (left third of the Screenshot) and also for Adress related features (right third of the Screenshot). For the Project related Features it works perfectly fine (central third), but all of these three Tables are linked in the same way to the datamodel via a Foreign Key, which is a number, but which I have declared as being a String-Variable, as I do not need to calculate values for these columns.
Can you help me find out, where the wrong values for the Article related or Adress related features come from?
Thanks a lot and best regards