Case Count displays wrong values

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
Jonas


check weather you are using variable in your analysis?
i guess the value is not retrieved by the varaible.

Thanks for your reply.
What do you mean by “using variable”?
Thanks a lot!

I mean Are you using variable in your analysis? u can view variable on top right hand corner menu

No I am not using any variables.

Case count means it displays only INT values instead of STRING values. So can try defining formula as count(your adrs column).

Thanks.

Thanks for your reply.
If I define my KPI as COUNT(“Lieferanten_bzw__Adressen_csv”.“Gruppenname”) and I left the Dimension as “Lieferanten_bzw__Adressen_csv”.“Gruppenname” (as I want to display all the Number of cases which are related to each adressgroup), Snap now only sums up all datasets in the Masterdata table of the Adresses (and not of the Case-Table).

And as far as I got it, the Case-Count counts all datasets in the Case-Table which refer to a certain characteristic/feature. So I did not define the Case-Count as a STRING variable, but it should by definition be an INT? So I do not get, why it does not work out.

Please correct me if I got this wrong.

Hi Jonas,

Take count(column values) not entire table name, case when columnName = ’ ’ then count(columnName) …etc same steps for columns and give AS for them and try to display them.

Hi pvsreddy,

unfortunately I am not really good in coding so I do not get how to implement your hint. Could you maybe make it more specific?

And another thing I do not get is, why the Casecount works perfectly fine for all charts related to the projects. For Celonis to add up all cases which relate to a certain projekt-type or to a certain article-type/supplier-type should technically be the same. And all tables are formatted in the same way and linked in the same way in the data model. Can you or anybody else find a reason for this behavior?

Thanks a lot!
Jonas

Hi Jonas,

Could you please explain which for which columns the data is not displaying along with table name you are using, in your scenario the problem might be with your MODELING like for example , in the model i am giving relationship from PRODUCT table to CATEGORY table then we can query based on products we can find types of categories but we can’t query types of products based on categories .

Same in you scenario also might be the issue you are facing , so please check your modeling part clearly or else please post you table and columns clearly so that i can give code for that.

Thanks.

Hi Jonas,

Sorry before i didn’t read your problem clearly. now i can see you want to display data of tables “ARTICLES” & “ADDRESS” . As you can see there is no relationship between those tables then how machine can know to fetch the data without giving the relationship between those tables. So please first the relationship between those tables . 100% this might be issue you are facing.

Thanks.