We are creating our own K2 Performance Power BI Report. We are using K2’s Power BI report as a template.
At a high level, I am currently trying to put together a line chart displaying workflow errors. However, I am having a problem trying to obtain the Error Date of a Process Instance.
It is displayed within K2 Management:
However I cannot identify the field within any of K2’s built-in Workflow Analytic SmartObjects:
I come across is the finish date field, but this is only set when a Process has a status of Completed or Deleted.
What I need is simply the error date for all Processes with a status of Error.
If anyone has could help, that would be great.
Best answer by ConradMc
Update: I worked out how to do this in the end. I will share incase anyone else interested.
At a very high level,
- Filter on the following:
- Activity Instance table: Status is Completed
- Process Instance table: Status is Error or Stopped
- Then the error date is:
- Activity Instance table: Finished Date