LinkedIn
Twitter
Can someone help me add a date column into my quickcharts title? I can’t seem to get the concatenate() formula quite right with the quickcharts link.
This is what my chart looks like now, I want to have the column value of the date replace “Daily Energy Mix”.
Here is the quickcharts code… I know it’s long, the part I’m having trouble with is in bold towards the end. I’d really appreciate some help.
"https://quickchart.io/chart?c={ type: 'line', data: { labels: [ '12:00 AM', '12:15 AM', '12:30 AM', '12:45 AM', '1:00 AM', '1:15 AM', '1:30 AM', '1:45 AM', '2:00 AM', '2:15 AM', '2:30 AM', '2:45 AM', '3:00 AM', '3:15 AM', '3:30 AM', '3:45 AM', '4:00 AM', '4:15 AM', '4:30 AM', '4:45 AM', '5:00 AM', '5:15 AM', '5:30 AM', '5:45 AM', '6:00 AM', '6:15 AM', '6:30 AM', '6:45 AM', '7:00 AM', '7:15 AM', '7:30 AM', '7:45 AM', '8:00 AM', '8:15 AM', '8:30 AM', '8:45 AM', '9:00 AM', '9:15 AM', '9:30 AM', '9:45 AM', '10:00 AM', '10:15 AM', '10:30 AM', '10:45 AM', '11:00 AM', '11:15 AM', '11:30 AM', '11:45 AM', '12:00 PM', '12:15 PM', '12:30 PM', '12:45 PM', '1:00 PM', '1:15 PM', '1:30 PM', '1:45 PM', '2:00 PM', '2:15 PM', '2:30 PM', '2:45 PM', '3:00 PM', '3:15 PM', '3:30 PM', '3:45 PM', '4:00 PM', '4:15 PM', '4:30 PM', '4:45 PM', '5:00 PM', '5:15 PM', '5:30 PM', '5:45 PM', '6:00 PM', '6:15 PM', '6:30 PM', '6:45 PM', '7:00 PM', '7:15 PM', '7:30 PM', '7:45 PM', '8:00 PM', '8:15 PM', '8:30 PM', '8:45 PM', '9:00 PM', '9:15 PM', '9:30 PM', '9:45 PM', '10:00 PM', '10:15 PM', '10:30 PM', '10:45 PM', '11:00 PM', '11:15 PM', '11:30 PM', '11:45 PM'], datasets: [ { label: 'Production', backgroundColor: 'rgba(145, 170, 138, .75)', borderColor: 'rgb(145, 170, 138)', borderWidth: 3, pointRadius: 0, data:["&[Daily Production Ref].[0:00]&","&[Daily Production Ref].[0:15]&","&[Daily Production Ref].[0:30]&","&[Daily Production Ref].[0:45]&","&[Daily Production Ref].[1:00]&","&[Daily Production Ref].[1:15]&","&[Daily Production Ref].[1:30]&","&[Daily Production Ref].[1:45]&","&[Daily Production Ref].[2:00]&","&[Daily Production Ref].[2:15]&","&[Daily Production Ref].[2:30]&","&[Daily Production Ref].[2:45]&","&[Daily Production Ref].[3:00]&","&[Daily Production Ref].[3:15]&","&[Daily Production Ref].[3:30]&","&[Daily Production Ref].[3:45]&","&[Daily Production Ref].[4:00]&","&[Daily Production Ref].[4:15]&","&[Daily Production Ref].[4:30]&","&[Daily Production Ref].[4:45]&","&[Daily Production Ref].[5:00]&","&[Daily Production Ref].[5:15]&","&[Daily Production Ref].[5:30]&","&[Daily Production Ref].[5:45]&","&[Daily Production Ref].[6:00]&","&[Daily Production Ref].[6:15]&","&[Daily Production Ref].[6:30]&","&[Daily Production Ref].[6:45]&","&[Daily Production Ref].[7:00]&","&[Daily Production Ref].[7:15]&","&[Daily Production Ref].[7:30]&","&[Daily Production Ref].[7:45]&","&[Daily Production Ref].[8:00]&","&[Daily Production Ref].[8:15]&","&[Daily Production Ref].[8:30]&","&[Daily Production Ref].[8:45]&","&[Daily Production Ref].[9:00]&","&[Daily Production Ref].[9:15]&","&[Daily Production Ref].[9:30]&","&[Daily Production Ref].[9:45]&","&[Daily Production Ref].[10:00]&","&[Daily Production Ref].[10:15]&","&[Daily Production Ref].[10:30]&","&[Daily Production Ref].[10:45]&","&[Daily Production Ref].[11:00]&","&[Daily Production Ref].[11:15]&","&[Daily Production Ref].[11:30]&","&[Daily Production Ref].[11:45]&","&[Daily Production Ref].[12:00]&","&[Daily Production Ref].[12:15]&","&[Daily Production Ref].[12:30]&","&[Daily Production Ref].[12:45]&","&[Daily Production Ref].[13:00]&","&[Daily Production Ref].[13:15]&","&[Daily Production Ref].[13:30]&","&[Daily Production Ref].[13:45]&","&[Daily Production Ref].[14:00]&","&[Daily Production Ref].[14:15]&","&[Daily Production Ref].[14:30]&","&[Daily Production Ref].[14:45]&","&[Daily Production Ref].[15:00]&","&[Daily Production Ref].[15:15]&","&[Daily Production Ref].[15:30]&","&[Daily Production Ref].[15:45]&","&[Daily Production Ref].[16:00]&","&[Daily Production Ref].[16:15]&","&[Daily Production Ref].[16:30]&","&[Daily Production Ref].[16:45]&","&[Daily Production Ref].[17:00]&","&[Daily Production Ref].[17:15]&","&[Daily Production Ref].[17:30]&","&[Daily Production Ref].[17:45]&","&[Daily Production Ref].[18:00]&","&[Daily Production Ref].[18:15]&","&[Daily Production Ref].[18:30]&","&[Daily Production Ref].[18:45]&","&[Daily Production Ref].[19:00]&","&[Daily Production Ref].[19:15]&","&[Daily Production Ref].[19:30]&","&[Daily Production Ref].[19:45]&","&[Daily Production Ref].[20:00]&","&[Daily Production Ref].[20:15]&","&[Daily Production Ref].[20:30]&","&[Daily Production Ref].[20:45]&","&[Daily Production Ref].[21:00]&","&[Daily Production Ref].[21:15]&","&[Daily Production Ref].[21:30]&","&[Daily Production Ref].[21:45]&","&[Daily Production Ref].[22:00]&","&[Daily Production Ref].[22:15]&","&[Daily Production Ref].[22:30]&","&[Daily Production Ref].[22:45]&","&[Daily Production Ref].[23:00]&","&[Daily Production Ref].[23:15]&","&[Daily Production Ref].[23:30]&","&[Daily Production Ref].[23:45]&"] }, { label: 'Consumption', backgroundColor: 'rgba(136, 168, 191, .75)', borderColor: 'rgb(136, 168, 191)', borderWidth: 3, pointRadius: 0, data:["&[Daily Consumption Ref].[0:00]&","&[Daily Consumption Ref].[0:15]&","&[Daily Consumption Ref].[0:30]&","&[Daily Consumption Ref].[0:45]&","&[Daily Consumption Ref].[1:00]&","&[Daily Consumption Ref].[1:15]&","&[Daily Consumption Ref].[1:30]&","&[Daily Consumption Ref].[1:45]&","&[Daily Consumption Ref].[2:00]&","&[Daily Consumption Ref].[2:15]&","&[Daily Consumption Ref].[2:30]&","&[Daily Consumption Ref].[2:45]&","&[Daily Consumption Ref].[3:00]&","&[Daily Consumption Ref].[3:15]&","&[Daily Consumption Ref].[3:30]&","&[Daily Consumption Ref].[3:45]&","&[Daily Consumption Ref].[4:00]&","&[Daily Consumption Ref].[4:15]&","&[Daily Consumption Ref].[4:30]&","&[Daily Consumption Ref].[4:45]&","&[Daily Consumption Ref].[5:00]&","&[Daily Consumption Ref].[5:15]&","&[Daily Consumption Ref].[5:30]&","&[Daily Consumption Ref].[5:45]&","&[Daily Consumption Ref].[6:00]&","&[Daily Consumption Ref].[6:15]&","&[Daily Consumption Ref].[6:30]&","&[Daily Consumption Ref].[6:45]&","&[Daily Consumption Ref].[7:00]&","&[Daily Consumption Ref].[7:15]&","&[Daily Consumption Ref].[7:30]&","&[Daily Consumption Ref].[7:45]&","&[Daily Consumption Ref].[8:00]&","&[Daily Consumption Ref].[8:15]&","&[Daily Consumption Ref].[8:30]&","&[Daily Consumption Ref].[8:45]&","&[Daily Consumption Ref].[9:00]&","&[Daily Consumption Ref].[9:15]&","&[Daily Consumption Ref].[9:30]&","&[Daily Consumption Ref].[9:45]&","&[Daily Consumption Ref].[10:00]&","&[Daily Consumption Ref].[10:15]&","&[Daily Consumption Ref].[10:30]&","&[Daily Consumption Ref].[10:45]&","&[Daily Consumption Ref].[11:00]&","&[Daily Consumption Ref].[11:15]&","&[Daily Consumption Ref].[11:30]&","&[Daily Consumption Ref].[11:45]&","&[Daily Consumption Ref].[12:00]&","&[Daily Consumption Ref].[12:15]&","&[Daily Consumption Ref].[12:30]&","&[Daily Consumption Ref].[12:45]&","&[Daily Consumption Ref].[13:00]&","&[Daily Consumption Ref].[13:15]&","&[Daily Consumption Ref].[13:30]&","&[Daily Consumption Ref].[13:45]&","&[Daily Consumption Ref].[14:00]&","&[Daily Consumption Ref].[14:15]&","&[Daily Consumption Ref].[14:30]&","&[Daily Consumption Ref].[14:45]&","&[Daily Consumption Ref].[15:00]&","&[Daily Consumption Ref].[15:15]&","&[Daily Consumption Ref].[15:30]&","&[Daily Consumption Ref].[15:45]&","&[Daily Consumption Ref].[16:00]&","&[Daily Consumption Ref].[16:15]&","&[Daily Consumption Ref].[16:30]&","&[Daily Consumption Ref].[16:45]&","&[Daily Consumption Ref].[17:00]&","&[Daily Consumption Ref].[17:15]&","&[Daily Consumption Ref].[17:30]&","&[Daily Consumption Ref].[17:45]&","&[Daily Consumption Ref].[18:00]&","&[Daily Consumption Ref].[18:15]&","&[Daily Consumption Ref].[18:30]&","&[Daily Consumption Ref].[18:45]&","&[Daily Consumption Ref].[19:00]&","&[Daily Consumption Ref].[19:15]&","&[Daily Consumption Ref].[19:30]&","&[Daily Consumption Ref].[19:45]&","&[Daily Consumption Ref].[20:00]&","&[Daily Consumption Ref].[20:15]&","&[Daily Consumption Ref].[20:30]&","&[Daily Consumption Ref].[20:45]&","&[Daily Consumption Ref].[21:00]&","&[Daily Consumption Ref].[21:15]&","&[Daily Consumption Ref].[21:30]&","&[Daily Consumption Ref].[21:45]&","&[Daily Consumption Ref].[22:00]&","&[Daily Consumption Ref].[22:15]&","&[Daily Consumption Ref].[22:30]&","&[Daily Consumption Ref].[22:45]&","&[Daily Consumption Ref].[23:00]&","&[Daily Consumption Ref].[23:15]&","&[Daily Consumption Ref].[23:30]&","&[Daily Consumption Ref].[23:45]&"] } ] }, options: {legend: { position: 'bottom' },**title: { display: true,fontSize:25, text: 'Daily Energy Mix'** },scales: { xAxes: [{scaleLabel: {display: false, labelString: 'Month'}}], yAxes: [ { id: 'y1', display: true, position: 'left', stacked: false, scaleLabel: {display: true, labelString: 'Energy (kWh)'}}, { id: 'y2', display: false, position: 'right', scaleLabel: {display: true, labelString: 'Performance Index ％'}, gridLines: { drawOnChartArea: false} } ] } }}"
