Calculate status color and trend

Add color from the status of the indicator, as well as calculating the
trend of a category.