3 Replies Latest reply on Oct 19, 2016 3:01 PM by Derrick Austin

Do you use a table calculation or an LOD when looking at isolated % of total?

Matt Hong Oct 19, 2016 1:04 PM

There are two ways to isolate % of total for a single row, as seen in the attached workbook:

1. Use a quick table calc, then hide all other rows

2. Use an LOD, then filter all other rows

Which do you prefer, and why? Is there a correct answer here?

1. Re: Do you use a table calculation or an LOD when looking at isolated % of total?

Derrick Austin Oct 19, 2016 1:24 PM (in response to Matt Hong)

I prefer LoD for anything % of Total. It's just soooo simple!

(I'm sure many would disagree with me though!)
Like Show 1 Likes(1)

Actions
2. Re: Do you use a table calculation or an LOD when looking at isolated % of total?

Matt Hong Oct 19, 2016 3:00 PM (in response to Derrick Austin)

I actually just found out you can accomplish it using Table Calc + Set filter. Do you use that ever?

Never mind, this is not true at all.
Like Show 0 Likes(0)

Actions
3. Re: Do you use a table calculation or an LOD when looking at isolated % of total?

Derrick Austin Oct 19, 2016 3:01 PM (in response to Matt Hong)

I don't - but I know a lot of people do the table calc with the "hide the rest" trick.
(Prior to LODs, this way the only way to go)

If you are showing all of the data anyway, it probably makes sense to do it with a table calc.
That is when I tend to use it, if I do.
Like Show 1 Likes(1)

Actions

Tableau Community