6 Replies Latest reply on Apr 29, 2013 6:58 AM by Shawn Wallwork

# Range of two values

Hi All,

Below is the requirment in Tableau

Scenario :

We have two values   1,6.

Can we get other values between 1 and 6 using calculated field ?

Thanks,

Safi

Yes.

• ###### 2. Re: Range of two values

Hi Shawnwallwork,

Thanks,

Safi

• ###### 3. Re: Range of two values

If I remember correctly toward the end of his talk he shows you how to fill in the values between two numbers. Hope this helps.

--Shawn

That sure is a long URL. Guess we need a URL shortener for forums.

• ###### 4. Re: Range of two values

Hi Safi,

Joe's intro is great, definitely watch it. I've attached a workbook with some "simple" examples.

I have to issue a caveat, though. Domain padding is a complex, mostly undocumented subject. One key thing is that since domain padding happens inside Tableau after the data has been returned from the data source, due to the order of operations you'll need to be using table calculations in various places where before you could just use a dimension or regular aggregate measure. If you're not familiar with table calculations, you'll need to be. For that reason it might be easier to do the padding outside of Tableau. Even though I know domain padding better than most I still do a chunk of my padding in the data source and then use Tableau's domain padding under controlled circumstances.

Jonathan

• ###### 5. Re: Range of two values

Hi Shawnwallwork,

In the video the topic is about Domain padding and the the things is about table calculation.

But my question is little  different.

Actually I want to store the all values(1,2,3,4,5,6) between two values ( 1 and 6) within a calculated field or parameter.

Thanks,

Safi

• ###### 6. Re: Range of two values

Safi, within a parameter it's easy, all you have to do is make a list with those values. But I suspect this isn't what you're looking for. Generally speaking Tableau isn't a software that "stores" things; rather it's a software that "displays" things. In Tableau most things have to come from the underlying data. So the easiest way to get all the values between 1 and 6 is to put those values into your data.

Having said this, you could always create a calculated field for each of the numbers, one for "2", one for "3", etc. But again this probably isn't what you want. So let me ask, what are you trying to accomplish with these stored values?

--Shawn