Skip to main content
Known Participant
Jan 23, 2024 10:25 AM UTC
Question

Transform data in Appian

Data I got from CDT
data=[date_month:1,templateId_count:3,templateName:Accident / Near Miss]; [date_month:1,templateId_count:22,templateName:DFTC Lousado]; [date_month:1,templateId_count:12,templateName:Duplicated items process]; [date_month:1,templateId_count:3,templateName:ESP Summary Report]; [date_month:1,templateId_count:2,templateName:Every Month]; \

Need to be transformed like

data= [date_month:1,"Accident / Near Miss":3,]; [date_month:1,"DFTC Lousado":22]; [date_month:1,"Duplicated items process":12]; [date_month:1,"ESP Summary Report":3]; [date_month:1,"Every Month":2];

or 

data= [date_month:1,"Accident / Near Miss":3,"DFTC Lousado":22,"Duplicated items process":12, "ESP Summary Report":3, ,"Every Month":2]

To use it in a stack chart plot date_month on the 'x' axis. How to achieve this?

4 replies

harshitb6843
Brainy
Jan 23, 2024 10:40 AM UTC

What chart are you using? You can directly use grouping on the chart level. 

Known Participant
Jan 23, 2024 11:08 AM UTC

"Column Chart"

harshitb6843
Brainy
Jan 23, 2024 11:16 AM UTC

And do you also have a record for this table with the sync enabled?

If yes, you can pass that record type directly in the chart and set the primary grouping on your 'date_month' field