Line Chart Integration | Line Chart Implementation in Laravel | Learning Points

[@tiksong7613]

Thank you so much for your tutorial.

[@VipulPatel-mw4jj]

very Good sir video working sir thank you sir

[@HarshaBHerath]

very helfull. Thanks 😍

[@raymondfigoinuhan9504]

can you pls make a tutorials that show how to make full dashboard with many chart not only 1 page of chart this hard to make all chart in same view

[@vishalmohan1995]

Good tutorial!. I need assistance in creating a similar hourly chart . Instead of year along 'x' axis , I need hours ('0', '1', '2', ......'24') along x axis and count (autoscale) along 'y' axis. I have an sql record with column 'count' with data '1' getting added in a new row with timestamp for every count of data. so under column 'count', the data is (1,1,1,1,1,1....) with corresponding timestamp. I need to retrieve the sum of all these counts and display the current day data in a hourly chart with hours along 'x' axis and count along 'y' axis. Can you share a query and if possible a chart for this use case?

[@febyrasyadazola1489]

hello sir. I just follow your intruction. My database was exist in framework laravel , but when I run program to show up line chart, it nox available in framework. So in my framework just blank page.

[@LearningPointsCourses]

No. It should work. May be you did some errors. Have you go any error or checked in console section?

[@andresena777]

I need to put the months of the year in my chart, but when I try to put the values in the array it returns me this: Data column(s) for axis #0 cannot be of type string×, can you help me? i use laravel 5.6 and php 7.4.19

[@LearningPointsCourses]

No problem. It is not version related problem. Please print the data before passing into graph. If data is in proper format it will surely work.

[@andresena777]

@@LearningPointsCourses where exactly is this axis #0?

[@soufianch8481]

please send me your code for chart plzzz

[@LearningPointsCourses]

Currently I don't have that code. Sorry

[@abdulbaqibasit2244]

send me this query

[@LearningPointsCourses]

SELECT store_master.name,sum(sales_master.amount) as sales,sum(expense_master.amount) as expense,(sum(sales_master.amount)-sum(expense_master.amount)) as profit FROM `store_master` LEFT JOIN sales_master on sales_master.store_id = store_master.id LEFT JOIN expense_master on expense_master.store_id = store_master.id GROUP BY store_master.id

[@abdulbaqibasit2244]

@@LearningPointsCourses sir error a rha aik ....... SQLSTATE[42000]: Syntax error or access violation: 1055 'blog.store.name' isn't in GROUP BY (SQL: SELECT store.name,sum(sales.amount) as sales, sum(expense.amount) as expense,(sum(sales.amount)-sum(expense.amount)) as profit FROM `store` LEFT JOIN sales on sales.store_id= store.id LEFT JOIN expense on expense.store_id=store.id GROUP BY store.id)

[@abdulbaqibasit2244]

SQL ma query theek run kr rhi hai

[@LearningPointsCourses]

Video description box me facebook link diya hay.. message karo apka query