MetricApiController.cs

[Authorize(AuthenticationSchemes = JwtBearerDefaults.AuthenticationScheme)]
[HttpGet("AllResourceCategoryMetric")]
public IActionResult ResourceCategoryMetric(string startingDate)
{
    // TODO: roles not implemented yed, this metric is returns the same metric for any role
    if (startingDate == string.Empty)
        return BadRequest(Localizer["SelectATimePeriod"]);
    var resources = UnitOfWork.ResourceRepository.GetAllWithRelatedEntitites().Where(ra =>
                                    ra.UpdatedAt >= DateTime.ParseExact(startingDate, "dd/MM/yyyy", CultureInfo.InvariantCulture))
                                    .ToList();
    if (!resources.Any())
        return BadRequest(Localizer["ResourcesNotFoundInPeriod"].Value);
    var allReviewCategories = resources.SelectMany(r => r.UserResourceReviews.SelectMany(rev => rev.Categories));
    return Json(Enum.GetValues(typeof(ReviewCategory)).Select(category => new ResourceCategoryMetricVO
    {
        CategoryName = category.ToString(),
        Percentage = Math.Round((decimal)(100 * allReviewCategories.Count(cat => cat == category)) / allReviewCategories.Count(), 2),
    }));
}