Weston Palmer
Weston Palmer
  • 231
  • 1 065 487
Only Show some Filter Options - Tableau Fundamentals
Learn how to limit the default options of your drop down filters. Using "Relevant Values" does not solve the problem because all the possible values are still visible. Default filter settings, Only Show some filter options,
For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/
Check out my Tableau Public Portfolio (a little out of date) public.tableau.com/profile/weston.palmer#!/
Переглядів: 21

Відео

Reference Line Conditional Formatting
Переглядів 713 місяці тому
Conditional Formatting for reference lines is not complicated once you know the trick. Reference line conditional formatting entails creating multiple reference lines that lay on top of each other. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Support me on Patreon at www.patreon.com/WestonPalmer/creators Check out my Tableau Public Portfol...
Show rows before and after a filtered selection
Переглядів 1074 місяці тому
Learn how to show the records or row before and after a selected item using INDEX, WINDOW_SUM, and IF-THEN functions and SETS. This answers questions like - how to see selection and its relative position, rank placement, filter on a range, range filter, how to see a selection in a group. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Check o...
How to do VLookup in Tableau
Переглядів 5004 місяці тому
Learn how to replicate the Excel VLOOKUP Function in Tableau. Maybe you've had these questions? Can Tableau do VLOOKUP? How does Excel's VLOOKUP work with Tableau? How to VLOOKUP from a different data source in Tableau? Tableau Vlookup value in another table. Tableau VLOOKUP example. Tableau VLOOKUP equivalent. VLOOKUP Function in Tableau. Replicate Excel VLOOKUP function. VLOOKUP Functionality...
INDEX Function - TABLEAU Fundamentals
Переглядів 3067 місяців тому
The INDEX function is often overlooked, but I want to show you three ways I use the INDEX function. My favorite way is to use INDEX with a scatterplot to spread out, or jitter, the data points. This is a table calculation, so it can be tricky to get the function to work properly. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Support me on P...
COUNTD Function - TABLEAU Fundamentals
Переглядів 1138 місяців тому
Learn the syntax for embedding functions inside COUNTD. This can easily take your visuals to the next level because of what you can do without LOD calculations like FIXED. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Support me on Patreon at www.patreon.com/WestonPalmer/creators Check out my Tableau Public Portfolio (a little out of date) ...
ZN Function -Tableau Fundamentals
Переглядів 1529 місяців тому
Learn the syntax of ZN (zero from NULL) and walk through a real world example. Similar functionality as NZ in Microsoft Access and COALESCE in SQL Server. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Support me on Patreon at www.patreon.com/WestonPalmer/creators Check out my Tableau Public Portfolio (a little out of date) public.tableau.co...
DateDiff Function -Tableau Fundamentals
Переглядів 1329 місяців тому
Learn the syntax of DATEDIFF and see a couple examples. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Support me on Patreon at www.patreon.com/WestonPalmer/creators Check out my Tableau Public Portfolio (a little out of date) public.tableau.com/profile/weston.palmer#!/
Visualizations with only a start/stop date - Tableau Tutorial
Переглядів 314Рік тому
This is a quick and easy way to display active employees, clients, or projects over time, even if you only have a start and stop date. With the use of logical table joins, you can accomplish data densification, that will make graphing possible and allow you to dive into the details. Another great video in my Tableau Tutorial series. For consulting contracts, reach me through my LinkedIn account...
Quick way to Fix Connectionless Failure (status code=10000) -Tableau
Переглядів 1,5 тис.Рік тому
Learn how to resolve the extract refresh error Connectionless Failure (Status code=10000). This should work for any external files such as Excel files that you are using in your Tableau dashboard. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Support me on Patreon at www.patreon.com/WestonPalmer/creators Check out my Tableau Public Portfoli...
5 ways to fix the problem
Переглядів 200Рік тому
#1 problem new designers make when building dashboards is assuming Tableau's default settings are the best for your dashboard. If you constantly rely on Tableau's formatting default settings, you are not putting forth your best work. I share five(5) actionable tips you can immediate implement to take your dashboards to the next level. For consulting contracts, reach me through my LinkedIn accou...
Show Items in a List, even if no data exists - Tableau Tutorial
Переглядів 466Рік тому
This video show you how to keep all items in a list even though your filters remove the data. This method using FIXED formulas with nested IF-THEN statements and parameters. This is a very powerful concept and I've used variations of this technique in real world jobs. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Get your questions answered...
Total / Sub-total Bar in Bar Chart - Tableau Tutorial
Переглядів 423Рік тому
This video shows you how to add a total bar, or sub-total bar, to a bar chart. This will allow you to show dimension values and include a bar that sums the totals. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Get your questions answered by supporting me on Patreon at www.patreon.com/WestonPalmer/creators Check out my Tableau Public Portfol...
Tableau Tutorial - What happens when you add a month to January 31st?
Переглядів 35Рік тому
Tableau's DATEADD function is helpful, but how does Tableau handle when months have different numbers of days? When you add a month to January 30, what February date will be returned, or will it be a March date? Same question when you subtract dates. The answer to the question may impact your decisions. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston...
Tableau Tutorial - Adding a Total Line to a Line Chart
Переглядів 2 тис.Рік тому
Learn how to add a total line to an already existing line chart with multiple lines. By using a dual axis and removing the dimension on the color card, you can add a line to your line chart showing the total value, or summation. For consulting contracts, reach me through my LinkedIn account at www.linkedin.com/in/weston-palmer/ Support me on Patreon at www.patreon.com/WestonPalmer/creators Chec...
Extract Date from String (Report Titles)- Tableau Tutorial
Переглядів 143Рік тому
Extract Date from String (Report Titles)- Tableau Tutorial
Real Use Case Example for the INCLUDE function- Tableau Tutorial
Переглядів 134Рік тому
Real Use Case Example for the INCLUDE function- Tableau Tutorial
How to correct Tooltips from showing too much data? - Tableau Tutorial
Переглядів 226Рік тому
How to correct Tooltips from showing too much data? - Tableau Tutorial
Tableau Tutorial - Color White with Conditional Formatting
Переглядів 146Рік тому
Tableau Tutorial - Color White with Conditional Formatting
Where to find the color white for Conditional Formatting in Tableau (Extended Version)
Переглядів 179Рік тому
Where to find the color white for Conditional Formatting in Tableau (Extended Version)
Tableau Tutorial - Dashboard background image
Переглядів 7 тис.Рік тому
Tableau Tutorial - Dashboard background image
Walk-through 5 Real Tableau Competition Entries
Переглядів 436Рік тому
Walk-through 5 Real Tableau Competition Entries
Tableau Tutorial - Reset Parameters Filters
Переглядів 2,6 тис.Рік тому
Tableau Tutorial - Reset Parameters Filters
Things to watch for when copying / pasting worksheets between Tableau workbooks
Переглядів 596Рік тому
Things to watch for when copying / pasting worksheets between Tableau workbooks
Tableau Tutorial - Fix 3 Common Problems with Export Data Button
Переглядів 4 тис.Рік тому
Tableau Tutorial - Fix 3 Common Problems with Export Data Button
Tableau Tutorial - Layout Containers Tutorial (Horizontal, Vertical, Tiled)
Переглядів 4 тис.Рік тому
Tableau Tutorial - Layout Containers Tutorial (Horizontal, Vertical, Tiled)
Tableau Tutorial - Conditional Formatting three different ways (including totals and sub-totals)
Переглядів 1,1 тис.Рік тому
Tableau Tutorial - Conditional Formatting three different ways (including totals and sub-totals)
Tableau Tutorial - INCLUDE level of detail (LOD) function to calculate average profit margin
Переглядів 503Рік тому
Tableau Tutorial - INCLUDE level of detail (LOD) function to calculate average profit margin
Tableau Tutorial - Show Missing Axis Labels
Переглядів 1,1 тис.Рік тому
Tableau Tutorial - Show Missing Axis Labels
Tableau Tutorial - Connecting to QuickBooks
Переглядів 819Рік тому
Tableau Tutorial - Connecting to QuickBooks