Hi Appian folks,
Is it possible to split the data of a column and then perform aggregation over that data?
We have a requirement where we have to display data in both categories in a pie chart but on DB level, that data is multiple in nature, stored with a semicolon. The DB design is correct but aggregating it in a report has sort of became a blocker now.
Data for a row looks like:
Category
A;B;C
Pie charts have three categories: A, B & C
Discussion posts and replies are publicly visible
You can create an expression rule that will basically cast your CSV data in the specified format and then you can use that rule as the intermediate between your DB and piechart.