11 Replies Latest reply on Jun 15, 2017 6:49 AM by Tommy Sims

# Can someone explain what a fixed LOD does with multiple dimensions?

I am attempting to use a Fixed LOD for benchmarking. I would only like to compare performance of a client to "similar" clients. For example, dimensions could be Region, State,and Market (staffing, healthcare, etc..). If i want to see sales for only clients that are similar could I do something like { FIXED [Region],[State],[Market] : SUM([Sales])}    ? Or am I going about this the wrong way?

• ###### 1. Re: Can someone explain what a fixed LOD does with multiple dimensions?

I recently read this article on using LOD Exclude to compare sales at different geographical levels (country, state, city).  Does this help?

• ###### 2. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Yes., it is CORRECT. If you want to see each client in the region too, then you need to add Client ID or whatever you have in front of Region.

{ FIXED [Region],[State],[Market] : SUM([Sales])}   would give you results at Region level for a particular State and Market

Second Formula as below will give you results at Client ID level for that Region in Particular State and Market

{ FIXED [Client ID], [Region],[State],[Market] : SUM([Sales])}

Thanks

Deepak

1 of 1 people found this helpful
• ###### 3. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Thank you for the response Deepak. What happens if the client exists in multiple groups for a dimension? For example, the client is in both the staffing and healthcare markets.

• ###### 4. Re: Can someone explain what a fixed LOD does with multiple dimensions?

In that case, you may take market out to get result at Client level taking into account Region and State but not the Market. So you would get consolidated Results on Client irrespective to the Market he is in.

{ FIXED [Client ID], [Region],[State]] : SUM([Sales])}

1 of 1 people found this helpful
• ###### 5. Re: Can someone explain what a fixed LOD does with multiple dimensions?

What if I want to compare the client to only others that exist in the same markets? Would the Fixed to Market not allow that?

• ###### 6. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Use

{ FIXED [Client ID], [Market] : SUM([Sales])}

• ###### 7. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Tommy, I'm not sure that the above answers are getting you to the result you want.  They are correct and useful, but you may not be completely understanding what LOD calculations do.

LOD tells Tableau how to calculate something, based on what you have in the view.

A FIXED calc says: No matter what dimensions I may have or not have in my view, ALWAYS calculate at the following level(s) of granularity.

INCLUDE says: Even if this Dimension is not in the view, calculate using that Dimension anyway.

EXCLUDE says: Even if this Dimension IS in the view, ignore it in the calculation.

This can help, for example, when you have similar data sets but at different levels of granularity (e.g., Sales by ZIP but Sales Targets by State).

If your intent is to compare "similar" customers, then LOD's can help get you to a consistent calculation granularity to help with the comparison.  But you still have to do the comparison as a separate activity.

How you determine what "similar" means is completely different problem.

1 of 1 people found this helpful
• ###### 8. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Hello Deepak,

Would there be a difference between referencing multiple fields in the Fixed LOD vs. creating a combined field of the fields and using that?

• ###### 9. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Good Question, Answer is there wont be any difference. See attached.

Thanks

Deepak

1 of 1 people found this helpful
• ###### 10. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Check this too

• ###### 11. Re: Can someone explain what a fixed LOD does with multiple dimensions?

Thanks Deepak. I heard that combined fields can cause your dashboard to be slower so I think I will avoid if they provide the same results.