cheklist chart

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
0 1 120
1 REPLY 1

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

Animation.gif

โ€ƒ

Top Labels in this Space