Home

Derived Field: coll_performance_category

Back to List Edit Test
Field Details

Field Name:

coll_performance_category

Source Table:

evolved_records

Status:

Active

Expression Type:

jinja

Output Type:

TEXT

Version:

v1

Used In:

Summaries

Display Name:

Performance Category

Expression:

            {% if coll_efficiency_score is defined %}
                {% if coll_efficiency_score >= 80 %}
                    "EXCELLENT"
                {% elif coll_efficiency_score >= 60 %}
                    "GOOD"
                {% elif coll_efficiency_score >= 40 %}
                    "FAIR"
                {% else %}
                    "POOR"
                {% endif %}
            {% else %}
                "UNKNOWN"
            {% endif %}
            
Dependencies
Field Type Actions
coll_efficiency_score Derived View
Joins

No joins defined

Registry Information

No registry entry found

Version History

No version history available

Field Usage

Referenced by:

Loading...