This content has been marked as final. Show 5 replies
I have a totals function that I would like to change into a KPI but the numbers are matching up when doing it.
within my measure in the table I have this:
Expression: sum(distinct completed_credits)
my table looks like this:
The blacked out employee_id is showing only one employee and the course_name is a subset of courses for that training model.
The total for the sum of completed credits only works correctly when I have employee_id and course_name within the table and if I have the Totals Function set to Sum.
can anyone give me some advise on how to change this from a table view over to a KPI? does it have something to do with the aggr() function???