This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Using column values with quickcharts

Posted on 07-12-2021 08:38 PM
Taylor_Felt
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

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”.
3X_e_c_ecf33225c12b603663911b4986fff6e1ba4fa6e3.png

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} } ] } }}"

0 6 202
Topic Labels
0 Likes
6 REPLIES 6
Top Labels in this Space