Multi-row calculations in Tableau Prep | New in Tableau 2023.2

Подписаться 177 тыс.

Просмотров 3,7 тыс.

50% 1

With multi-row calculations in Tableau Prep, you can compute table calculations while preparing your data. Using clicks, not code or complex calculations, it is easier than ever to calculate the difference from, percentage difference from, and moving calculations.
Starter Flow: drive.google.com/file/d/1vqQE...
Videos & Playlists You Shouldn't miss
What is Tableau: • What is Tableau ? Exp...
How to Learn Tableau: • Tableau for Beginners:...
Tableau Desktop Crash Course: • Tableau Desktop Crash ...
Tableau Prep Course: • Tableau Prep 4 hour Co...
Tableau Functions: • Tableau functions
Tableau charts in 2 mins: • Simple Tableau Charts ...
Tableau Desktop Crash course Playlist • Tableau Desktop Crash ...
Timestamps
0:00 Intro
0:24 Setting up the flow
1:53 Creating multi-row calculations
8:56 Use cases for this feature
Join this channel to get access to perks:
/ @tableautim
#tableau #salesforce #analytics #data
Follow me on Twitter: / tableautim
My recording gear & what's on my desk. kit.co/TableauTim/desk-setup
My website: www.tableautim.com/
My Screen Annotation Tool: j.mp/3HWc4Mj
My technology Channel: j.mp/3F0d28f
Share feedback and Suggestions: tableautim.canny.io/suggestions ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.

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

17 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@stevenjeppesen4563 4 месяца назад

Brilliant explanation. Clear, articulate, on point, no sidetracks. Subscribed.

@gustavosantiago6679 Год назад

That is great, this month I had to create an Current Month vs Previous Month (even if it not appears in my bar graph), the result was table callculations and add the previous month in the date filter only for my comparisson I think this method can replace that (or part of, because my CM/PM value is a countd)

@Barryeggingbode 10 месяцев назад

Fantastic Tim thanks so much. Nowhere on the Tableau site can I find this info.

@DrJuanTaco Год назад

Hi Tim, are you going to go over the LOOKUP() part of this feature? Ive been trying to get it to work with filling in strings but I cant get it to iterate, it will only pull in a single row based on the lookup, likely because I'm not referencing the current row, I'll need to play around with it to see if I can get if/then or case statements to work with the {partition} function.

@alecmalcolm1924 Год назад

Hey! What is the expression you're using at the moment? Are you trying to "fill down" strings? I actually helped build this feature so I may be able to help you :)

@DrJuanTaco Год назад

@@alecmalcolm1924 Hi Alec, I'm attempting to fill a string column with nulls with the last available value, then continue to fill that value until a new change appears. Im using {Partition [Partition value]: {Orderby [Orderbyvalue] asc: Lookup([missingvalue], -1)} } as the base, but cant seem to make that calculation work with more logic or continue to fill. Essentially Im trying to do IFNULL([MissingValue], LOOKUP(Missingvalue],-1) along the partition. I would also like to use the values from lookup results in a logical manner, meaning compare values in the current row to the previous row and if different add a value or string.

@alecmalcolm1924 Год назад

@@DrJuanTaco Thx for the detailed explanation...totally understand what you're trying to do. Unfortunately, the LOOKUP function won't be able to accomplish your use case due to underlying implementation limitations. However, I'm excited to say we have additional functionality coming very soon (actively being worked on) which should address your "Fill Down" needs. Keep an eye out for it!

@DrJuanTaco Год назад

@@alecmalcolm1924 Thanks alot Alec! I'll keep an eye out! I worked with Libby a little bit when the multi row thing was in very early development, feel free to reach out again if you guys need a Guinea pig!

@bibidi1868 Год назад

that is nice, but i guess shift a rows group by any categorical data order by date types. Result is a current transaction_date /field/, next transaction_date /field/, previous transaction_date /field/ all in one table.

@ItsMehras Год назад

Great new feature. I wish we were able to edit directly form the formula window.

@TableauTim Год назад

Can I ask why? I thought that too but actually if I always had an interface like this for call functions I think I’d make less mistakes and have a much better way of handing over work. That said being able to tweak the function does appeal to the tinkering itch.

@ItsMehras Год назад

@@TableauTim, I agree with you about making fewer mistakes. But I like opening the formula box and learning from behind-the-scenes code.

@ItsMehras Год назад

@@TableauTim SPLIT() function is a great example here. Although Prep makes it easy for us to perform the task, you'll never really know what you are doing unless you open the formula window and play with the parameters.