Pull up operations to other table fields

ARIS pull up is possible for cases and activities, where as the need is to pull up (with nested logics) function to work with other table fields to create calculated fields.

E.g.,

AVG(CASE WHEN PU_COUNT_DISTINCT('_CEL_P2P_ORDERS', LEN('supplier_shortlisting_results', 'article_id'))=1 THEN 1 ELSE 0 END)z

Aleksandra Piasecka
Oct 20 2022
Planned

Attach files

Enter a subject

8 Vote

Ratio calculation for different aggregation levels Merged

When combining information from different tables, you want to be able to calculate ratios based on measures that are based on different aggregation levels. For example the number of cases per purchasing organization divided by the number of FTE's ...

Created 15 Jan 15:54 by Guest

1 Shipped
4 Vote

Using Code Editor to create Level of Detail calculated field (PU_SUM?) Merged

(Disclaimer: More of a question than a idea! - also posted in the ARIS Community) I'm trying to work out a way of using the Code Editor (or any other calculated field method) to generate a fixed Level of Detail (LOD) value for an imported dataset....

Created 25 Nov 11:09 by Guest

0 Planned

SHARE YOUR IDEAS

How can we make ARIS Process Mining better?

Pull up operations to other table fields

Ratio calculation for different aggregation levels Merged

Using Code Editor to create Level of Detail calculated field (PU_SUM?) Merged

Related ideas

Pull up operations to other table fields

Ratio calculation for different aggregation levels Merged

Using Code Editor to create Level of Detail calculated field (PU_SUM?) Merged

Identify yourself with your email address

Related ideas