![Prof Califf](/img/default-banner.jpg)
- 20
- 130 037
Prof Califf
United States
Приєднався 3 лют 2021
A source for visualizing data in Tableau; and other technology topics. Feel free to message me if you have any questions. Happy to make a video for you. Happy visualizing!
Tableau - All Quick Table Calculations Explained and Examples for Each
In this video, I show you how every quick table calculation works using Tableau. I use the Sample - Superstore data that comes with Tableau
This includes:
Intro (0:00)
Running total (2:05)
Difference (6:38)
Percent difference (9:00)
Percent of total (11:07)
Rank (16:02)
Percentile (18:18)
Moving average (21:43)
YTD total (25:41)
Compound growth rate (28:09)
Year of year growth (35:34)
YTD growth (44:37)
This includes:
Intro (0:00)
Running total (2:05)
Difference (6:38)
Percent difference (9:00)
Percent of total (11:07)
Rank (16:02)
Percentile (18:18)
Moving average (21:43)
YTD total (25:41)
Compound growth rate (28:09)
Year of year growth (35:34)
YTD growth (44:37)
Переглядів: 2 215
Відео
Show Top 5 for Year-Over-Year Growth
Переглядів 3122 роки тому
In this video I show you how to solve the following problem: Which five products have the highest percentage of growth in sales from 2019 to 2020? I also show you how to only show the top 5 products by creating a set and doing a keep only.
Tableau - Year Over Year Growth Line Chart & Calculated Field for Single Columns in Table
Переглядів 7 тис.2 роки тому
In the video, I show you how to make a year-over-year dual axis line chart, and a workaround for how to have a text table with a calculated field for individual columns. The data can be found here: drive.google.com/file/d/1Hqy94L_KEkiWS_rExVuYAzpcCrkY-rtM/view
Tableau - Side-by-Side Bar w/ Calc Field Label/Bar-in-Bar/Dual Axis/Synchronous Axis/Reference Line
Переглядів 7 тис.2 роки тому
In this Tableau tutorial, I show you how to create a dual/synchronized axes side-by-side bar chart, create a calculated field so that only one bar is labeled, create a reference line, and create a car-in-bar chart The data is available for download here: drive.google.com/file/d/1uywAebi27gNgYGflb-bISBN1LlbAMXCL/view
Copy and Paste Tableau into Excel Not Working - FIX
Переглядів 2982 роки тому
How to copy and paste data into Tableau from Excel if it is not working.
How to Create Waterfall Chart with Running Total Cumulative Sum
Переглядів 1,6 тис.2 роки тому
This video details the steps needed to create a waterfall chart, as well as the Running Total Quick Table Calculation (Cumulative Sum). Happy visualizing!
Tableau - Tooltip View Is Too Large to Show - Fix
Переглядів 4,6 тис.3 роки тому
How to solve the issue "View is Too Large to Show" when using the Tooltip in Tableau.
How to Add a Mapbox Map - Tableau
Переглядів 3,2 тис.3 роки тому
I explain how to add a custom mapbox map to Tableau as a background map, and provide a brief overview of maps in Tableau.
Tableau - Create Custom Filters Using Sets
Переглядів 13 тис.3 роки тому
How to create custom filters using the Sets feature of Tableau. I created the latest date filter, last 7 days filter, last 30 days filter, and years filter. Please note that the years filter (and other non-custom filters - category, sub-category, etc.) provided by Tableau will work alongside the custom set filters. If you'd like to recreate the dashboard, go to the URL below. Happy visualizing!...
Tableau - How to Create a Text Table
Переглядів 37 тис.3 роки тому
Some tips and tricks about how to create a basic text table using Tableau. Happy visualizing!
Percent Total in Tableau using CO2 Emissions
Переглядів 1,5 тис.3 роки тому
How to calculate percent of total in Tableau using CO2 emissions as the context.
How to Pivot Data in Tableau
Переглядів 5 тис.3 роки тому
An easy way to pivot data in Tableau. If you want to create visuals using this data, go to the URL below. Happy visualizing! Create a visual using this data: ua-cam.com/video/wyEVusiomjA/v-deo.html&ab_channel=ProfCaliff
Tableau - Connect Separate Data (.csv) Files into One Visual
Переглядів 9 тис.3 роки тому
How to add and connect four separate .csv in Tableau. If you'd like to use the data to create a visual, please see the URL below. Happy visualizing! github.com/parulnith/Recreating-Gapminder-in-Tableau
Create Hans Rosling's TED Talk in Tableau
Переглядів 3,2 тис.3 роки тому
How to recreate the moving visual in Han Rosling's classic TED Talk called "The Best Stats You've Ever Seen." I also show you how to connect four separate data sources (.csv files), pivot data, edit your axis, and other tips and tricks in Tableau. You can find the link to the TED Talk and download the data needed to recreate the visual below. Happy visualizing! TED Talk: www.ted.com/talks/hans_...
Tableau - Add Reset/Clear Filter Button and Fix Filter Button Not Working
Переглядів 14 тис.3 роки тому
How to add a reset filter button in Tableau. I also address a common issue regarding the reset filter not working and show how to fix it. If you want to create the dashboard in the video, go to the link below. Happy visualizing! Create a basic Tableau Dashboard with Filters: ua-cam.com/video/CvAIrwflEuE/v-deo.html&ab_channel=ProfCaliff
Tableau - How to Add a Back Button to a Dashboard
Переглядів 4 тис.3 роки тому
Tableau - How to Add a Back Button to a Dashboard
Tableau - Create Key Performance Indicators (KPIs) and Dashboard
Переглядів 10 тис.3 роки тому
Tableau - Create Key Performance Indicators (KPIs) and Dashboard
How to Download a Tableau Public Workbook
Переглядів 2,6 тис.3 роки тому
How to Download a Tableau Public Workbook
Tableau - Action-Oriented Dashboard with Four Actions and Filters
Переглядів 2,9 тис.3 роки тому
Tableau - Action-Oriented Dashboard with Four Actions and Filters
Tableau for Beginners - Interactive Dashboard - Bar Chart, Heat Map, Geo Map, Scatterplot
Переглядів 2,9 тис.3 роки тому
Tableau for Beginners - Interactive Dashboard - Bar Chart, Heat Map, Geo Map, Scatterplot
thank you so much you're truly hero
Total waste of time
Thank you!! I wasted a day trying to fix this and you saved a lot of hours i would have probabaly wasted on fixing this. There is no video out there who explained why it was not working.
You're Awesome!
Calif, thanks for the video. Just one critique, please display the results at the beginning and clearly explain what will you be trying to achieve before you do all the video on how to get there. Thanks!
Superb..nice trick to use just selected worksheet...I was trying to use all worksheet and it was not working.. thanks to solve my query and getting workable reset button
Thank you so much, this was so helpful. The Tableau function to make side by side bar was not working properly, but your method worked. This is for my work so thanks a lot!!
Clear explanation with solving the issue we all run into and I couldn't understand what was going on. Thank you! You saved the day.
Is there a way to connect for some assistance?
I was stuck at this point, all of the filters were not resetting. Thanks👍
how to avoid blank screen on dashboard while all filter deselect in tableau
in mine that green and red tick are not coming ,only getting 2 option "default" and "filled" .no "KPI"
perfect explanation. thanks.
Could you please make a video on depreciation of asset calculation?
Hi Prof, Could you also show us how to deselect all filter values using reset button?
Calculated column "Reset FIlter" will not be visible when there is no data ,how to Handel such scenario ?
Does it work without internet.
Excellent - all of it.
Could you please share in details with some examples Window functions
it is very nice video and thanks for sharing ,Liked Shared and Subscribed :)
Thank you for this! I really like your teaching style - very easy to follow and understand. How would I add new data to a pivoted table? Like adding on the latest years' income numbers? Do you have a video about that? Thank you!
Sub,Sha,Liked done thanks for this :)
waste of time...watching this...what you show in the ppt and what you did in tabeau is two different things'
Awesome 👌 this is really helpful 👍
Idk why, I'm French and UA-cam recommended this. Cool stuff, my teacher are not on UA-cam so you are better. It is and Excel Tutorial ?
I don't have any Excel tutorials yet, but likely will soon.
I am soo thankful for this, i was awake whole night trying to achieve something like this, then finally came across your video, very grateful, thanks heaps
Happy to help!
Thank you so much! This worked 1st try. Very helpful and easy for a newer user like me to understand.
Happy to help!
Great! I had the same problem and couldn't figure out the solution! Thank you!
Please create the video show hide fillters
but i am not able to find any option for live azure connection plz reply
I am not sure what you mean. Could you please explain a bit more?
Thank You so much, its so helpfull
Thanks for watching!
can u explain how you did that navigation part with all filters ?
Here is how to create the action-oriented (interactive) dashboard I used in the video: ua-cam.com/video/jdpALi_Y4hQ/v-deo.html
Your video was very helpful. I had been trying to figure out the issue for days but finally found your video which simplified the same. Thank you very much.:)
Happy I could help!
I was struggling with this for couple of days. This is realllllly helpful! Thank you so much for explaining clearly.
Thanks, glad I could help!
Greeting Sir, I am not able to create this text table as I am not seeing this 3X3 matrix of Abc as can be seen in your video at 1:56 . I am using tableau version 2020.1 If you could help me on this one.
Hi Califf, is it possible to reset a set? I created an In/Out set from a Group. I am able to reset the Group but not the set that I created from the group.
Thank you,,,
You are welcome!
Thanks this was very useful!
I am running version 2019.3.0 at work. A request came to show the Satellite view. With version 2019.3.0, would I able to add Mapbox Map as you have shown above?
Hi sky2lhr, I apologize for the delay. I am not sure - I was using 2020 I believe. But it's certainly worth a try.
Is there a way to do such a filter but to let the user be able multi-select (i.e. select data points with boolean conditions related to sets e.g. is in (set A and set B) or set C?
Thank you so much, easy to understand, does what it should and worked perfectly fine on the first try.
Good to know! Thanks for watching!
What version of tableau is this? Aren’t the new versions 2020 and beyond no longer going to allow text file/csv file connections or am I misunderstanding the tableau support page
What tableau version are you using I cant see a button in my objects
The video was recorded several months ago. I believe it was 2021.1, but may be mistaken. Hope this helps.
I found out the issue. Tableau changed the names of the dashboard objects in the newest version. The "button" is now called "Navigation." It functions the same way though. Hope this helps!
You are the only one who clearly explained to un-check the "Reset Filter" worksheet in the "Only select this worksheet" Apply Filter. This was the key reason why my "Reset Filter" did not work! Thank you!
Thanks for the comment! Happy to help!
This is the video I have been looking for. I was confused how they fill the circles. Thank you so much for making this. Keep doing.
Thanks for watching!
Thank you so much with the reset/clear filter solution.
This is so good easy to understand and thanks for sharing. The way you teaching is so beautiful ❤️
Thank you!
Hi, When we clear the action filter button how can we show default value not ‘All’ can you give us any tips. To show any one value after clearing of filters. Thanks
Hi SeekHim, Thanks for the question. I have a tutorial on creating custom filters that may help (ua-cam.com/video/T6obsS4C_i8/v-deo.html). Also I found this URL online that hopefully will help (www.tableau.com/about/blog/2015/8/how-dynamically-set-default-values-quick-filters-43563). Thanks!
please provide the data so that i can follow along.
Here is a link to the data. Enjoy! github.com/parulnith/Recreating-Gapminder-in-Tableau