Website Dashboards

Website Dashboards that are created by SQL query derived from a Web form 1) Web form A form that requires a minimum of 2 inputs but may take more which creates query to a complex dB returning a spreadsheet like list that can be sorted in two (2) of its columns. At the bottom it shows clickable pagination, selectable number of pages to show*, and total number of items returned. * 10 / 50 / 100 /200 • Name - linkable to the “Graphic dashboard” • Ratio - sortable high to low or reverse • Rate - sortable high to low or reverse 2) Dynamic SQL query 3) Graphic dashboard Populate a dashboard from the data parameters given in the “Web form” and returns a graphical response showing pie charts and bar graph with trend • Pie Chart 1 (ratio): 3 points • Pie Chart 2: 2 points • Pie Chart 3: 2 points • Pie Chart 4: 2points • Bar graph – 10-year history period/timeline 2-point comparison • Data 1: average time • Data 2: average time • Data 3: average win amount • Data 2: average loss amount 4) Dynamic dashboard just like Graphic dashboard but with only one input “name” Note: This is a Joomla site dB is postgreSql screen shots / wire design will be shared after award