# INCLUDE/EXCLUDE LoDs are not vizLoD aware when used in a Computed Set?

**Rody Zakovich**Oct 29, 2015 8:51 AM

Hey Community!

***Edit* I changed the title of the Question to more closely match the context of the thread. The previous "Using LoDs in SETS Don't Actually Do Anything?"....was not my actual question. Hopefully this will help others who are searching for a similar question.**

Sorry I haven't been answering away like normal.....busy week coming back from the conference/I have been working on finally getting a blog written.

As a part of this blog, I am trying to really breakdown Tableau. The first part of this is trying to understand Tableau as a series of Levels. We interact with the values at each level differently.

1. The Main Datasourse (Your DB, Excel Sheet, etc)

2. The Effective Datasource (Your DB/Excel Sheet + Row Level Calcs [Not including LoDs] )

- If you are using an EXTRACT (Optimized) the Columns created with Row Level Calcs are passed back to the DB as a part of the EXTRACT Query (This is why LoDs are not included in this layer).

3. The Tableau Datasource (Your DB/Excel Sheet + Workbook Specific Fields [GROUPS] + Row Level Calcs + FIXED LoDs [FIXED are not vizLoD Dependent])

- INCLUDE/EXCLUDE LoDs are different as the live in the both The Tableau Datasource AND the Computed Datasource, i.e they must be computed by the vizLoD, but the values still exist at a Row Level

4. The Computed Datasource (Aggregations [This would include BLENDS with defined relationships] and Window Calculations)

- The values generated are vizLoD dependent. The value generated from SUM([Sales]) is dependent on how the viz is partitioned.

Off in another world but still very much a factor in the Computed Datasource.....Tableau's Range Awareness - The Values generated in accordance with desensification/padding/etc

**Where I am stuck.....where do computed SETS live?**

When using Computed SETS, LoD functions don't actually do anything. Using SUM({ INCLUDE : SUM([Sales]) }) Will result in the same SET as SUM([Sales]).

My initial thought is COMPUTED SETS are not vizLoD Dependent. They are calculated PRIOR to the vizLoD. Which is why a SET computed from SUM({ INCLUDE : SUM([Sales]) }) is the same as SUM([Sales]). The only thing that can affect a COMPUTED SET are CONTEXT Filters (However, I am still defining how CONTEXT Filters are different than other filters and fields in the vizLoD). That said, even when we use CONTEXT Filters, the LoD and Regular Aggregate still compute the same sets, they are just created based on the values within CONTEXT.

If this is true, then Computed SETS' live within the Tableau Datasource, and not the Computed Datasource (As I previously thought). This makes sense since we can use SETS Row Level...i.e

IF [includeCustSet] THEN 1 ELSE 0 END

Further clarification, or additional details on this subject would be highly appreciated!

Jonathan Drummey or Simon Runc do you have some thoughts on this subject?

Regards,

Rody