Solved

It is mentioned in the scenraio 5 of 'IN' Predicate function documentation page - IN (celonis.com)  Thanks in Advance!

Hi expert, I'm not quite good at SQL and I have a question about SQL. In my case, I would like to filter activity table with event time with its only time(hh:mm:ss). Does anybody let me know how to do that in Celonis data integration task?

Hi All,Im trying to find the count of throughput time in buckets in views. The histogram are the way to go but in views they only accomodate integer and floats but not dates. Im trying to come up with it in Chart but unable to.Please let me know if someone has any idea.

Hello, I open this question that was already asked by another user 5 months ago and not answered from Celonis. Moreover, I'm not allowed to comment or ask for update on that post if the post is older than 30 days. I would like to query data in an Action Flow from the Knowledge Model and not from the Data Model. Currently I have an Action Flow connected to a Data Model and I have modules like Tools (set multiple variables) replicating the same KPIs I have in the Knowledge Model. If I need to update a KPI in the Knowledge Model I have to remember to update it as well in the action flow, this causes high maintenance and possibility of error. This feature is critical since one of the main goals of using Studio is the centralization of KPI definitions into a single source of truth, the knowledge model. If you have any update on this topic I'd appreciate if you can share it with the community. Thanks. BRAlejandro 

Hi everyone,  I am building a View, where I want to list some KPIs from my Knowledge Model on top of a table. For that purpose, I first chose an Attribute List, as I see in the documentation that it can take KPIs as Input. Then I tried a KPI List instead, with the same KPIs from the Knowledge Model, and I noticed that the numbers displayed in each KPI are considerably different, when I use one component or the other. (I checked it and the numbers on the KPI List are right, and differ greatly from those in the Attribute List). Does anybody know what the cause of this discrepancy might be?  How do Attribute Lists function overall? When should I use them? I was not able to find further information about that in the docs. Thank you very much! Javier

As the title says I want to create a plot that cannot bed created in Celonis (as far as I have researched and tried). The workaround was to create a script on Machine Learning Workbench that uses the information from the KPI's but I don't know how to include the plot created with matplotlib into the sheet  And then to appear somewhere in my dashboard   Thanks!

How would I expect this data to be visualised. Would it be as four parallel tasks or in sequence in record order. Does process mining support a parallel split?Case,Task,Time1,x,01/01/2023 00:00:001,y,01/01/2023 00:00:001,z,01/01/2023 00:00:001,a,01/01/2023 00:00:00

Has anyone any experience or resources in using Process Mining to evaluate users interacting with a SaaS product and generating an event log. My data shows the events of user sessions and I'm interested in both session and multi-session journeys.

I have 3 tables:Fact Table A with n entries per case and a time dimension (round_hour)Case Table which containts the case keysAnother Fact Table B with m entries per case and a time dimension (round_hour)The data model is n : 1 : m. Unfortunately a generel snowflake model is not possible. Now I need to sum up the duration from Fact Table B aggregated by the time dimension from eventtime2 (round_hour) and display the sum in a chart. The time dimension for the chart is represented by the time dimension eventtime 1 from Fact Table A (round_hour). I tried bind, domain_table in combination with PU-Functions but nothing worked.  Is there a any way map those time dimensions from different fact tables with a n : 1 : m relation? 

Hi,  I am using Augmented Attributes in a Knowledge Model to build a View App. The A. Attribute is defined to have 4 possible values (dtype string) and it is meant to be updated manually by the end-user in the app to any of those 4 values. It has a Default Value as well for all those cases where the end user did not manually updated the attribute (which happens frequently). The problem comes when I want to use the "VALUE" field stored in the augmented table from the attribute in the Knowledge Model. I want to filter a chart based on the Attribute´s values (again stored in the VALUE field) and also define a KPI with a CASE WHEN logic based again in the value of the attribute. When I do so, it just returns the rows or datapoints where the Attribute was manually updated, filtering out all the rows for which the default value should appear.  I have not found a way to include the default value in the PQL queries outputs that I desire, so that I do not get most rows filtered out wh

