Product Q&A

Hi,  Do you have any proven method for getting ALL task related to record? I know there's action flow allowing to get details of a task for specific record it, but first I would like to get all of them. Best would be to upload that data into table.  I know about legacy view task list, but it's no viable and we cannot wait for implementation of that component into new views. Best Regards,Mateusz Dudek  

Hello. I work as a data analyst in a logistics warehouse, and I am totally new to Celonis and not very experienced in SQL servers either, but I was given the seat, since former analyst has retired.My task is to create a Item-weight master that daily updates unit weight , with average of unit weight calculated from 10 most recent weighted record. Since there are no RANK or TOP functions in Celonis, I am confused how can this be done.Can anyone tell me how is it possible to be done on celonis?  Thank you.

Hello everyone, I'm facing issues while creating a view. I have a grouped column chart. Now I want to limit the number of displayed bars to 6, but scrolling to the other bars in the time line should be possible. When I use the data setting "Allow scrolling," scrolling works. However, when I set a limit in the data setting, I can't scroll anymore, and the displayed time period is fixed.I hope you understand what I mean. Does anyone have an idea how this could work?

Hi team,I am searching for a component which on clicking will take me to another tab in same view.It was possible in analysis using button component (open tab feature).Can you please guide me how can i achieve this in view.Thanks beforehand for the help.

Hey, I cant really find a lot of information about how to use the D3 Format for columns.How do I align a single column to the center here?It says to use "^" but I cant implement it. Thanks!

Eg: I want to assign a value 'Category' to my runtime variable (runt_variable). previously, if the runt_variable has some other value assigned to it, I want to change it and assign it as 'Category' once this is done, the remaining action flow module has to be executed.

Hi All, I would like to know if anyone has any idea on how we can extract data of Action Flows into machine learning workbench using python.(NB: I am using pycelonis version 1.7.2)

That way I could put the link in the button in an Analysis, and the users could click there, fill in some fields, and done - and that would execute the Action Flow with the values of the formular.

How to limit the filter for the one table only in new view?

Good day community, We are having issues with the "Carry Filters" option on Analyses. This feature works very randomly: sometimes the option does not appear at all, other times it appears but it doesn't actually carry any filters, and sometimes it works as expected. I am not able to find any documentation on this specific feature, or any option that could allow me to review what is happening. Has anyone experienced something similar? Does anyone have an idea of what could be happening here? Is there a way to configure/review the "carry filters" option to see if modifying it would help it behave as it's supposed to?Any input is appreciated. Thanks in advance!

My company is changing its brand name, also all employee e-mail addressses change. How can we manage this change with Celonis?

For using celoextractor we would need on-premise system and dataconnection in particular VM?

Hi, I need PQL code for below query. 1) Need Sum total of "BSEG"."WRBTR" column based on a new manually created column having concatenation of "BSEG"."LIFNR" and "BKPF"."XBLNR".

Example in the below picture is one of the scenarios: 1. Invoice is posted in Jan 2023 but paid in May 2023. Hence, the total open invoice amount should be accountable for not only Jan but also for feb, march and april. Unfortunately, I get the Total open invoice amount accounted from the posting month followed by all the rest of the month in the data set.  My current approach:Round(Posting Date) column: RANGE_APPEND(((ROUND_MONTH("O2C_AR_BSEG"."CPUDT"))), '1M')Total RUNNING SUM column: RUNNING_SUM( SUM(  CASE WHEN ROUND_MONTH("O2C_AR_BSEG"."CPUDT") <> ROUND_MONTH("O2C_AR_BSEG"."AUGDT")  THEN  (  CASE WHEN ISNULL("O2C_AR_BSEG"."AUGDT") = 0  AND ROUND_MONTH(&

In the celonis View do we have any component to create a pivot table similar like in Analysis.Please let me know the steps if there is a possibility in Views(to create pivot table)

I want to create a variable in new view which would add every current year automatically into the table. Please help.

Since Custom Extractors are implemented por REST APIs only, what is the best strategy to consume a SOAP web service? I successfully consumed it via a Python request, using an XML body. Is Celoxtractor the only way to upload the data, or is there a more straightforward way to connect to a SOAP WS? Thanks

Is a procedure as described in the screenshots possible with extractor builder?

Is there a way to share a link for a view (also package) to a user with access rights, but the link is easier for them to open the dashboard?

Is it possible to connect multiple sources into one process ,with different type of sources (ARIBA +SAP ECC , Success factor + SAP ECC, MS-SQL + SAP ECC) ?

I know it might seem simple question but i am struggling with uploading BPMN file for my conformance sheet. can anybody tell where and how to upload it ?

I would like to have the green start where the blue stop (Stacked graph)- how can I do that? 

I want to know who is my Partner Manager Urgently: Thanks gabriel.cifuentes@cliptecnologia.com

Hi,  I wanted to implement the open target quantity in celonis. Therefore I used the RUNNING_TOTAL function to add up the quantities as shown in the screenshot. After, I wanted to subtract the RUNNING_TOTAL from the target quantity, the code for this looks like that: "CONTRACT_INFO"."KTMNG" - RUNNING_TOTAL("EKPO"."MENGE") That constantly gives me the following error:  The running aggregation function RUNNING_TOTAL cannot be used together with a dimension function input. Please check that there are no moving aggregations and dimensions used together as function inputs. Even if I try to use e.g. AVG(), SUM(), LAST() in front of "CONTRACT_INFO"."KTMNG" , it's not working. Only if I use RUNNING_TOTAL() in front of "CONTRACT_INFO"."KTMNG" it's working, but obviously this is giving me wrong results. Thank

I have add the action send an email for the enhanced view for a table but when i select the button to execute the action it is giving me a pop up. Any way to resolve it