Please Contact the Quicksight Team to solve this issue

Hey everyone, i’m facing this issue, when a try to include a distinctCount in a calculated field, Quicksight returns me this error, can you help me?

Horas Produtivas: sumOver(ifelse(sum(Quantidade)>max(Meta),distinct_count({Hora Inteira}),0),[{Hora Inteira},{Nome Operador},denominacao])

Horas Improdutivas Quantidade: sumOver(ifelse(sum(Quantidade)<max(Meta),distinct_count({Hora Inteira}),0),[{Hora Inteira},{Nome Operador},denominacao])

Put the distinct count in a calculated field of its own then reference the new calculated field in your calculation. You could even put both parts into calculated fields and then subtract one from the other.

I also think your final closed bracket is in the wrong place. Move it to just after {quantadade}))

Hi, @rribfilipe. Did @RichardAustin’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!