Question
Create a timeseries linechart
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.