Skip to main content
January 23, 2024
Question

Transform data in Appian

  • January 23, 2024
  • 4 replies
  • 0 views

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
January 23, 2024

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

January 23, 2024

"Column Chart"

harshitb6843
January 23, 2024

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