Need Help Quickchart Label and database

[Sirfyaad]

I want to create a chart, just like the one shown in the image. Exactly the same. But when I use the expressions provided below, the [channel] label shows incorrectly. Can you tell me what mistake I am making? I want the label to be created for the row data where [LOT STATUS] = "OPEN", and the percentage should be shown accordingly.

I WANT THIS

"https://quickchart.io/chart?c=" & ENCODEURL(
  CONCATENATE(
    '
    {
      "type": "outlabeledPie",
      "data": {
        "labels": [', '"', SUBSTITUTE(SELECT(PHOTOS[CHANNEL], AND([LOT STATUS] = "OPEN"), true)), ",", '","'), '"', '],
        "datasets": [{
          "backgroundColor": ["#FF3784", "#36A2EB", "#4BC0C0", "#F77825", "#9966FF","#EAA81B","#5D7612","#4B167A","#AD1B8C","#AD1B4E","#5A132C","#B9293F","#2D0C47","#B37BC1","#4DA973"],
          "data": [', SELECT(PHOTOS[QUANTITY], AND([LOT STATUS] = "OPEN"), true)), ']
        }]
      },
      "options": {
        "plugins": {
          "legend": false,
          "outlabels": {
            "text": "%l %p",
            "color": "white",
            "stretch": 35,
            "font": {
              "resizable": true,
              "minSize": 12,
              "maxSize": 18
            }
          }
        }
      }
    }
    '
  )
)