Quick chart error

AppSheet AppSheet Q&A
, , , ,
1

I want to make a chart with the help of quick chart but I am unable to correct the error. Can anyone help me in this case. Please tell me what is the error.

"https://quickchart.io/chart?c="&ENCODEURL(CONCATENATE('
{
  "type": "outlabeledPie",
  "data": {
    "labels": [','"', SUBSTITUTE(SELECT(Photos[Channel], AND([Date] = TODAY(), true), ",", '","'),'"','],
    "datasets": [{
      "backgroundColor": ["#FF3784", "#36A2EB", "#4BC0C0", "#F77825",
      "#9966FF"],
      "data": [',SELECT(Photos[Pair Qty], AND([Date] = TODAY(), true),']
    }]
  },
  "options": {
    "plugins": {
      "legend": false,
      "outlabels": {
        "text": "%l %p",
        "color": "white",
        "stretch": 35,
        "font": {
          "resizable": true,
          "minSize": 12,
          "maxSize": 18
        }
      }
    }
  }
}

Showing error:-

Expression '"https://quickchart.io/chart?c="&ENCODEURL(CONCATENATE(' { "type": "outlabeledPie", "data": { "labels": [','"', SUBSTITUTE(SELECT(Photos[Channel], AND([Date] = TODAY(), true), ",", '","'),'"','], "datasets": [{ "backgroundColor": ["#FF3784", "#36A2EB", "#4BC0C0", "#F77825", "#9966FF"], "data": [',SELECT(Photos[Pair Qty], AND([Date] = TODAY(), true),'] }] }, "options": { "plugins": { "legend": false, "outlabels": { "text": "%l %p", ...' was unable to be parsed: Number of opened and closed parentheses does not match.
2

The error message states very clearly that you don’t have the correct number of open and/or close parentheses. Inspect your expression very carefully and make sure you have closing parentheses for each open parentheses.

1 Like