We have built a reporting framework that allows customers to customize columns and filters to generate a custom report. The customer is asking for more flexible filtering, including defining operators between filters and grouping filters, basically a UI for building logical expressions. Furthermore, the customer has more complex reporting requirements such as generating reports with dynamic columns, based on selected filters.
We have a potential solution for the flexible filtering requirement, but we have performance concerns as our current filter framework uses nested CDTs Are there any existing solutions or examples of report builders / query builders in Appian? Also, what is Appian's recommendation for handling complex reporting / data analysis?
Thank You
Discussion posts and replies are publicly visible
Have you taken a look at Self Service analytics?
docs.appian.com/.../allow-users-to-build-reports.html
Thank you for the suggestion Mathieu. I looked into Self Service analytics, and it looks to be similar to how our current column and filter (all filters are separated by an "and" operator) selections are set up.