PF

Hi,

 

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. Specifically, I'd like to create a field with the total activity/case duration for all records - i.e. not at the individual case level. 

So, for example, the fixed LOD value for the dataset below would be 7 days:

Case ID Activity Timestamp Activity duration Case duration
1 A 01/11/2022   3
1 B 02/11/2022 1 3
1 C 04/11/2022 2 3
2 A 01/11/2022   4
2 B 04/11/2022 3 4
2 C 05/11/2022 1 4

Not sure how to accomplish this? I think that the PU_SUM function might possibly be the way ahead, but a) I can't seem to find an example of how to populate the syntax requirements correctly (i.e. PU_SUM(scope: Table, source: Table, field: Field | Calculation, filter?: Boolean)) and b) I suspect that this would only roll up to the case level, which is already available from the standard Case Duration measure. 

One of the reasons that I would like the ability to create fixed Level of Detail calculations of this ilk is to be able to generate an Index to compare distribution and performance metrics - for example, in the App Builder, I can configure the Number of Occurrences and Activity Cycle Time measures to display as a percentage share within the App, but I can't seem to build calculated fields for the same percentage share values to then compare and Index the distribution metric (i.e. Percentage Share of Count of Number of Occurences (Base (100%) value = (CT (Number of Occurrences)) with the performance metric (i.e. (i.e. Percentage Share of Sum of Activity Duration (Base (100%) value = (SUM (Activity Duration)). I haven't worked out a way to achieve this.