Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Process Mining / How to filter to have ...
Power Automate - Process Mining
Answered

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

(2) ShareShare
ReportReport
Posted on by Francesc JC 27
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:
Reports
Recommendations
  • LukasCervenan Profile Picture
    LukasCervenan 16 on at
    How to filter to have the longest duration case in an edge
    Hey Francesc JC,
    its possible to analyze and filter the longest duration on the edge. The simplest way how to do it in the PAPM desktop application is following:
    1.  Go into statistics from the left menu
    2. Select the Edge statistics:
    3. Click on the column description - Maximum duration (thus you will invert the order).
    4. This displays the longest path. Select it and click create filter:
    This takes you to the filter section, where you select conditions which you want to see - e.g. Edge metric Maximum Duration greater that xxx( a bit below your maximum value you have seen a while ago).
     
    Please be aware that this is case-level filter, not event-level filter. Similarly, we are able to create the event-level filter. Filter selection depends on what we are trying to achieve.
     
  • Francesc JC Profile Picture
    Francesc JC 27 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
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 65 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,318 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,111 Most Valuable Professional

Leaderboard

Featured topics

Welcome to the Process Mining Community forum

Product updates

Microsoft Power Platform Community release plans