In this post I showcase how I added coloured suppliers name for each month to chart 1.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 17 – Colouring stripLines for every second supplier
To make it easier to distinguish individual suppliers the chart 1, I coloured the background of every second suppliers bar charts. In this post I explain how I’ve done this.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 16 – Colouring chart 1 bars
In this post I explain how I colour bar charts for chart 1. Every unique suppliers gets assigned a color for its bar charts, to make it easy to distinguish the supplier inside the chart.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 15 – Adding bars to chart 1
In this post I explain how the bar charts have been rendered for chart 1 and demonstrate the code responsible for it.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 14 – Formatting chart 1
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.