Python Flask Dashboard: Plotting Dashboard Graphs Using Chart.js

In this Python Flask Tutorial, we will be learning to query the our model and obtain with which we'll plot the graphs in the dashboard using chartjs, a JavaScript library. We'll use HTML, CSS and bootstrap along side Python as usual. We'll learn how to query an SQL lite database in Flask and loop through the result of the queries. Lets get started....

#Python #Flask #Flaskslqalchemy #FlaskDatabase #FlaskModels #Chartjs #JavaScript

👉 Subscribe to our channel
👉 Share to your friends
👉 Like our videos 👍
👉 Click the notification bell for more such content🖐🔔

Please like, share and subscribe to this channel for more of such videos

[thomasfrissen-um]

This was a great tutorial series. Followed all vids from the beginning.

One comment though on this video. The reason why the grid didn't work is not (only because of the CDNs), but mainly because the layout.html file on your GitHub includes a closing </div>-statement on line 45 (behind <div class="col-md-10">). In the video tutorial you don't write this closing div-statement and rely on the closing div on line 56 (see for example 30:43). I just added the </div> on line 45 and it worked. Actually the </div> on line 56 becomes redundant.

[mbogitechconpts]

You deserved it and I have subscribed. That was brilliant.

[jimbob]

Nice to see a fellow Linux user, what distro do you run? You should checkout the tiling window managers like bspwm or i3

[lawalsontomiwa]

Great series you got yourself a subscriber .... but I have a question, how do you go about this process if you have CSV FILE you want to make visualization of, I will appreciate your feedback

[pbdev]

Hi, very nice tutorial. Can you please specify or explain what is required for more than one chart to be side by side with others, instead of one on top of the other? Thanks!

[SP-dbsh]

Make a fast api version !
Thank you sir !

[existingstars]

I should create a data visualization dashboard using react as Front-end flash as backend. I should also include this chart .js in visual studio code were can i download it

[r]

Hi, Thank you for such a wonderful video tutorial. Can you please tell me, how can create charts(bar/pie) with json data file which is there in my local computer.
Thanks.

[chlo]

Hi ! your tutorial was such a great help for me :) Could u help me with my problem? My database has a user list and i am trying to make a chart for user signups in a year, what query function should i use? 13:44 i have used strftime for date created for accounts as well Thank you!

[marwamoner]

Hi, thank you for the tutorial can you help me with my flask app, I created it an app which pull the data from mysql and download it from the pressing bottom in my website, I used Xlswriter and I plotted some charts into excel, created some extra columns, can you help me to draw some of these columns data into the website, when the user click on the download bottom, it will download the excel sheet and at the same time draw charts of some columns in the left side of my flask webpage app.

[abc_cba]

Hi, Prince, How can
1) I add timestamps to the "expenditure over time" chart, your chart does display the dates, but what if one wants to add the timestamps or time at which all that happened ? and
2) also to it add a button at the bottom to filter dates just to show specific dates from so(start date) and so(end date), been trying all the logic, can you provide the code for that ? My brain has been blasting off. Please, help

[poojayu]

Where is the chart.html file in tge git u have posted very short codes in the github link

[rochyneterrible]

good afternoon sir.
i have a query sir error during db.create_all()
how can i solve it sir?
thank you for your response

[mbogitechconpts]

Hi, the chart.html file is not found on your github repository, do you want to add it please?

[kazdaadrian]

Spent more than 3 hours trying to debug your charts

[HarshSharma-wvgi]

can I upload the transaction through Excel File ? Please tell me how?

[lorenzomalla]

How can i count same date in line chart thankyou

[abc_cba]

Hi, do you have a paypal account ? I just made a project using your tutorial, I want to contribute to your channel.

[edbull]

Poor . No preparation whatsoever. Goes from one error to another. Could be done in 10 minutes but takes 35 minutes.