I will give you access to the MySQL database. You have to use 6-7 tables and link to a dashboard to display the progress and results for a field activity. The dashboard will allow the user to select the State, the Hub, City and a cluster within the city, or the whole state or city and then filter between two dates. The data is pulled up accordingly and then displayed as a bar chart or stacked bar charts.
The Progress chart will display the tasks done, tasks in progress and tasks pending. The results charts will display the percentage and number of defects. The defects are of 4-5 types.
A sample drawing of the proposed dashboard is attached here. In the result graph, when the state is selected, you will have a stacked bar chart showing the defects for each hub, when you are viewing for a hub, you will show for the cities under that hub, when viewing for a city you will show charts for the clusters in that city, and when viewing for a cluster, you will show for the hotel units in that cluster. Upon selecting a particular hotel, you will show only for that unit
19 фрилансеров(-а) в среднем готовы выполнить эту работу за $47
Hi There, Am a full stack developer having 9+ years in software and web development. I can achieve your requirements in high quality, performance and to be satisfied.