164972 - no subject - hi all,\n\nI am trying to create a repo

eaglez over 8 years ago

hi all,

I am trying to create a report that shows the number, region and status of all current processes.
like the attached picture, all processes are group by the regions, different colors are referring to different status.

the second attached picture is my current design for this report. as you see, i hard-code each status as one column.

what i want to ask is: is there a way to dynamically pull the status list out and make each as column?

Discussion posts and replies are publicly visible

0 eaglez over 8 years ago

current design fo the report
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rajivr
Certified Associate Developer
over 8 years ago

Hi eaglez,
There is another way if you want to achieve it dynamically.
In appian we have a smart service called 'EXECUTE PROCESS REPORT' under ANALYTICS category.
In that, under SETUP tab, you can specify your task report name. After u give your report name, automatically one more section in the bottom gets populated which is called as ADDITIONAL FILTER section, where you can dynamically give your status(not only that, other params also) by using a PV variable.
I guess, the above functionality can also be achieved using the function "a!queryProcessAnalytics( check params here for specifying ur cond )".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel