Tableau's most powerful function: The Fixed Function

Подписаться 465

Просмотров 9 тыс.

50% 1

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....
Interested in learning SQL? My guide, SQL for dummies will help you get started - www.projectbi....

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 10

@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 10 месяцев назад

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

@hannadmytriieva8414 3 года назад

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.