Process Analysis

Hello everyone, I want to use the WORKDAYS_BETWEEN function, however, in preparation for this function, I need to create a Workday Calendar. How do I do this within data integration/KM?  Thank you so much! BRJulia Bauer 

I’m trying to determine how best to calculate order backlog by using the activity table and event statuses. The calculation would be used to render the data into either a table, histogram or bar chart grouped into week (Round_Week(Event_TimeStamp)). Please share any ideas or code examples.

Is there a way to create dynamic content using the Enhanced View Variables? For my use case, I’d like a column header to update automatically to the current month, in numerical format. So as the months progress, the column would go from October (10-24) to November (11-24) to December (12-24), etc.I used this functionality a lot in the old analyses, as a dynamic variable.  

Hi Everyone, We are trying to automate extracting a weekly report and send it as a csv file via email to recipients. During this process, we found that some of the text specifically the one’s which are not in English gets replaced by some unreadable characters like /, $, *. Is there a way to avoid this?Help is much appreciated!Thanks,Vamshi D.

I have a question regarding a development I’m working on. I have an old view where I would like to add a button that, when clicked, opens an auxiliary filter view. This auxiliary view is newly created, using the latest version of the views, and has already been published.However, when I try to configure the button to link to this new view using the "link views" function, the view I just created does not appear as an option.I suspect this might be because it's not possible to link new views to old views, but I’m not entirely sure. Could someone confirm if this is the case, or if there's another reason why the view isn't showing up?

How would you use a button to navigate between tabs in the new version of views? I have a landing page and want to give users the ability to navigate directly to a page/tab.

PAID AMT is, by definition delayed because people have to do research and request payment before the money arrives. So, it's normal to have NULL in PAID AMT for a while. Any thoughts? Apparently, I wasn't authoring the conditional statements correctly. 

Can we create action flows for views?

I work as a Business Analyst and a huge part of my work involves working with Advance View component. Recently I discovered that the "Edit Mode" button is gone for all the existing elements of my app. Also, I cannot create a new Advance View, I'm getting the error in the attachment. After this update I cannot do my job at all. Any idea what happened here?

what is the difference between action view and a normal view ? How can we create action view ? Can someone explain the steps

Hi all,I have an Action Flow where I use the Get Rows Module to get KPI Value from the KM. Then I use the Separator and do a filter on the on side to track if KPI1 > KPI2. But it doesn't work because the KPI values are somehow formatted as <text>.  How can I do the numeric filter on the KPI's?

I have number of files in pdf/word format. These are POD/BOL for an individual lineitem. I want to create a new column called as attachment where these files such as POD/BOL are available as hyperlink. Fileformat is in InvoiceNumber_BOL.pdf or InvoiceNumber_POD.docx . Is there a way to automatically attach the document to a particular line item and show as hyperlink.

Hi all, Question related to variables and images. The Image component works with a http URL as the input; I am attempting with not much luck to make this image interactive with input dropdown filters which are linked to a variable. Then editing in the YAML editor to insert a case when statement that would point towards a different image URL depending on the selection.  As mentioned I'm not having much luck on this and wondered if this was possible or anyone has dealt with this before?  Thanks in advance!

Hi, As title, in the new view, can you create a stacked column and line graph?  Can it be implemented into components? Best RegardsSew

Improved augmented attribute creation flow in Studio (2024-08-19) We've improved our augmented attribute creation flow, making it easier to select and configure different data types. Augmented attributes are a Knowledge Model (KM) asset that can be updated in real-time and without the Data Model reloading. By assigning an augmented attribute to a specific table in the Data Model, you can add additional information to the source system. This additional information can then be referenced in your Views, describing your business objects in further detail and generating additional process insights. To learn more about creating and using augmented attributes in your Studio content, see: Augmented attributes. 

Hello everybody,I have a filter bar in which I have inserted a quick filter component containing quick filters on 9 different Boolean fields.Technically it works fine, but the problem is that the visual rendering is awful as I cannot increase the height of the quick filter component and all labels are truncated and incomprehensible, as in attached screenshot: Is there a way to increase the height of the quick filter component so that the filters can be grouped and displayed on multiple lines? Thanks to everybody who can help me, best regards,Andrea

Hello, I'm using the views in the studio for the first time. The old version allowed you to make a selection (see screenshot below). Is it possible to do the same thing in the new version of the studio? Thanks for your help

I have 2 tables connected with each other. From table1 when I select Current month value in drop down. I want to sum the balance column values from table2 where month value is selected month value - 1.

Hello together, I want to build a dynamic filter that can vary depending on when a particular button is clicked. This means I write a variable and update it depending on the button. The filtering also depends on this. Unfortunately, I cannot use the variables created in the view as input for the filter.  Specifically, I have a button called “Process start” and one called “Process end”. Depending on what was clicked, the start of the process in the filtering should not be longer than 12 months ago, or if the end of the process was clicked, it should not be longer than 12 months ago. I'm using this for a diagram. Unfortunately, the dynamic variables cannot be used in filtering.  Does anyone have an idea? I'm really desperate. Thank you very much and kind regards! 

Hi all, I want to update the value of a runtime variable with a Button input from a View (JAB) in order to use this runtime variable for a KPI with a PQL Statement inside a knowledge model .But I can't find the runtime variable in the 'update variable' selection of the button. Any Ideas how I can dynamically update the runtime variable value from a View?

Hi,  Even if I published my Studio package with KM, I am receiving an error at Apps: This component has been misconfigured. It can be fixed by people who have access to the Celonis Studio.How can I tackle this issue?

Column and Line ChartHi, In View, there is a feature that you can split the line by column in the graph. I tried to create the same feature in the New View using column and line chart component. But having no luck! Any helps would be helpful!

Hy,I have connected a skill with action flow using webhooks module and connected a view with that skill.As I wanted that user be able to enter text at runtime, I am getting error if I enter text in next lineThe 'execute action flow' module throwing error as follows

For example, I have a table listed with below values in one of the columnsComponent-AComponent-BComponent-CComponent-DPopup screen should show details of Component-C when I click it . I couldn't find any relevant material on this.Thanks in advance for your help.

Hi Celopeers and Celonis team.  I have quite a conundrum that is bothering me quite a bit and I don't know what else to try. I have a case-when kpi that creates a risk category for customers based on a set of parameters. It works perfectly for customer by customer basis. But when I try to do any aggregations by the categories it always shows just one value. In the below image you can see it in action. In one the KUNNR number is the dimension and the Category as the KPI, in the other, the Late payer is as dimension and COUNT(KUNNR) as a KPI.