3 of 3 people found this helpful
I have a Viz that shows Sales over the last 12 Months.
I want to only show the last 3 months in my Viz
So I am going to create a Calc like the following.... LAST() < 3
This is telling Tableau, hey look at all my dates (Addressing) and only show me that last 3 Dates (Partitioning).
Addressing is the means in which you are telling Tableau to Partition by.
Here is the link for more info.
7 of 7 people found this helpful
One way to think of addressing and partition is "direction" and "scope" respectively.
Think of some aggregate calculation, like, say Average, that you might want to display in a viz. Well, do you want that average computed across the entire view in one lump? Average every year? Every month? Those would be examples of partition. The partition tells Tableau when to start and stop the calculation (scope.)
Addressing is about "direction." If for example you have used the "Compute Using" dialog (say, to change from "Table Across" to "Table Down,") you were already specifying addressing. This about which elements to include in a computation, and in what order. It's about "compute on the basis of what?"
So, you could think of addressing being "what to compute" and partition being "where to start and stop computing."
1 of 1 people found this helpful
You have some very good answers already... thank you Rody & Ken!
Your question reminded me of a blog post which I personally found useful, and I hope you do to...
You've got some great 'layman' descriptions there...I'd also suggest you watch the following webinar
The specified item was not found.
(About half way down 'Setting Up for Table Calculation Success'
and I've always found the below image [also attached] (which is lifted from 'Tableau your Data by Daniel Murray)! very useful (maybe not so much in the partitioning/addressing explanation, but for the direction piece Table Across/Pane Across/...etc.)
Table Calc Directions.jpg 342.8 KB
1 of 1 people found this helpful
You have a lot of resource there!!
I have marked all replies as helpful, please mark one correct as you see fit!
5 of 5 people found this helpful
Here's a few more points:
- Addressing (aka compute using) and partitioning is all about the dimension pills in the view (all the Shelves except for the Filters Shelf). So you have to be clear about dimensions & measures (which is different from blue/discrete and green/continuous). I see a lot of people get tripped up on this because they aren't aware of this distinction.
- A table calc will return a result for each and every combination of distinct values of the dimensions in the view. In other words, a table calc will return a result for each mark.
- Partitioning defines the slices/buckets where a calculation will restart, addressing defines the set of values and the sort order for all but the RANK* and TOTAL functions that will be computed over within each slice.
- Any dimension in the view that is not part of the addressing (compute using) is part of the partitioning. So when we add pills to a view that has table calcs we have to maintain "pill awareness" of dimensions & measures.
- Some people (including me) think of partitioning first, whereas in Tableau we set the addressing first. So there's sometimes a bit of mental gymnastics to think about a view.
Addressing = direction, right? When you are choosing between across table, across pane, etc you are choosing the "addressing". I'm just mentioning this so Chris doesn't get confused.
2 of 2 people found this helpful
Yes, "direction" for addressing (when you use the Table Across/ Pane Across...etc.) is a good way to look at it. With the new Table Calculation set up (since T10.0...from memory) we don't really get the terms (adressing and partitioning). Addressing = "Compute Using", in the new version.
Personally I tend not to use the Table Across/down...etc. and set them up using the "specific dimensions" option (just means if I end up moving pills about the Table Calculations still work, as I want). In this set up I think of anything that is ticked as "run the calculation along this" (aka compute using/addressing) and anything as not ticked as "start the calculation again for every one of these" (aka partitioning)
Thank you. Can you help me with this thing I posted? I have many more dimensions in partitioning than I expected. Is this because I'm using tableau public?