Report with a variable number of columns

Kyle Jorgensen over 7 years ago

What would be the best approach to create a report with a variable number of columns?

I am creating a report that aggregates project cost data by customer and division that can be filtered by certain project attributes. I can create a DB view with a variable number of columns, but I'm not sure if Appian data types support a variable number of fields.

I've attached a mockup of what the base data looks like and what the report I am looking to create looks like.

Discussion posts and replies are publicly visible

Parents

0 Raviteja Varma Jampana
A Score Level 2
over 7 years ago

small correction use
local!divisions:union(fn!index(local!data,"divison",null),fn!index(local!data,"divison",null)),
local!costumers:(fn!index(local!data,"costumer",null),fn!index(local!data,"costumer",null)),
instead of
local!divisions:fn!index(local!data,"divison",null),
local!costumers:fn!index(local!data,"costumer",null),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Raviteja Varma Jampana
A Score Level 2
over 7 years ago

small correction use
local!divisions:union(fn!index(local!data,"divison",null),fn!index(local!data,"divison",null)),
local!costumers:(fn!index(local!data,"costumer",null),fn!index(local!data,"costumer",null)),
instead of
local!divisions:fn!index(local!data,"divison",null),
local!costumers:fn!index(local!data,"costumer",null),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data