{"type":"doc","content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}],"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"button-handy","parameters":{"macroParams":{"blank":{"value":"true"},"color":{"value":"#0052CC"},"name":{"value":"Send Feedback"},"link":{"value":"https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=Chart+from+JSON+-+15482164"},"width":{"value":"auto"}},"macroMetadata":{"macroId":{"value":"31e39003-0ff6-49fc-b532-ab48c3e80aa6"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://handy-macros.stiltsoft.net/img/macros/handy-button.svg"}}],"title":"Handy Button"}}}}]},{"type":"paragraph","content":[{"text":"In order to generate a chart report from a JSON file you have to :","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Write the JSON file with the chart configuration.","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

{
    "type": "line",
    "data": {
        "datasets": [{
            "data": [20, 50, 100, 75, 25, 0],
            "label": "Left dataset",
            "fill" : true,
            "backgroundColor" : "rgba(66, 182, 244, 0.2)",
            "borderColor" : "#42b6f4",
            "yAxisID": "left-y-axis"
        }, {
            "data": [0.1, 0.5, 1.0, 2.0, 1.5, 0],
            "label": "Right dataset",
            "fill" : true,
            "backgroundColor" : "rgba(244, 65, 86, 0.2)",
            "borderColor" : "#f44156",
            "yAxisID": "right-y-axis"
        }],
        "labels": ["Jan", "Feb", "Mar", "Apr", "May", "Jun"]
    },
    "options": {
        "scales": {
            "yAxes": [{
                "id": "left-y-axis",
                "type": "linear",
                "position": "left"
            }, {
                "id": "right-y-axis",
                "type": "linear",
                "position": "right"
            }]
        }
    }
}

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"{","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"type\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"line\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"data\"","type":"text","marks":[{"type":"code"}]},{"text":": {","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"datasets\"","type":"text","marks":[{"type":"code"}]},{"text":": [{","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"data\"","type":"text","marks":[{"type":"code"}]},{"text":": [","type":"text","marks":[{"type":"code"}]},{"text":"20","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"50","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"100","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"75","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"25","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"0","type":"text","marks":[{"type":"code"}]},{"text":"],","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"label\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"Left dataset\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"fill\"","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"backgroundColor\"","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"rgba(66, 182, 244, 0.2)\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"borderColor\"","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"#42b6f4\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"yAxisID\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"left-y-axis\"","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"}, {","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"data\"","type":"text","marks":[{"type":"code"}]},{"text":": [","type":"text","marks":[{"type":"code"}]},{"text":"0.1","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"0.5","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"1.0","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"2.0","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"1.5","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"0","type":"text","marks":[{"type":"code"}]},{"text":"],","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"label\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"Right dataset\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"fill\"","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"backgroundColor\"","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"rgba(244, 65, 86, 0.2)\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"borderColor\"","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"#f44156\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"yAxisID\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"right-y-axis\"","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"}],","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"labels\"","type":"text","marks":[{"type":"code"}]},{"text":": [","type":"text","marks":[{"type":"code"}]},{"text":"\"Jan\"","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"\"Feb\"","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"\"Mar\"","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"\"Apr\"","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"\"May\"","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"code"}]},{"text":"\"Jun\"","type":"text","marks":[{"type":"code"}]},{"text":"]","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"},","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"options\"","type":"text","marks":[{"type":"code"}]},{"text":": {","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"scales\"","type":"text","marks":[{"type":"code"}]},{"text":": {","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"yAxes\"","type":"text","marks":[{"type":"code"}]},{"text":": [{","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"id\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"left-y-axis\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"type\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"linear\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"position\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"left\"","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"}, {","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"id\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"right-y-axis\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"type\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"linear\"","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"\"position\"","type":"text","marks":[{"type":"code"}]},{"text":": ","type":"text","marks":[{"type":"code"}]},{"text":"\"right\"","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"}]","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"}","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text","marks":[{"type":"code"}]},{"text":"}","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"}","type":"text","marks":[{"type":"code"}]}]}]}]}]}],"version":1},"reason":"A table in list item can't be created or edited in the new editor."}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Write the SIL script which reads the JSON file.","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

string json = readFromTextFile("multipleAxes.json");
SILReportingChart chart = fromJson(json);

return chart;

Chart from JSON