Prof Califf
Prof Califf
  • 20
  • 130 037
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)
Переглядів: 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

КОМЕНТАРІ

  • @Chadum_aroi
    @Chadum_aroi 2 місяці тому

    thank you so much you're truly hero

  • @mehboobmg28
    @mehboobmg28 3 місяці тому

    Total waste of time

  • @renin2544
    @renin2544 4 місяці тому

    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.

  • @MaxOnTheRun
    @MaxOnTheRun 6 місяців тому

    You're Awesome!

  • @SantiagoAlonso-gm8qg
    @SantiagoAlonso-gm8qg 8 місяців тому

    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!

  • @jyotikafaldu5495
    @jyotikafaldu5495 8 місяців тому

    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

  • @lavaforce-overwatchmoments9848

    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!!

  • @21kcsuman
    @21kcsuman Рік тому

    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.

  • @RogueStarIdeageering
    @RogueStarIdeageering Рік тому

    Is there a way to connect for some assistance?

  • @rudra__singh
    @rudra__singh Рік тому

    I was stuck at this point, all of the filters were not resetting. Thanks👍

  • @varunkumar-hv5sz
    @varunkumar-hv5sz 2 роки тому

    how to avoid blank screen on dashboard while all filter deselect in tableau

  • @abhishekkumaragrawal1372
    @abhishekkumaragrawal1372 2 роки тому

    in mine that green and red tick are not coming ,only getting 2 option "default" and "filled" .no "KPI"

  • @jasonwilkinson8384
    @jasonwilkinson8384 2 роки тому

    perfect explanation. thanks.

  • @ColoursOfTheNature93
    @ColoursOfTheNature93 2 роки тому

    Could you please make a video on depreciation of asset calculation?

  • @nikhiljha6405
    @nikhiljha6405 2 роки тому

    Hi Prof, Could you also show us how to deselect all filter values using reset button?

  • @naughtyneel82
    @naughtyneel82 2 роки тому

    Calculated column "Reset FIlter" will not be visible when there is no data ,how to Handel such scenario ?

  • @sumit_kulkarni
    @sumit_kulkarni 2 роки тому

    Does it work without internet.

  • @the_kombinator
    @the_kombinator 2 роки тому

    Excellent - all of it.

  • @tableaututorialstips71
    @tableaututorialstips71 2 роки тому

    Could you please share in details with some examples Window functions

  • @tableaututorialstips71
    @tableaututorialstips71 2 роки тому

    it is very nice video and thanks for sharing ,Liked Shared and Subscribed :)

  • @lauriesch
    @lauriesch 2 роки тому

    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!

  • @tableaututorialstips71
    @tableaututorialstips71 2 роки тому

    Sub,Sha,Liked done thanks for this :)

  • @zubairahmed-nt8ml
    @zubairahmed-nt8ml 2 роки тому

    waste of time...watching this...what you show in the ppt and what you did in tabeau is two different things'

  • @ericgoodman6101
    @ericgoodman6101 2 роки тому

    Awesome 👌 this is really helpful 👍

  • @krounke8388
    @krounke8388 2 роки тому

    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 ?

    • @profcaliff9753
      @profcaliff9753 2 роки тому

      I don't have any Excel tutorials yet, but likely will soon.

  • @whitestork2000
    @whitestork2000 2 роки тому

    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

  • @reisjake
    @reisjake 2 роки тому

    Thank you so much! This worked 1st try. Very helpful and easy for a newer user like me to understand.

  • @antoniushka
    @antoniushka 2 роки тому

    Great! I had the same problem and couldn't figure out the solution! Thank you!

  • @ManojYadav-mo3ei
    @ManojYadav-mo3ei 2 роки тому

    Please create the video show hide fillters

  • @tusharpawar9666
    @tusharpawar9666 2 роки тому

    but i am not able to find any option for live azure connection plz reply

    • @profcaliff9753
      @profcaliff9753 2 роки тому

      I am not sure what you mean. Could you please explain a bit more?

  • @Dandyydd
    @Dandyydd 2 роки тому

    Thank You so much, its so helpfull

  • @achinthya97
    @achinthya97 2 роки тому

    can u explain how you did that navigation part with all filters ?

    • @profcaliff9753
      @profcaliff9753 2 роки тому

      Here is how to create the action-oriented (interactive) dashboard I used in the video: ua-cam.com/video/jdpALi_Y4hQ/v-deo.html

  • @V_DA
    @V_DA 2 роки тому

    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.:)

  • @j2rhcyz
    @j2rhcyz 2 роки тому

    I was struggling with this for couple of days. This is realllllly helpful! Thank you so much for explaining clearly.

  • @rithiktiwari3752
    @rithiktiwari3752 2 роки тому

    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.

  • @ducjoshnguyen
    @ducjoshnguyen 2 роки тому

    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.

  • @rmotlhanka
    @rmotlhanka 2 роки тому

    Thank you,,,

  • @KleRoi
    @KleRoi 2 роки тому

    Thanks this was very useful!

  • @skt2lhr
    @skt2lhr 3 роки тому

    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?

    • @profcaliff9753
      @profcaliff9753 2 роки тому

      Hi sky2lhr, I apologize for the delay. I am not sure - I was using 2020 I believe. But it's certainly worth a try.

  • @Chowmeingeejah
    @Chowmeingeejah 3 роки тому

    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?

  • @niklas8074
    @niklas8074 3 роки тому

    Thank you so much, easy to understand, does what it should and worked perfectly fine on the first try.

  • @heathersowards8546
    @heathersowards8546 3 роки тому

    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

  • @purvasawant9342
    @purvasawant9342 3 роки тому

    What tableau version are you using I cant see a button in my objects

    • @profcaliff9753
      @profcaliff9753 3 роки тому

      The video was recorded several months ago. I believe it was 2021.1, but may be mistaken. Hope this helps.

    • @profcaliff9753
      @profcaliff9753 2 роки тому

      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!

  • @TonyChangTaiwan
    @TonyChangTaiwan 3 роки тому

    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!

  • @JiminPark-ld2xx
    @JiminPark-ld2xx 3 роки тому

    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.

  • @ducjoshnguyen
    @ducjoshnguyen 3 роки тому

    Thank you so much with the reset/clear filter solution.

  • @RameshCh-me8jm
    @RameshCh-me8jm 3 роки тому

    This is so good easy to understand and thanks for sharing. The way you teaching is so beautiful ❤️

  • @youngeconomicforum3101
    @youngeconomicforum3101 3 роки тому

    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

    • @profcaliff9753
      @profcaliff9753 3 роки тому

      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!

  • @NiteshSingh-rv2sh
    @NiteshSingh-rv2sh 3 роки тому

    please provide the data so that i can follow along.

    • @profcaliff9753
      @profcaliff9753 3 роки тому

      Here is a link to the data. Enjoy! github.com/parulnith/Recreating-Gapminder-in-Tableau