How to use variable in views and KM.

If you are using KM Variable/ Global variable then you can access directly in KPIs ${Variable_Name}

If you are using View variable then you have to use Parameterized KPIs to pass the view variable from view to KM.

https://docs.celonis.com/en/knowledge-model---kpis.html#UUID-8244f61e-18b5-7bee-bf4a-c5bd65b6d3d0_id_KMKPIs-ParametrisedKPIs

Hello Kailash,

I tried to create a KPI using KM Variable ${Variable_Name} but I'm getting syntax error.

here is the query- AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[${start}] TO LAST_OCCURRENCE[${end}], REMAP_TIMESTAMPS("Activity_Table"."_EVENTTIME", DAYS)))

can you please help me with this.

@parvathi.choud - Can you paste the error ?

You can try passing the variable in single quotes

AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE['${start}'] TO LAST_OCCURRENCE['${end}'], REMAP_TIMESTAMPS("Activity_Table"."_EVENTTIME", DAYS)))

@kailash.potha12 thank you, it worked out.

How can we create manual entries in variable? As we used to create in Analysis.

I tried to use the KM variable in Analysis it didn't worked, but if you want to use it views i will suggest you to use Global variable - you can create in package settings.

you can update this variable in dropdown component and use it in KM as well '{{Variable_Name}}'

@kailash.potha12 Okay i will try, Thank you😊

Hello @kailash.potha12 ,

As you know we can create manual entries and load entries in button dropdown in analysis by setting variables. can same be possible with view?

Here are some images of dropdown i created in analysis.

Yes you can create custom object in KM and pass those variable/KPI ids. Call the custom object in dropdown list

Hello @kailash.potha12 

I have created custom object having columns - Day, Hour, Minute, but I'm unable to add KPI in custom object. If I add KPI in custom object I'm getting 3 different dropdowns. I want to add 3 KPI(Day, hour, minute) in dropdown.

How can I do that?

can you help me with this.

Hello @kailash.potha12 

Sorry to bother you again.

How can I add frequency with intervals (0,1,2,3...n) in histogram.

As you can see, I'm getting frequency with even numbers interval.

And how can I change the color of bars.? If I'm adding color component its just changing the y-axis color, no effect on bars.

@parvathi.choud - You can use suggestedBucketWidth: 1 in Histogram YAML

@parvathi.choud  If you can attach your screenshot of custom object and view, it will be easy to correct it.

@kailash.potha12 If I select any one of the unit time , its has no effect on the data. So do I need to add KPI in Custom object.?

This Button Dropdown with custom object will update the variable with KPI/Variable value which is there in the selection. You have to use this in your calculations or filter where ever is required.

Hello @kailash.potha12 

I have used the belove formula in analysis for calculating avg of processes between selected activities and used a unit variable which has days, hours and minutes as manual entries.

AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[<%= START_%>] TO LAST_OCCURRENCE[<%= END_ %>], REMAP_TIMESTAMPS("Activity_Table"."_EVENTTIME", <%= Unit %>)))

And I have taken this unit variable in button dropdown make selections (days, hours, minutes).

If I want to create same formula in view, where for start and end I have created variables but I don't know what to do for unit variable. And here I used custom object to create button dropdown to make selections. but I want those selections to appear in the formula.

Here you can see I have manually put days as I don't know how to put button dropdown selections.

AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE['${{start}}'] TO LAST_OCCURRENCE['${{end}}'], REMAP_TIMESTAMPS("Activity_Table"."_EVENTTIME",Days)))

can you help me with this.?

@parvathi.choud You are very close to your solution, create one more variable for time unit and add that in the dropdown list settings, based on your selection variable will be updated. You can use similar way how you did for Activity.

@kailash.potha12sorry I didn't get you. Can you please explain me in more detail.

@parvathi.choud 

If understood well you are creating global variables for selecting the Start and End activity.

In Similar way you have to create one more global variable for Time Unit let's say Variable name is 'Unit'.

I think you already have Custom object created, you can add that in dropdown list for selecting Day or month, Under the dropdown behavior select the Unit variable. You can find from below screenshot.

Now your formula will work with variable.

AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE['${{start}}'] TO LAST_OCCURRENCE['${{end}}'], REMAP_TIMESTAMPS("Activity_Table"."_EVENTTIME",${{Unit}})))

Thank you very much @kailash.potha12 

I understood.

Once again thank you for clarifying my doubts.

Happy to help 😊