Summary Table Visual JSON Script not working

[Anonymous]

hi,

I'm trying to make a summary table visual look like this first image, but I keep getting this error and nothing displays on the table. Can you please help..    below is my script which is valid but still doesnt' display anything on my table when I click save

{
"columns": [

{
"headerStyle": "border-bottom:1px; border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "text-align:left",
"width": 150,
"type": "RowHeader",
"refName": "[Active Projects - 14]",
"title": "",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Project Size]",
"title": "Project Size",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Project Division]",
"title": "Project Division",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Project Type]",
"title": "Project Type",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Contract Type]",
"title": "Contract Type",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Award Date]",
"title": "Award Date",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Forecast Completion]",
"title": "Forecast Completion",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Duration]",
"title": "Duration",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Project % Complete]",
"title": "Project % Complete",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Computer Users]",
"title": "Computer Users",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Craft]",
"title": "Craft",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Tickets To-Date]",
"title": "Tickets To-Date",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "['AS Sold' Project Cost]",
"title": "'AS Sold' Project Cost",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[% of'As Sold' Contract]",
"title": "% of'As Sold' Contract",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Current IT Spend of all Projects]",
"title": "Current IT Spend of all Projects",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[% Spent]",
"title": "% Spent",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Next Month Forecast(no labor)]",
"title": "Next Month Forecast(no labor)",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Annual Forecast]",
"title": "Annual Forecast",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Project IT Budgets]",
"title": "Project IT Budgets",
"calculationFormula": "",
"format": ""
},
{
"headerStyle": "border-bottom:1px;border-bottom-color:#eee;border-bottom-style:solid",
"rowStyle": "",
"width": 150,
"type": "Data",
"refName": "[Project IT Staff]",
"title": "Project IT Staff",
"calculationFormula": "",
"format": ""
}
],
"rows": [

{
"title": "null",
"formula": "[null]",
"rowStyle": "",
"visible": true,
"cellRowHeaderStyle": "",
"cellRowDataStyle": ""
},
{
"title": "Borstar Bay 3",
"formula": "[Borstar Bay 3]",
"rowStyle": "",
"visible": true,
"cellRowHeaderStyle": "",
"cellRowDataStyle": ""
},
{
"title": "Calpine",
"formula": "[Calpine]",
"rowStyle": "",
"visible": true,
"cellRowHeaderStyle": "",
"cellRowDataStyle": ""
},
{
"title": "Cameron LNG",
"formula": "[Cameron LNG]",
"rowStyle": "",
"visible": true,
"cellRowHeaderStyle": "",
"cellRowDataStyle": ""
},
{
"title": "Duke",
"formula": "[Duke]",
"rowStyle": "",
"visible": true,
"cellRowHeaderStyle": "",
"cellRowDataStyle": ""
},
{
"title": "Freeport LNG",
"formula": "[Freeport LNG]",
"rowStyle": "",
"visible": true,
"cellRowHeaderStyle": "",
"cellRowDataStyle": ""
},
{
"title": "Golden Pass LNG",
"formula": "[Golden Pass LNG]",
"rowStyle": "",
"visible": true,
"cellRowHeaderStyle": "",
"cellRowDataStyle": ""
}
],
"headerRow": {
"rowStyle": ""
},
"displayAllRows": false
}

how it should look (not the same numbers or fields)JSON Error and my data

[v-shex-msft]

Hi @Anonymous ,

It seems like you are use a third party custom visual, I'd like to suggest you contact to visual author to get better support for that custom visual.

Regards,

Xiaoxin Sheng