Aggregate count function does not work in the denominator
When I use the following statement in a card summary, it works properly. But when use it as a value in a Single Value card, the count function doesn't work anymore: SUM(CASE WHEN ROUND(100*`Score`/`PossibleScore`)>=60 THEN 1 ELSE 0 END) / COUNT( `AttemptNumber`) For more context, the Attemptnumber column has 450 rows where…
