3 Replies Latest reply on Mar 28, 2018 10:09 AM by Deepak Rai

Lod Vs Table Claculations

kumar leau Mar 28, 2018 9:42 AM

Hi Tableau Experts,

Which one gives better performance if I use LOD and table calculation in a view. Why?

Can some one explain why?

Regards,

Kumar

1. Re: Lod Vs Table Claculations

Deepak Rai Mar 28, 2018 10:02 AM (in response to kumar leau)

Each has its own utility and limitations,
Like LOD The PROs are You get a New Dimension which can be reused, You can aggregate the aggregate, they are evaluated much earlier in Tableau order of Operations which helps in many cases
Cons are that it breaks in case of data blending, but works better when data is joined

Thanks
Deepak
Like Show 0 Likes(0)

Actions
2. Re: Lod Vs Table Claculations

kumar leau Mar 28, 2018 10:06 AM (in response to Deepak Rai)

Thanks Deepak for your quick response.
If my understanding is correct, LOD's will give better performance when compare to table calculations
Like Show 0 Likes(0)

Actions
3. Re: Lod Vs Table Claculations

Deepak Rai Mar 28, 2018 10:09 AM (in response to kumar leau)

Yes, Thing is if you master them and understand the logic, how they work/, they provide you better options, ofcourse you can't use Table Calculations inside LOD...btw..I am a heavy user of LODs
Like Show 1 Likes(1)

Actions

Tableau Community Forums