Tableau's most powerful function: The Fixed Function

In this video I will demonstrate the power of the "Fixed" function in Tableau.
The fixed function can be used to enrich ordinary dimensions or event-based data sets without needing to create additional joins, or write complex SQL.
To learn the basics of Tableau, check out my guide for beginners here - www.projectbi.net/what-tablea...
Interested in learning SQL? My guide, SQL for dummies will help you get started - www.projectbi.net/sql-for-dum...

[@nathanthreeleaf4534]

I had never heard of the FIXED function being explained as a "For Each" iteration, which makes a lot of sense to me having Python experience. This really helped me grasp the concept of how and when to use it. Nice work

[@panic_seller]

very new to Tableau and this function literally saved my life, I still don't know what it's doing but it works

[@scottstewart1660]

This is the best explanation of how the FIXED LOD works. Thank you.

[@theanalystsplaybook]

I'm glad you found it useful Scott. Thanks for the comment. -Justin

[@maximilianodelatorre2513]

I love how you explained it! It was just what I need 😁😁😁😁😁😁

[@theanalystsplaybook]

I'm really glad to hear that the video was helpful to you Maximilliano. Thanks for your comment and support for the channel. -Justin

[@beginnerpython6183]

Thank you for sharing this useful tableau tips

[@theanalystsplaybook]

You are most welcome

[@hannadmytriieva8414]

Hi Justin, thanks for the video. Trying to calculate days between orders and group customers, on how many days it took them to do second, third.. order. But do not get it how to do it. Can you help please?

[@theanalystsplaybook]

Hey Hanna. Unfortunately you can't do that using the fixed function. You'll first need to rank the orders per customer which you'll need to do outside of Tableau. Once you've added the rank as a new column, you could then use fixed, rank and datediff to calculate time between first order and 2nd, 3rd, 4th order etc. This is a tricky one. The hardest part is adding the rank. If you're using the super store data set then you may need to import it into a database so you could then run some SQL on it. Might be able to do it in Excel but I'm not familiar with ranking in Excel, it's been a long time since I did that.