I get what you mean now.
You can continue on my suggestion to create a collection (colSelected) when checking the checkbox on the gallery then use this code for the Quickchart radar chart:
"https://quickchart.io/chart?c=" & EncodeUrl(
"{
type: 'radar',
data: {
labels: [
'Accommodation/Living Environment',
'Living Skills and Self Care',
'Mental Health and Wellbeing',
'Friends and Community',
'Relationships and Family',
'Drugs and Alcohol',
'Managing Feelings and Response',
'Positive Use of Time',
],
datasets: [
" & Concat(
ForAll(
colSelected As Item,
"{
backgroundColor: 'rgba(255, 255, 255, 0.5)',
borderColor: 'rgb(75, 192, 192,1)',
data: [" & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,Accomodation) & ", " & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,LivingSkills) & ", " & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,MentalHealth) & ", " & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,FriendsCommunity) & ", " & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,RelationshipsFamily) & ", " & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,DrugsAlcohol) & ", " & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,ManagingFeelings) & ", " & LookUp(CriminalJusticeWeb,Date=Item.Date && YPID=ViewYPSelect_10.Selected.YPID,PositiveUseTime) & "],
label: '" & Item.Date &"',
}"
),
Value,
","
) & "
],
},
options: {
spanGaps: false,
elements: {
line: {
tension: 0.000001,
},
},
scale: {
ticks: {
min: 0,
max: 5,
stepSize: 1,
},
}
},
}
"
)
With this code, Concat() function will concatenate all the selected records with the properties needed for the radar chart. However, it won't give a varying colors on the chart.
Note that I declared the colSelected collection as "Item" in the ForAll() function and I only change the requirements on the LookUp() function with "Gallery.Selected.Date" to "Item.Date", I'm not sure if "ViewYPSelect_10.Selected.YPID" is from the gallery too but if it is you can just change it to "Item.YPID" too.
Hopefully this answers your question.
