I have to create a detailed dashboard/pivot on Nintex Workflow execution which can be analyzed and reported in Excel.
The built-in reports are not the ones I'm looking for... The business has pretty complex report needs.
- Custom NW run list items
- WFs are using state machines and Flexi tasks / Data requests inside
- Tasks are usually assigned to groups in which somebody has to delegate to herself
I need to report:
- Basic timestemps (using Workflow tasks list, WF history log list)
- Spent time on tasks (in working hours)
Did any of you have experience with it?
Solved! Go to Solution.
Hello Szabó Róbert -
I would take a look at the out-of-the-box reporting webparts and see what you can surface easily with them. You can use a Workflow Report Viewer and see expected duration, the number of instances, how many are in progress, run times (average, min/max), deviation.
I recommend using Expected Duration so that you can put actual results against business expectations. We have yet to do this only because our WFs all run quickly and are not running over long periods...yet !
You can also click into the specific workflow and see details for each action within the workflow.
If you have the time, check out my blog I did on this Leveraging Reporting Web Parts
Hope this helps!
After weeks of thinking on this issue I simplified my problem. Originally I planned to do it with Excel Power Pivot, but then I realized my solution is viable with simple excel features.
Additionally, sometimes we have repeating section data which is necessary for our reports. We wrote some Excel macros to extract the data in excel (one column to many columns).