{% extends "base.html" %} {% block title %} Home Page {% endblock %} {% block content %}
SN | INITIATIVE | PROJECT COUNT | DELAYED PROJECTS | {% for header in summary_data[0] %} {% if header not in ['Initiative', 'Project Count', 'Delayed Projects', 'Total Executer Delayed Projects'] %}{{ header | upper }} | {% endif %} {% endfor %}TOTAL | |
---|---|---|---|---|---|---|
{{ loop.index }} | {{ row.Initiative }} | {{ row['Project Count'] }} | {{ row['Delayed Projects'] }} | {% for header in row %} {% if header not in ['Initiative', 'Project Count', 'Delayed Projects', 'Total Executer Delayed Projects'] %}{% if row[header] > 0 %} {{ row[header] }} {% endif %} | {% endif %} {% endfor %}{{ row['Total Executer Delayed Projects'] }} | |
Total | {{ summary_data | sum(attribute='Project Count') }} | {{ summary_data | sum(attribute='Delayed Projects') }} | {% for header in summary_data[0] %} {% if header not in ['Initiative', 'Project Count', 'Delayed Projects', 'Total Executer Delayed Projects'] %}{{ summary_data | sum(attribute=header) }} | {% endif %} {% endfor %}{{ summary_data | sum(attribute='Total Executer Delayed Projects') }} | Number of Projects Delayed | |
Overall Delay | {{ (summary_data | sum(attribute='Total Executer Delayed Projects') / (summary_data_meta.total_projects_by_executor.values() | sum) * 100) | round(2) }}% | {% set ns = namespace(total_percentage=0) %} {% for header in summary_data[0] %} {% if header not in ['Initiative', 'Project Count', 'Delayed Projects', 'Total Executer Delayed Projects'] %} {% set percentage = (summary_data | sum(attribute=header) / (summary_data | sum(attribute='Total Executer Delayed Projects')) * 100) %}{{ percentage | round(2) }} | {% set ns.total_percentage = ns.total_percentage + percentage %} {% endif %} {% endfor %}{{ ns.total_percentage | round(2) }}% | % of Delayed | ||
{% for header in summary_data_meta.executor_columns %} | {% if summary_data_meta.total_projects_by_executor.get(header, 0) > 0 %} {{ summary_data_meta.total_projects_by_executor.get(header, 0) }} {% endif %} | {% endfor %}{{ summary_data_meta.total_projects_by_executor.values() | sum }} | Total Projects |
Records found:
{{ header }} | {% endfor %}
---|
{{ value }} | {% endfor %}