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,
Book2.twbx.zip 105.9 KB
thx for your help
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?
1 of 1 people found this helpful
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,
You are great! Thx again!
I start falling in love with tableau!!
Thx and have a nice day!
greets B Ootes