Hi - I am trying to get make a line graph to display a Weekly % over the selected week Period.
Using a calculated field which returns 0.78 or 1.34 etc and i change to a percentage. However I can’t get any data to display. Would someone mind having a look?
{
“chart”: { “type”: “line” },
“title”: { “text”: “Performance vs Target” },
“xAxis”: {
“categories”: [“getColumn”, 0],
“title”: { “text”: “Week” },
“labels”: { “rotation”: -45, “style”: { “fontSize”: “10px” } }
},
“yAxis”: {
“title”: { “text”: “Performance (%)” },
“min”: 0,
“max”: 200,
“tickInterval”: 25,
“plotLines”: [
{
“value”: 100,
“color”: “#FF0000”,
“dashStyle”: “dash”,
“width”: 2,
“label”: {
“text”: “Target: 100%”,
“align”: “right”,
“style”: { “color”: “#FF0000”, “fontWeight”: “bold” }
}
}
]
},
“tooltip”: {
“pointFormat”: “{point.y:.1f}%”,
“shared”: false
},
“plotOptions”: {
“line”: {
“dataLabels”: { “enabled”: false },
“enableMouseTracking”: true,
“marker”: { “enabled”: true, “radius”: 4 }
}
},
“series”: [
{
“name”: “Actual Performance”,
“data”: [
“map”,
[“getColumn”, 2],
[
“if”,
[“or”, [“isNull”, [“item”]], [“!=”, [“typeof”, [“item”]], “number”]],
null,
{
“y”: [““, [“item”], 100],
“color”: [
“case”,
[”>=“, [””, [“item”], 100], 100], “#50E287”,
[“>=”, [““, [“item”], 100], 80], “#FFA500*”,
“#FD554E”
],
“marker”: {
“fillColor”: [
“case”,
[”>=“, [”*”, [“item”], 100], 100], “#50E287”,
[“>=”, [“*”, [“item”], 100], 80], “#FFA500”,
“#FD554E”
]
}
}
]
],
“color”: “#4472C4”,
“lineWidth”: 3,
“marker”: { “radius”: 5, “lineWidth”: 2, “lineColor”: “#4472C4” }
}
],
“legend”: {
“enabled”: true,
“align”: “center”,
“verticalAlign”: “bottom”,
“layout”: “horizontal”
}
}