February 28, 2017
Tableau Tip Tuesday: Table Calculations Overview
Table calcs - the beast of all things Tableau...for me at least! It's been nearly 10 years that I've been using Tableau and it wasn't until I was teaching last week that the light bulb went off.I promised a blog post and here it is. I've recorded about a 30 minute video where I have two primary objectives:It took nearly 10 years, but I finally have a way to put @Tableau table calcs into an english sentence to understand them. Blog coming soon.— Andy Kriebel (@VizWizBI) February 25, 2017
- Provide recommendations for how to approach table calcs
- Teach you how to read table calcs in a plain English sentence
Here are two slides I created to help you read table calcs:
The trick is to read from the bottom up.
- Start with the unchecked boxes and add the words "For each" before those.
- Move to the Calculation type and add the words "compute the" before the item in the Calculation Type box.
- Add the word "by" before each box that is checked at the bottom, again reading it from bottom to top.
I hope you find this helpful and that it makes table calculations easier for you to understand. Please let me know if this helps.
Subscribe to:
Post Comments
(
Atom
)
Andy this is super helpful! Like you in the past I've basically used trial and error to get table calcs to work as needed. This will help save a bunch of time!
ReplyDeleteOne question: I've noticed that in the "Specific Dimensions" box you can reorder the fields. Do you know how re-ordering will impact the table calc? For example, if you reversed product category and product sub-category, does that matter?
Hi Jonathan. Thanks for the question! Reordering the unchecked boxes will not impact the table calc. However, if you reorder the checked boxes, the table calc WILL change. The best way to see that is action is in a table. For example, if you have Year and Region both checked and region is below year, then you would read that as "by Region by Year". If you put Region above year, you would then read it as "by Year by Region".
DeleteThanks for clarifying!
DeleteThanks Andy, this is definitely helpful, still struggle with Table Calcs. Would be happy to see further post on some advance calcs options being discussed
ReplyDeleteDo you have any example you'd like me to review?
DeleteAn example about year over year type calculations would be terrific.
ReplyDeleteYou read it the same way. The difference is the middle part where you change the "calculate..."
Delete#mindblown
ReplyDeleteI was just thinking about table calcs the other day and discouraged how after 3 years of using Tableau, I still find myself clicking random combinations of table calculation ordering/assignments until I get what I'm looking for. Your explanation here makes so much sense. Thank you for sharing!!
Thanks for posting this, Andy. I found it really helpful, and I feel like I'm ready to brave Table Calcs now.
ReplyDeleteSuper post Andy... Really helpful insight in understanding the table calculations.
ReplyDeleteLovely. So lovely in fact that it would be awesome if Tableau could add this as a caption to the same Table Calc box that would update with your selections. I know a lot of work has been done to visually show the changes in the view, but the human explanation of what's going on also goes a long way to help people form the mental model needed to really take command of table calcs.
ReplyDeleteTableau in English sentence makes a lot easier to understand. Thanks Andy.
ReplyDeleteThank you for posting this, Andy. This will help me to understand my work and to whoever I need to explain the fucntion to much easier.
ReplyDeleteHi Andy,
ReplyDeleteFinally understood the table calculations :) thanks a lot for the video and the explanation.
Its really helpful.
Regards
Thanks for posting such a clear explanation Andy! Incredibly helpful to clarify what's going on in the Table Calcs window.
ReplyDeleteThanks John!!
DeleteHi Andy,
ReplyDeleteThank you for posting this info. I am not able to see the slides in this. It looks like the link is broken.
Could you please add them so that it would be helpful.
Thanks,
Latha Y
Fixed! Thanks for letting me know.
DeleteGreat! It's very helpful.
DeleteThank you Andy.
Thanks for your explanation. Very helpful.
ReplyDelete