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