Pivot Data from/In Expression Rule

Question

Hello!We are attempting to create a read only grid which will allow the users to export to excel (so data must be a record type) to filter the relevant data into groupings we have an expression rule however the outputs will need to be pivoted to display in a way that is readable/logical on the grid
Data from rule example-raisedBy: Username1Status: CompleteCount item: 2Level:1raisedBy: Username 1Status: CompleteCount item: 3Level: 2We would want to display this data pivioted i.e.  RaisedBy                                 Status                             Level:1              Level: 2Username1                              Complete                           2                        3Currently we can only display this data as shown belowRaisedBy                                Status                               Level: 1               Level:2Username 1                            Complete                                5                      5 Username 1                            Complete                                5                      5I cannot find information on how to pivot data in Appian is this perhaps called something else?  Is there a way to achieve this in Appian any help would be appreciated!Thank you!

stefanhelzle0001 · Accepted Answer

There is no OOTB function to do that. You will need to implement the algorithm yourself.

mikes0011 · Answer

Please share the code by which you're currently attempting this logic which is generating your "incorrect" results.  Hopefully an environment-agnostic code sample (with all local variables and no custom rules/constants inherent to your environment), so others here can copy/paste it into an expression or interface designer and try it ourselves.

Sign up

Login with SSO

Login to the community

Login with SSO