In this post I breiafly explain the formatting changes I have done to the sample chart from canvasjs.com.
CHEP Pallets / CSS / Data Analytics / github / HTML5 / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 13 – First Steps for chart 1
Started coding first chart on front end. For this project decided to use CanvasJS chart library. I find the first results satisfying!
CHEP Pallets / Data Analytics / Excel / Logistics Administrator / Uncategorized
CHEP Pallets Monitoring And Report. Step 12 -Mid summary
In this post I summarize what has been done so far. Explain what charts will be drawn at front end and create sample charts with excel as a guidance.
CHEP Pallets / Data Analytics / Excel / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 11
After running some queries against the database I decided to change what second chart is going to show and also came up with idea for a one more chart (so there will be a total of 4 charts).
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 10
In this post I show how I orginize data for my third chart. As I tried a different approch of forming and array, I noticed that I need to reorder my chart 1 data as well.
CHEP Pallets / Data Analytics / github / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 9
I queried database to get sum of pallets that were transferred in and sum of pallets returned, as these are the quantities I need for my second chart. Also added some security against SQL injection.
CHEP Pallets / Data Analytics / Excel / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 8
In this post I explain why an excel file that should contain 6 months worth of transfers only has 4. Also came up with idea for a new chart.
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL / Uncategorized
CHEP Pallets Monitoring And Report. Step 7
I managed to achieve the array structure layed out in previuos post, and it can be sent over to front end. I also learn some new things about arrays and updated my previuos PHP code.
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 6
Start to SQL querie database in back end with PHP in order to retrieve the data I need for charts. Will also start to arrange data in a manner that will enable me to send it to front end for the charts to be drawn.
CHEP Pallets / Data Analytics / Logistics Administrator / PHP / Protean / SQL
CHEP Pallets Monitoring And Report. Step 5
After uploading data to database I started running SQL queries and my concerns that it will be difficult to monitos CHEP pallets are confirmed.