Non specific syntax error dividing distinct count fields

[aseaman]

I am trying to do a simple division calculation.

• Numerator is a distinct_countif aggregation
• Denominator is a distinct_count aggregation

Error is not specific about how to correct. See image.

Is Quicksight able to divide distinct count aggregations?

[Naveed]

Hi,

Can you try it with the distinct_count_if(api,{active/inactive}=“Active”)/({distinct_count(api)}) directly instead of calculation field used which giving error ?

Regards,
Naveed Ali

[aseaman]

Yes, this worked.

[aseaman]

And this also produces the same result.

[Kristin]

Thanks for letting us know @aseaman!