KNOWLEDGE BASE

Minus Values Are Included Into the Bin Of "0" When Using MS SQL Server


Published: 03 Apr 2018
Last Modified Date: 03 Apr 2018

Issue

After creating bins, you notice that the bin labeled as "0K" contains negative values (for example, values could include between "-10000K" or more, and less than "0K"). 

Environment

  • Tableau Desktop
  • MS SQL Server

Resolution

Option 1

Use extract instead of live connection.

Option 2

Use a calculated field to create bins. For example:
IF [Sales] >= -10000000 AND [Sales] < 0 THEN "-10000K " 
ELSEIF [Sales] >= 0 AND [Sales] < 10000000 THEN "10000K " 
END

Cause

This issue (ID: 753507) is currently under investigation.
Did this article resolve the issue?