Forum Discussion

elliottcarver's avatar
elliottcarver
Frequent Visitor
6 years ago

Complex DAX Calculation - Event Log Cycle Times for Process Mining

Trying to create a model for cycle-time reporting that allows a report-user to know how often the time between any two steps met a variable target.   I want report users to input the following vari...
elliottcarver's avatar
elliottcarver
Frequent Visitor
6 years ago

This is really helpful feedback Jan - thanks so much for your help 🙂

 

So, is there any way for me to measure the time between any Step A and any Step B using the same dataset?

Or should I make this report a template and create several copies of it with the same parameters?

There's so many AB Sets I'm interested in analyzing that I'm a little worried about overloading my BI Service with requests.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Elliot, 

 

It should be possible with the tables you use at the moment. 

 

The solution is something along the lines of your table formula. 

 

You will probably use a visual where data is grouped on 'Change Log Entry - Process Mining Entry'[Primary Key Field 2 Value]'

So the measure will use the 'Change Log Entry - Process Mining Entry'[Primary Key Field 2 Value]' as a filter. 

If you have some more representative data available I could have a look for you.

 

Jan