Skip to main content

Notifications

Power Platform Community / Forums / Process Mining / How to filter to have ...
Process Mining
Answered

How to filter to have the longest duration case in an edge

Posted on by 25
Hi,
 
How should a filter be created to show only the case that has the longest duration in an edge between two activities?
 
In this screenshot I have the green edge which has a maximum duration of 9.14a (years).
I want to filter to find out which specific case it is because it must be an error.
 
 
In the desktop application I suppose I should create a filter with an expression, a formula. But I am not clear on how it should be created.
 
 
Any ideas?
 
Thank you!
 
Categories:
  • Francesc JC Profile Picture
    Francesc JC 25 on at
    How to filter to have the longest duration case in an edge
    Sure. I think it's not possible.
     
    Thanks André.
  • Verified answer
    How to filter to have the longest duration case in an edge
    Hi Francesc,

    I wonder if this is possible with an expression range. The event log is being transformed for optimal presentation. What I usually do is opening the source event log file in Excel, then calculate the duration and then search for specific activities.

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,749

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard