You are viewing limited content. For full access, please sign in.

Question

Question

How to best do aggregate reports using workflow web?

asked on September 16, 2014

Rather than reporting on a single process ID, is there a way to comparatively show a range of Process ID's? I thought I had seen this earlier, but I haven't been able to find specifics on it since.

Thanks! surprise

0 0

Replies

replied on September 17, 2014

Workflow Web only presents data per process. The data is available in the SQL database associated with Workflow in the BP tables, so aggregated reports can be made through SQL Reporting Services or other reporting tools.

 

What sort of reports are you looking for?

0 0
replied on September 18, 2014

Thanks Miruna.

 

In a perfect world, I'd be looking for comparative (process X vs Average or Min or Max) for a set duration applying to both processes.

 

So we'll do those through writing KPIs to external databases and using 3rd party tools to process those metrics. Just thought I'd check.

 

Thanks again.

0 0
replied on September 19, 2014

So you'd want that average/min/max to be across all processes or a user-defined set of processes rather than just the process itself?

0 0
replied on October 7, 2014

Sorry Miruna - just saw this reply from you. Thank you very much.

 

I'd be looking at a user-defined set of processes, ideally defined by a Laserfiche query.

Example: For all Processes of type = X, having Token1 value = Y and Token2 value is between 10 and 20... Return a list of the values for the token "Days Outstanding".

Then for that single token ("Days Outstanding"), but from the entire list of results, each of the MINIMUM, MAXIMUM or AVERAGE values in that resulting list. Those values get populated respectively into ResultSetMINIMUM, ResultSetMAXIMUM, ResultSetAVERAGE.

You can also provide a single process to be used for comparison, using the exact same token ("Days Outstanding") as SingleResult.

 

Then  present the results based on that single token value ("Days Outstanding") using 'SingleResult' versus the derived values for the ResultSet, using the MIN, MAX or AVERAGE for that same token ("Days Outstanding").

 

Process Token: "Days Outstanding".

SingleResult:       7

vs.

ResultSetMINIMUM:   3

ResultSetMAXIMUM:   8

ResultSetAVERAGE:   5

 

But now you have some more relevant comparative reporting for the Business Processes across the critical KPIs, using the built in basic graphical charting of Workflow Web's reporting.I hope that made more sense.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.