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!
Discussion posts and replies are publicly visible
There is no OOTB function to do that. You will need to implement the algorithm yourself.
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.
Were you able to achieve this?