Hello everybody !! my application, performs daily checks on cars,
there are 100 cars in total.
Every 15 days I have to check all 100 cars.
How can I create a graph that gives me the percentage of checks made in 15 days on the total number of cars I have? I hope I have explained thanks
Without knowing your app structure, this is how I would do it
Tables
check_periods: period_id, check_by_date
cars: car_id, name, etc
check_results: id, period_id, car_id, check_status
Views
Pie Chart view on check_results
Dashboard consisting of the Pie Chart, check_periods, check_results (<- I named this cars in my demo app...)
Actions(entirely optional)
Create check_results entries based on cars and the current period marked by a check box
Looks something like this
โ
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |