Building on DDX bricks app

Can you give me an example of what you are saying above

do I change everything to single quotes? I started that way and then changed to back ticks when it didn't work

ticks with double quotes

like this?

var columns = ['RecordType','TimeSeriesShort','MOLongName',`"Account Level 9",`"VAR P-A (A)"`];

So this works and the field that has paren in the name, is working it seems like the issue is only because it's the where and groupby?

var domo = window.domo;

var datasets = window.datasets;

var myTable = document.getElementById('myTable');

var fields = ['TimeSeriesShort','VAR P-A (A)'];

const where = ['TimeSeriesShort = CM'];

var groupby = ['TimeSeriesShort'];

var query = `/data/v1/${datasets[0]}?fields=${fields.join()}&groupby=${groupby.join()}&filter=${where.join()}`;

further down in script

function getRow(rowData, index){ 

 var rowEl = document.createElement('tr');

 var td1 = rowEl.appendChild(document.createElement('td'));

 var td2 = rowEl.appendChild(document.createElement('td'));

 td1.innerText = rowData['TimeSeriesShort'];

 td2.innerText = rowData["VAR P-A (A)"]; this row works this or with 'VAR P-A (A)' the results are accurate both

 return rowEl;

This does not work, I have tried back ticks and single quotes and double quotes unsuccessfully

var domo = window.domo;

var datasets = window.datasets;

var myTable = document.getElementById('myTable');

var fields = ["Account Level 9 Code","VAR P-A (A)"];

const where = ["Account Level 9 Code = 600011"];

var groupby = ["Account Level 9 Code"];

var query = `/data/v1/${datasets[0]}?fields=${fields.join()}&groupby=${groupby.join()}&filter=${where.join()}`;

function getRow(rowData, index){  

 var rowEl = document.createElement('tr');

 var td1 = rowEl.appendChild(document.createElement('td'));

 var td2 = rowEl.appendChild(document.createElement('td'));

td1.innerText = rowData["Account Level 9 Code"];

 td2.innerText = rowData['VAR P-A (A)'];

  return rowEl;