1 of 1 people found this helpful
I am just starting out with Tableau as well and faced this problem. This article explains how partitions are organised:
So you need to choose your required method of partitioning that you are going to use prior to writing your table calculation. The article gives a good schematic view of the options available.
Hope that helps,
Thanks for that article. Very helpful. However,I don't think it solves the problem (not ruling out User Error quite yet)...
I have attached two pages to a ppt for screen shots. I have copied in my formula so you can see how I am trying to use look up.
In the first, the table is set up with YEAR then MONTH, and if you look at the INDEX column as well as the output in the last column all is well in the land of table calculations.
However, I don't want to compare MOM performance within a given year, I want to compare YOY performance for a given month.
So, I swap MONTH and YEAR, see page two, and yet the table calculation returns the EXACT SAME values. Looking at the INDEX column, you can see that the indexes are still traversing a single year, although the table is clearly partitioned by MONTH.
IF, according to the link you sent, I go into advance and change the focus to MONTH, then I get NULL (I think they are NULLs) returned, as I see no data at all. I have tried multiple combinations of things, and I cannot get one that gives me the answer that I want, which is the previous year's value for that month.
Thanks again for your help, hopefully, there is an answer out there for me !
Partitions.pptx 187.0 KB
If you take the table in the format on the first ppt slide and change the 'compute using' in the table calculation to 'YEAR' then the offset in your formula should apply correctly.