KNOWLEDGE BASE

How to show bin axis value as 0-275 format


Published: 26 Aug 2022
Last Modified Date: 26 Aug 2022

Question

How to show bin axis value as 0-275 format

Environment

  • Tableau Desktop

Answer

Issue: User-added image

Desired:User-added image
Steps to achieve:
  1. Create a Parameter "Size of Sales Bin" and set the value as 275 as an example.
  2. Create a calculated field "Correct Sales Bin Group": STR(INT([Sales]/[Size of Sales Bin])*[Size of Sales Bin])+ "-" + STR(INT([Sales]/[Size of Sales Bin])*[Size of Sales Bin]+[Size of Sales Bin]-1)
  3. Build the view as the above image.
Did this article resolve the issue?