14 Replies Latest reply on Apr 23, 2018 9:54 AM by Vamsi Challa

Expression is too complex (Filtering)

Hello

I'm creating a dashboars with data live directly from a tableau server, Since it has a lot of data I'm applying filters and simply adding condition + formula to norrow down and retrieve the data I need, but this time I'l applying a formula with over 1,200 lines. I get this error:

"Expression is too complex" when applying the formula to the filter.

Does anyone know how to fix it?.

• 1. Re: Expression is too complex (Filtering)

Can you share your overly complex formula?

• 2. Re: Expression is too complex (Filtering)

Hello Tim! is basically the following:

IF [Cost Center (CC)] = "XXXXX"

OR[Cost Center (CC)]="XXXXY"

("OR" line with different combinations over and over below"

THEN TRUE

ELSE FALSE

END

• 3. Re: Expression is too complex (Filtering)

Do you have 1200 cost centers?

• 4. Re: Expression is too complex (Filtering)

Yeap, the data source has cost centers globally and there are way too many, 1,200 - 1,300 are just the ones I need

• 5. Re: Expression is too complex (Filtering)

You are going to need to do things like grouping the cost centers by geographic location or create a hierarchy that allows you to move down by something other than using logical OR's 1200 times.  If you can share your twbx file or at least a text file of the calculated field, I would be happy to take a look.  I have some free time this week.

• 6. Re: Expression is too complex (Filtering)

Thank you so much!

as far as now, is there a simple way for you to show me how to group? maybe that'll be helpful

• 7. Re: Expression is too complex (Filtering)

Are you filtering data @Filters(Edit Data Source filters) or @ worksheet level (using Calculated field)?

• 9. Re: Expression is too complex (Filtering)

I'm doing in directly in the work sheet, on the filter - condition- formula.

• 10. Re: Expression is too complex (Filtering)

Write it as a calculated field and then put the field into the filter with a  value of TRUE.

• 11. Re: Expression is too complex (Filtering)

Thank you Tim!

I'm thinking about your idea of making sets regionally so the filters data is smaller and grouped that would solve it

but do you know is there's a way I can group all of those filters and get them as one in the actual dashboard?

• 12. Re: Expression is too complex (Filtering)

I'm doing in directly in the work sheet, on the filter - condition- formula.

• 13. Re: Expression is too complex (Filtering)

You may also find it helpful to look at the free online training available from the Tableau Home Screen.  It may take some time to complete, but it will make your life much easier.

• 14. Re: Expression is too complex (Filtering)

In this case - Calculated field - either - "IF Contains" or "Case" operators should work. Just a turn around. If not please ignore.

Logical Functions