• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Converting Discrete to Continuous Quantities in Tableau

When you are using a relational data source you can convert any numeric or date field into a continuous field.

Special Values

Some data requires special handling in Tableau. Specifically null values, unrecognized or ambiguous geographic locations, negative or zero values when working with a logarithmic scale, and negative or zero values when working with tree maps.

When your data contains these special values, Tableau cannot plot them in the view. Instead, a indicator displays in the lower right corner of the view. Click the indicator to see more options for how to handle these values.

Tableau_Indicator

   Our course design of tutorials is practical and informative. At TekSlate, we offer resources 
     to help you learn various IT courses. We avail both written material and demo video tutorials.
          For in-depth knowledge and practical experience explore Tableau.

Null Numbers and Dates and Negative Values on Log Axes

When you drag a measure or continuous date to the view, the values are shown along a continuous axis. If the field contains null values or there are zero or negative values on a logarithmic axis, Tableau cannot plot them. Instead, these values are shown using an indicator in the lower right corner of the view. Click the indicator and choose from the following options:

  • Filter Data– exclude the null values from the view using a filter. When you filter data, the null values are also excluded from any calculations used in the view.
  • Show Data at Default Position– show the data at a default location on the axis. The null values will still be included in calculations. The default position depends on the data type. The table below defines the defaults.
Type of DataDefault Position
Numbers0
Dates12/31/1899
Negative Values on a Log Axis1
Unknown Geographic Location(0,0)

Unknown Geographic Locations

When working with maps and geographic fields, any unknown or ambiguous locations display in the indicator in the lower right corner of the view. Click the indicator and choose from the following options:

  • Edit Locations– correct the locations by mapping your data to known locations.
  • Filter Data– exclude the unknown locations from the view using a filter. The locations will not be included in calculations.
  • Show Data at Default Position– show the values at the default position of (0, 0) on the map.

Zero and Negative Values in Treemaps

When working with treemaps, any null or zero values display in the indicator in the lower right corner of the view. Click the indicator and choose from the following options:

  • Filter Data– exclude the unknown locations from the view using a filter. The locations will not be included in calculations.
  • Use Absolute Values– use the absolute value to determine the size of the corresponding area in the view. For example, both values of 5 and -5 are shown as the same size.

If you don’t know how to handle the values, you can choose to leave the special values indicator. Generally, you should continue to show the indicator so that you know there is data that is not being shown in the view. However, you can optionally hide the indicator by right-clicking it and selecting Hide Indicator.

For indepth knowledge on Tableau, click on below

Summary
Review Date
Reviewed Item
Converting Discrete to Continuous Quantities in Tableau
Author Rating
4

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Converting Discrete to Continuous Quantities in Tableau"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.