Skip to main content
ashwini.nemade
ashwini.nemade
June 23, 2022
Question

Split the data in a column and aggregate on a pie chart

  • June 23, 2022
  • 1 reply
  • 0 views

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

1 reply

harshitb6843
harshitb6843
June 23, 2022

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. 

Terms & ConditionsAccessibility statement