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
@vishalmohan19952 жыл бұрын
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?
@febyrasyadazola14892 жыл бұрын
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.
@LearningPointsCourses2 жыл бұрын
No. It should work. May be you did some errors. Have you go any error or checked in console section?
@andresena7772 жыл бұрын
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
@LearningPointsCourses2 жыл бұрын
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.
@andresena7772 жыл бұрын
@@LearningPointsCourses where exactly is this axis #0?
@soufianch84812 жыл бұрын
please send me your code for chart plzzz
@LearningPointsCourses2 жыл бұрын
Currently I don't have that code. Sorry
@abdulbaqibasit22443 жыл бұрын
send me this query
@LearningPointsCourses3 жыл бұрын
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
@abdulbaqibasit22443 жыл бұрын
@@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)
@abdulbaqibasit22443 жыл бұрын
SQL ma query theek run kr rhi hai
@LearningPointsCourses3 жыл бұрын
Video description box me facebook link diya hay.. message karo apka query