The Total or (Totality) function in Tableau & Partitions

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

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

50% 1

The total function in Tableau takes whatever expression you give it and computes it for the whole data set in your partition, i.e. the totality of the data set. It's not to be confused with totalling up your data or summing up your values. Dive into this video to find out more about partitions and the function itself.
Timestamps
0:00 Intro
0:14 How the Total function works
2:25 How partitions are defined
8:20 Using Total with an Average
9:50 Outro -
#tableau #salesforce #analytics Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.

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

17 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@JR-ly6bx 2 года назад

even right clicking the avg of furniture at year and looking at the data pane, will show all the individual rows that make up that value. a good way to tell whats contributing to the value. nice video

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

Your videos are really cool and helpful,learning a lot from you...thank you Tim

@valentinagomezvega5759 Год назад

VERY USEFUL VIDEO SPECIALLY FOR WHAT I WAS TRYING TO DO, THANK YOU !

@TableauTim Год назад

You are welcome!

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

Really helpful Thanks

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

Heya, your videos are EXTREMELY WELL EXPLAINED! Thank you so much!! Any idea of when you'll do the partitions video? :) I'd love to watch it

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

Soon. Just coming back into video making again after a break on paternity leave so stay tuned.

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

Hey Tim, Thank for the daily videos. Really helpful and loved the way you explain. One suggestion : You're making videos for new version release as separate videos that's good. Also expecting all the new version updates in a single video in brief would be more helpful as well. Hope you will do it 🙏

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

Thanks for the feedback really appreciate it. I have done this before over at the information lab channel. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ic4-a6jSd1E.html it takes alot of work though and I just became a dad recently so haven't been able to do them for 2020.3 and 2020.4 but this year my workflows alot better so will maybe go back and do them or do them going forward. Tableau also have one here www.tableau.com/learn/webinars/whats-new-tableau-2020-4 for 2020.4.

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

@@TableauTim Thanks Tim 👍 Looking forward for more from you 👍 Daily waiting for your video notification

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

@@TableauTim Congratulations to the proud parents! Your life will be upside down :-)

@ilangomayandi9493 2 года назад

@@TableauTim I have values -77 and 96767 when I do a Column Grand Total I got only 96690 but I want to add the 77 instead of automatically subtract. So the result should be 96844. I tried ABS function but it works when i used on the column level, but when I do analysis--> show column grand totals it subtract the 77 instead of adding 77 to the total. Please advise how can I get the total 96844 instead of 96690. Thank you.

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

Really helpful video... thank you Tim. Can you do WINDOW_ and/or FIXED_ function in your next videos. Thanks in advance.

@Ergophis Год назад

My favourite RU-vidr :)

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

hi Tim, may I ask you what annotation tool you're using, please? It looks great! Thanks, Franco

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

Using this. presentify.compzets.com/

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

@@TableauTim Sweet. Thanks a lot, Tim!

@ajitkumarsahoo8859 2 года назад

Hi, I need some advice. If there is a category under that there is a lot sub-category. In the worksheet I have category- sub-category and exact date (Discrete) data from 2021 to 2023. How to calculate running totals of each sub-category separately till today.

@TableauTim 2 года назад

Can you share an example via imgur? I think what you need here is a run I total table calc with the computation set at the subcategory level.

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

Hey Tim. Is there any setting to always show column grand totals on top rather bottom when I add Grand Totals to my viz? Please suggest. Thanks

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

In the Analysis Tab, select "Totals" option then choose "Column totals to top" option

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

@@shilpan3883 Thanks for the reply. But I want the setting by default for all worksheets.

@Rkcuddles Год назад

Forget total for 2 seconds. Watch some videos on table calculations to learn how they work. Then come back and watch this…. Think of it as a way to preserve the table calculation inside a variable so you can further manipulate it before using it.

@darenj29 2 года назад

Hi Tim nice video, I got a question Im hoping you can help with, you mention that the Total function cant show an average of the total furniture only because its calculating the entire data and I got it but... thats exactly what I need :) I need to show the total average of each Pane in the table, for examle in this video the average for Forniture should show 466 in forniture total Pane. If you have a video explaning this can you send me the link ? if you dont have a video Ill be waiting for one. Thanks again for these videos.

@TableauTim 2 года назад

You got a timestamp for the bit your referring to in the video? I think you need to use an LOD ( Level of detail calculation) I have a 5 video series on it. ru-vid.com/group/PLRfaJ7ZL0cF6tKISv9AABedMFcQ3IgbJd but before I send you to that just want to be sure ive got the question understood. Let me know

@jannicklich2039 2 года назад

Hi Tim, do you have any solution for rolling dates and count distinct? Like amount of customers Jan - Mar, Feb - Apr,... It means overlapping partitions. Is it also possible to work with "total" or any other suggestion? I tried with window_sum -2,0 but it counts customers twice if a customer buy in January and in February. Thank you

@TableauTim 2 года назад

That would be a conditional caclculation rather than a window calc. So you create a measure for jan to March and feb to April. In each you write a condition filtering the date periods. You can then drop both into the sheet and compare the values.

@jannicklich2039 2 года назад

@@TableauTim thanks for your response! But I would like to create a line diagram with rolling date, so I would need one field,but it is not possible to use if sentence with Jan to March and Feb to april (not only these to dates, it was just a sample, it should be rolling measure 3 month) or do you see any solution?