Hi,I would like to to apply this function to mesure the cycle time of Change Activities. The activities table looks like this: Case ID2 columns "Change From" and "Change To" along with timestamp columnTime starts counting for each case when Change To = A for the first time and ends when Change from = A for the last time.   The logic Im trying to work around is (just disregard the function syntax- Im just trying to explain the logic.CALC_THROUGHPUT( First_Occurance ('Change to' = 'A') to Last_Occurance ('Change from' =' A '), Remap_Timestamps("Table"."event time", days) What is the right way to implement this logic?Should I filter the table to be "Change to" = 'A' or "Change from" = A and then merge this two columns to form a single column to use calc_throughput? But then how to merge different columns in the same table? Thank you for any suggestion!  

Dear all,I'm looking for a way for the Viewer User to save his allowlist in the conformance checker. Is this really only possible for the Analyst? Thanks in advance! Best,Jonas

I would like to add a status selection functionality in the studio. I would like to have a default status of 'To checked' and for the user to be able to change to 'to be checked'. Does anyone have an idea how to do this?

Hi, How can I "hide" a published package inside a space? Just like i can hide (Visibility On/Off) the assets inside a package, i was looking for a solution for hiding the whole package. thanks

Hi, I need to create a list of all table names and columns in each table that we have in Celonis.  I've tried pycelonis, but while I can get the tables the columns list showed as empty when using get_tables(): DataPoolTable(name='LFA1', data_source_id='xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx', columns=[] ,...) I've also tried using sql query: select table_schema, table_name from v_catalog.columnsbut got error: "Not allowed to access schema v_catalog" Is there a way to quickly download such list? Thanks,Karol

I would like to concatenate a date and time coming from a specific table into a single column, but I get the following message:Operator requirements are not met. Operator 'CONCAT' is not compatible with inputs of type DATE. Is there some workaround to concatenate DATE type?

Hello All, Can you please share me the training course where it was defined what are the basic difference between Process Explorer and Variant Explorer.

Hi, I would like to use a formatNumber(...) function in the result of the SUM() function. The operation is unsuccessful, I receive information The operation failed with an error. Failed to map 'formula': Function 'formatNumber' finished with error! 'NaN' is not a valid number or using unsuitable separator. Do you have any advice?

initial output : C76_XX_XXXX_INVOICE_LIV_XXXX_XXX.001.pdf what i would like :C76_XX_XXXX_INVOICE_LIV_XXXX_XXX_001.pdf Thanks for your help

Hey Celopeers community! I am attempting to create a change activity based on a changing list of values, below is an example of a case where a change activity should be created.  Case ID | Date | Value1 | 2021-8-20 | A1 | 2021-8-20 | B1 | 2021-8-20 | C1 | 2021-8-21 | A1 | 2021-8-21 | B As you can see the list of values changed from A, B, C on 8/20 to A, B 8/21  I looked at the VERTICA function library and found LISTAGG function that would help solve this by concatenating fields into one single row, but, unfortunately, it is not enabled in Event Collection.  Are there any workarounds you can suggest? 

I need to take the first 8 values of a column to obtain the creation DATE. Then I need to take the remaining values for the TIME. I will then cast them as Date and Time for creating the EVENTTIME. The code below should have worked, but since it is a FLOAT data type I receive an error message on the Output. Code:SELECT ERSDA,ERSDA_TMSTP,SUBSTRING(ERSDA_TMSTP,0,8) AS "INFO1", SUBSTRING(ERSDA_TMSTP,9,4) AS "INFO2" FROM MCH1  Output:Execution error: ERROR: Function catalog.substring(float, int, int) does not exist, or permission is denied for catalog.substring(float, int, int)

According to requirement we have tried special character to identify but unable to add ' and % in celonis. The syntax which we have used is CASE WHEN("TABLE NAME"."COLUMN NAME") IN_LIKE ('!','@','#','$','^','*','(',')','- ','_','+','=','{','}','[',']','|','/',':',';','"','<','>',',','.','?') THEN 'CLEANSE' ELSE 'PERFECT' when we are adding ' and % two characters output is getting changed. For identifying the correct email address we have got this syntax IF(match_regex($email, '[a-zA-Z0-9_\\-]+@([a-zA-Z0-9_\\-]+\\.)+(com|org|edu|nz|au)', null))but its not working.

Hello All,   I want to use pycelonis to get all version of data pool (including Draft if present) The below code does not not show data pool version    data_pool = celonis.pools.find("XXXXXXXXXXXXXXXX) print (data_pool)  Output: <Pool, id XXXXXXXXXXXXXXXX, name 000_Extraction (000_CELONIS_DATA)>   Is there any way i could get the data pool versions? 

Hey there! I'm having trouble selecting cases from a table, that match a calculated condition.  The data I'm trying to analyse is about quality-checks. A quality-check consists of multiple rows in which the result (minor fault/major fault/no fault/not relevant) of each checkpoint is delivered. My goal is to calculate the quality of each quality-check and display those quality-checks which didn't reach a certain percantage of quality.  What I already did is: Calculate the quality of each check in %1- (SUM(STR_TO_INT(REMAP_VALUES("CASE_QS"."RESULT", ['no fault', '0'], ['minor fault', '5'], ['major fault', '10'], ['not relevant', '0']))) / (COUNT("CASE_QS"."CHECKPOINT")*10))Create condition to evaluate whether the desired quality of 99,9% isn't reachedCASE WHEN (1- (SUM(STR_TO_INT(REMAP_VALUES("CASE_QS"."RESULT", ['1', '0'], ['2&#3