BellaDati allows you to display text-based KPI labels. Use this feature to translate rates info easily readable tiers or as alternative to conditional formatting.
Example:
M_RATING@AVG indicator stores average rating of the institution. Instead of displaying numbers with conditional formatting, report requires to have text-based evaluation including 'At-Risk', 'Bellow Average', 'Average', 'Good', and 'Excellent'. Use code bellow to obtain such result.
rating = ''; if (M_RATING@AVG<0.59){rating = 'At-Risk'} if (M_RATING@AVG>0.60){rating = 'Bellow Average'} if (M_RATING@AVG>0.80){rating = 'Average'} if (M_RATING@AVG>0.85){rating = 'Good'} if (M_RATING@AVG>0.90){rating = 'Excellent'} return rating;
Result:
Next Steps
Overview
Content Tools