4 Replies Latest reply on Sep 16, 2013 1:00 AM by bart.groots

# difference between

Hi,

I need to have the difference between 2 values, Every 2 hour.(energy gauge)

I need to know how much Kh ervey 2 hour  the divice (collector) uses.

 20-1-2012 12:45:00 789 20-1-2012 13:00:00 790 20-1-2012 13:15:00 790 20-1-2012 13:30:00 800 20-1-2012 13:45:00 810 20-1-2012 14:00:00 830 20-1-2012 14:15:00 855 20-1-2012 14:30:00 855 20-1-2012 14:45:00 860 20-1-2012 15:00:00 861 20-1-2012 15:15:00 861 20-1-2012 15:30:00 880 20-1-2012 15:45:00 891 20-1-2012 16:00:00 899 69 20-1-2012 16:15:00 899 20-1-2012 16:30:00 900 20-1-2012 16:45:00 901 20-1-2012 17:00:00 920 20-1-2012 17:15:00 940 20-1-2012 17:30:00 941 20-1-2012 17:45:00 943 20-1-2012 18:00:00 945 46 20-1-2012 18:15:00 950 20-1-2012 18:30:00 951 20-1-2012 18:45:00 955 20-1-2012 19:00:00 966 20-1-2012 19:15:00 970 20-1-2012 19:30:00 971 20-1-2012 19:45:00 978

^    this  column i need.

899 - 830 = 69 & 945 - 899 = 46

can some one help me ?

Greets

• ###### 1. Re: difference between

Bart,

I was able to make a quick mock-up of a similar concept using the lookup function.  Is this helpful?  If you are unclear on how LOOKUP() works, I have a blog post about table calculations at http://breaking-bi.blogspot.com/2013/02/working-with-table-calculations-in.html. (Scroll to the second section) LOOKUP() uses the same "Compute Using" concept as INDEX().

Let me know if this helps,

Associate Consultant

Mariner, LLC

http://breaking-bi.blogspot.com

• ###### 2. Re: difference between

Hi,

IT WORKED

I really appreciate !

only, what i dont get, if i need a table, i get a dimension of a year, when i change this demension to extact data it becomes green and my table is a charr?

a blue demenion is a table and a green one is a charr?

How do i get a table with exact date?

• ###### 3. Re: difference between

Bart,

That's a great question.  In Tableau, blue pills are discrete and green pills are continuous.

Continuous - Can take any value, even those not observed (typically only makes sense for dates/numbers)

Example: Your data set has 0, 1, 2, 4.  Labelling them as continuous tells Tableau that 3 is a possible value, despite

the fact that it is never observed.

Discrete - Can only take observed values.

Example: You have colors "Red" and "Blue".  Tableau only sees "Red" and "Blue"

The first set of date functions in Tableau is Discrete.  The second set is Continuous.  I know this doesn't make a whole lot of sense to you right now.  So, I'll give you the short answer.

When you change your date to "Exact Date".  Right-Click the date pill in the columns or rows shelf, Select "Convert to Discrete."

Hope this helps,

Associate Consultant

Mariner, LLC

http://breaking-bi.blogspot.com

1 of 1 people found this helpful
• ###### 4. Re: difference between

You are great! Thx again!

I start falling in love with tableau!!

Thx and have a nice day!

greets B Ootes