If your goal is produce something like this (either as a table or graph):
you've already done 99% of this with your sheet 1.
Your table calcs for Window Max/Min are calculating the correct value, if you set compute using is set to Index. In sheet 1, compute using Index and compute using Table (down) are equivalent, but once you move Index from the rows shelf to the detail shelf, you'll need to specify it.
It's good practice to specify the default compute using dimension in the calculated field (enter/edit) dialog box---click on "Default Table Calculation" in the upper right corner.
And, since you only want one value, these table calcs should be wrapped in a
IF FIRST() == 0 THEN
[your table calc statement here]
Now you can create a new sheet.
- Put index on the level of Detail shelf, measure names on the Rows shelf, measure values on the Text shelf.
- Remove the measures you don't want.
- Double-check the compute using for the table calcs.
- You'll have extra white space as a result of the nulls generated by the rows where IF FIRST() != 0. Tableau v8 "stacks" these marks by default, but you can disable it by selecting Analysis > Stack marks > Off from the top menu.
You can also use these Min/Max values in other calculations on a sheet (or tooltips, ..).
Lookup-independent_jimw.twbx.zip 45.1 KB
Thank you very much!
The answer wasn't the straight road to a direct solution, but neither was my question clear enough to be able to give a good answer.
A while of trying out the things you described helped me reach what I wanted, a scatter plot based on the above numbers.
This is a big step forward. Also, knowing that it can be done opens up for a lot of other interesting things.