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?
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.
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
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
@@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)
Thank you so much for your tutorial.
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?
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
very Good sir video working sir thank you sir
very helfull. Thanks 😍
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.
No. It should work. May be you did some errors. Have you go any error or checked in console section?
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
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.
@@LearningPointsCourses where exactly is this axis #0?
please send me your code for chart plzzz
Currently I don't have that code. Sorry
send me this query
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
@@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)
SQL ma query theek run kr rhi hai
Video description box me facebook link diya hay.. message karo apka query