How we Reduced 98.9% Load Time for a Tableau Viz that used Multiple OR Conditions?

If you don’t write efficient calculations, it can slow down your dashboard.

In this article, we will show you how to speed up OR statements with multiple conditions in Tableau.

You can also look this video to see how we did it!

The Workbook Loaded in 41 Seconds

The dataset had information about flights.

We wrote a simple calculation to compare a value against a list of values:

The workbook took 41 sec to load.

The above calculation has a series of conditions that get evaluated one by one.

The more conditions you have, the more time it takes.

The more rows (data) you have, the more time it takes.

We Modified the Calculation to use ‘IN’ function.

IN statement directly compares a dimension against a list—much simpler & faster.

So, we modified the calc to use IN statement instead of the OR statement.

Now, the same workbook took 29 sec to load in Tableau—that is 29% less time.

To improve further, we switched to an Extract connection.

Then, it took just 0.43 sec—98.9% less time!

To Conclude

When you want to compare a value against a list of values, IN function would perform better than OR function.

At Perceptive Analytics, we help organizations build a solid data foundation with our Power BI consultant expertise, scalable Power BI consulting solutions, and end-to-end Tableau Consulting Services that drive actionable insights. With 20+ years of experience, we transform business goals into intelligent analytics outcomes.