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

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

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

@theanalystsplaybook

2 жыл бұрын

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

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

Thank you for sharing this useful tableau tips

@theanalystsplaybook

3 жыл бұрын

You are most welcome

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

3 жыл бұрын

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.