KNOWLEDGE BASE

Decimal between 0 and 1 stored as Double data type in AnalyticDB for MySQL database hosted in Alibaba Cloud is rounded to 0 or 1


Published: 27 Sep 2021
Last Modified Date: 28 Sep 2021

Issue

Double data type decimal digits between 0 and 1 from Alibaba AnalyticDB for MySQL database are showing rounded off to 0 if the decimal is less than 0.5 or rounded up to 1 if the decimal is greater or equal 0.5

Environment

  • Tableau Server 2020.4
  • CentOS 7
  • Alibaba AnalyticDB for MySQL

Resolution

Workaround:
Directly create calculation fields in the Tableau workbooks to get this decimal values instead of directly getting it from Alibaba AnalyticDB database hosted in Alibaba.
Did this article resolve the issue?