Dashboard based on MySQL Data

An already existing application for the measurement of it service quality data calculates a measurement record almost every five minutes and stores the data in the mysql database. This Website should display actual and historic data for a selected group in a dashboard. The Data field description: ts : Timestamp giving the end time for this measurement. grp : The group information for this this measurement record (text format). A single dashboard view display only the four data types data of a single group. Example: „grp_lync“. dev: The name oft the device which ist the sender of this record (text format). Example „841996“. Itres: Reading 1: „IT-Ressourceneinsatz“ (Double)
. Example: „11.07“. verfg: Reading 2: „Verfügbarkeit“ (Double)
. Example: „11.07“. perf:_Reading 3: „Performance“ (Double). Example: „5.01“. 
nutz: Reading 4: „Nutzungsintensität“ (Double)

. Example: „0.032“. For a selected group (grp) the received measurement data should be selected and displayed together in one web-page (dashboard) following the idea shown in the attached document. For each oft the four measurement types a diagram (historical view, left side) and the display oft the last received record reading (using a speedometer form, right side) is displayed. The headline of each couple of displays ist the reading name as given in the COMMENT oft the data table. The dashboard refreshes automatically when receiving a new record for the displayed (selected) group. The range oft the historical view should could be selectet: day, week, month, year and „all received data“. Only one selection for a group view is allowed and has effect on all four graphics in it. The actual selection could be changed by using a checkbox function in the dashboard display. The scaling of the speedometer and the borders of hte colored areas (red-yellow-green-yellow-red) are stored in the mysql database too. Each group has is own configuration data. The colors oft he speedometer should be also visible in the historical view – with according border lines. If theres Measurement and configuration data should be stored in the same mysql database. Note: there could be a lot of different groups and more the one of sending measurement devices for a group. If there is more than one measurement device there should be a second selection box „Device“ on the dashboard page. A group dashboard should be called by using: 

http://...../group More than one group dashboard could be opened the same time (separate windows). Environment: MySQL 5.1.69, the server is running redhat linux. For displaying the dashboard(s) only safari and firefox browsers will be used. Note: at the end of this project i want to receive the program documentation and the program (script-) Files in a readable form. A rights on this software are on my person. Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).