var express = require('express');
var app = express();
var path = require("path");
var mysql = require('mysql');

app.use(express.static(path.join(__dirname,'public')));
app.set('views',__dirname + '/views');
app.set('view engine', 'ejs');

app.listen(3000, function(){
  console.log("connected to the server");
});

app.get("/test",function(request,response){
  var connection = mysql.createConnection({
    host : '', //I have blinded personal info here
    user : '',
    password : '',
    database : '',
    port : '',
    multipleStatements: true
  });
  connection.connect(function(err){
    if(!err) {
      console.log("Database is connected ... nn");
    } else {
      console.log("Error connecting database ... nn");
    }
  });

  var queryS= 'SELECT active_program, SUM(activated_time) AS sumTime
               FROM program_detail_logs
               GROUP BY active_program
               ORDER BY sumTime DESC; SELECT created_at FROM program_detail_logs';

  connection.query(queryS, function(err, rows, fields) {
   if (!err){
      response.render('test', {data: rows[0], data2: rows[1]});
   }
   else{
     console.log('Error while performing Query.');
   }
   connection.end();
   });
});

<canvas id="myChart" width="400" height="400"></canvas> //html part, where chart goes

                    <script>
                    var progName = [];
                    progName = <%=data.active_program%>

                    var ctx = document.getElementById("myChart").getContext('2d');
                    var myChart = new Chart(ctx, {
                      type: 'bar',
                      data: {
                        labels: progName,
                        datasets: [{
                          label: 'Usage time',
                          data: [1000, 2000],
                          backgroundColor: [
                            'rgba(255, 99, 132, 0.2)',
                            'rgba(54, 162, 235, 0.2)',
                            'rgba(255, 206, 86, 0.2)',
                            'rgba(75, 192, 192, 0.2)',
                            'rgba(153, 102, 255, 0.2)',
                            'rgba(255, 159, 64, 0.2)'
                          ],
                          borderColor: [
                            'rgba(255,99,132,1)',
                            'rgba(54, 162, 235, 1)',
                            'rgba(255, 206, 86, 1)',
                            'rgba(75, 192, 192, 1)',
                            'rgba(153, 102, 255, 1)',
                            'rgba(255, 159, 64, 1)'
                          ],
                          borderWidth: 1
                        }]
                      },
                      options: {
                        scales: {
                          yAxes: [{
                            ticks: {
                              beginAtZero:true
                            }
                          }]
                        }
                      }
                    });
                  </script>