Skip to main content
I would like to see the workflow of 2 different task tables from SN in Celonis. The Case table and the case_task table. The issue i encounter is that the dimension Roundmonth (case record created) does a auto join for the case and task table (sounds logic). But all i want is a simple "excel"table to track the records. How can i show the trend of 2 different tables based on both their creation date?
Hi! Thank you for your question! In this case, can you create two Line charts with the rounded Creation Date as a dimension? Then you should not have the issue of a join between the tables. You could use ROUND_MONTH(Casetable.Timstamp) and in the other one ROUND_MONTH(Case_tasktable.Timstamp). Best regards, Celonis Data Science Team