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
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 🙏
Thanks for the feedback really appreciate it. I have done this before over at the information lab channel. th-cam.com/video/Ic4-a6jSd1E/w-d-xo.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.
@@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.
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.
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.
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. th-cam.com/play/PLRfaJ7ZL0cF6tKISv9AABedMFcQ3IgbJd.html but before I send you to that just want to be sure ive got the question understood. Let me know
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.
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
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.
@@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?
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
Thank you, it's very helpful
Your videos are really cool and helpful,learning a lot from you...thank you Tim
Nice. Probably should be called Table-Wide-Scan
VERY USEFUL VIDEO SPECIALLY FOR WHAT I WAS TRYING TO DO, THANK YOU !
You are welcome!
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 🙏
Thanks for the feedback really appreciate it. I have done this before over at the information lab channel. th-cam.com/video/Ic4-a6jSd1E/w-d-xo.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.
@@TableauTim Thanks Tim 👍 Looking forward for more from you 👍 Daily waiting for your video notification
@@TableauTim Congratulations to the proud parents! Your life will be upside down :-)
@@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.
My favourite TH-camr :)
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.
Really helpful video... thank you Tim. Can you do WINDOW_ and/or FIXED_ function in your next videos. Thanks in advance.
Really helpful
Thanks
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
Soon. Just coming back into video making again after a break on paternity leave so stay tuned.
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.
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. th-cam.com/play/PLRfaJ7ZL0cF6tKISv9AABedMFcQ3IgbJd.html but before I send you to that just want to be sure ive got the question understood. Let me know
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.
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.
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
In the Analysis Tab, select "Totals" option then choose "Column totals to top" option
@@shilpan3883 Thanks for the reply. But I want the setting by default for all worksheets.
hi Tim, may I ask you what annotation tool you're using, please? It looks great! Thanks, Franco
Using this. presentify.compzets.com/
@@TableauTim Sweet. Thanks a lot, Tim!
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
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.
@@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?
Sir you should also upload data file, because it help in practice
The data file is built into Tableau. please watch the video from the start.
Pls do some videos on tableau server
I am recording some, will release them soon. Is there topic you're interested in?
Another great suggestion. If youre able to add it here that would be a great. tableautim.canny.io/suggestions