...
All the instructions how to start developing and deployment are there in the readme file.
Charts description
The site renders 2 types of charts (Dialysis Starter Charts and Transplant Listing Charts) based on the data extracted from the ER model illustrated here.
DIALYSIS STARTER CHARTS (view: edd-charts)
Dialysis starters data (Graph1)
Each percentage bar chart shows the percentage of items in dashboarddata by list_status (no_decision, working_up, active, unsuitable, suspended) at a quarter for the selected unit.
e.g. Preston at Q1 2018 proportion of list_status = "working_up"
select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and list_status = "working_up" and quarter_id=2 / select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and quarter_id=2 * 100 -> 7 / 26 * 100 = 26.92%
Patients who are still being “Working up or under discussion” (Graph2)
This graph presents a line graph per unit, where all units belong to the same region. It also includes a line graph for the region. Each point of a line graph represents the percentage of items in dashboarddata per unit, per quarter_id and list_status=”working_up'” over all dashboarddata items for all list_status and indicated unit, quarter_id (count of txfirst_dashboarddata records per list_status=” working_up”, unit and quarter_id / count of txfirst_dashboarddata records of all list_status per quarter_id and unit * 100)
Example for unit Preston at Q1 2018 proportion of list_status = "working_up"
select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and list_status = "working_up" and quarter_id = 2 / select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and quarter_id = 2 * 100 7 / 26 * 100 = 26.92%
Each point of the region line graph in the code is computed as region_count / region_total_count * 100, which is equivalent to the following query:
Example for region North West at Q1 2020 and list_status = “working_up”
select count(*) from txfirst_dashboarddata left join users_unit on unit_id = users_unit.id where region_id = 3 and list_status = "working_up" and quarter_id=17 / select count(*) from txfirst_dashboarddata left join users_unit on unit_id = users_unit.id where region_id = 3 and quarter_id=17 * 100 15 / 54 * 100 = 27.78%
Release
It is running on UKRR web server under txfirst account (together with magic project).
...