Non specific syntax error dividing distinct count fields

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?

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

1 Like

Yes, this worked.

image

1 Like

And this also produces the same result.

2 Likes

Thanks for letting us know @aseaman!

1 Like