237
Hi All,
Is it possible to put in a collection a gallery whose values are like so:
| Week Number | Completion Rate |
| 12 | 40 |
| 13 | 75 |
| 14 | 75 |
| 15 | 75 |
into:
| Week 12 | Week 13 | Week 14 | Week 15 |
| 40 | 75 | 75 | 75 |
-bochie
Hi @Bochie ,
The canvas app doesn't have OOB functions to transpose tables, so you'll need some hardcoding:
I've made a test for your reference, I assume there is a collection:
Share
Report
All responses (
Answers (
ClearCollect(
TheCollection,
{'Week Number':12,'Completion Rate':40},
{'Week Number':13,'Completion Rate':75},
{'Week Number':14,'Completion Rate':75},
{'Week Number':15,'Completion Rate':75}
);You could try:
[
{
'Week 12':LookUp(TheCollection,'Week Number'=12).'Completion Rate',
'Week 13':LookUp(TheCollection,'Week Number'=13).'Completion Rate',
'Week 14':LookUp(TheCollection,'Week Number'=14).'Completion Rate',
'Week 15':LookUp(TheCollection,'Week Number'=15).'Completion Rate'
}
]
Best Regards,
Bof
