OPX Data
OPX Data
  • 40
  • 210 031
Tableau Calculations and Level Of Details (LOD)
In this video of tableau explained, we will look at the different type of calculations in tableau and understand the concepts behind them.
👉 Order of operation explained:th-cam.com/video/lTvLMYcqWck/w-d-xo.html
0:00 Intro
0:17 Overview
0:35 Basics overview
0:35 Types of basic calculation
1:33 Row level calculation - Concept
2:04 Aggregation - Concept
2:26 Tableau demo
2:36 Aggregation - default
3:10 String Manipulation
3:22 Split
4:23 Aggregation - sum
4:30 Aggregation - average
4:38 Example of row level vs aggregation
4:53 Row level - Arithmetic calculation
6:04 Problem with row level calculation on aggregation
6:10 Aggregation vs row level explained
7:11 Problem fixed: aggregation
7:48 Table Calculation - overview
8:05 Table Calculation - key concepts
8:15 Table Calculation - demo
9:06 Table Calculation - Calculation type
10:05 Table Calculation - Direction
11:33 Table Calculation - Level
13:34 Level of Details - Intro
13:52 Key concept in LOD
14:14 Types of LOD calculations
14:33 LOD table setup
15:06 LOD calculation syntax
15:40 Fixed LOD explained
16:02 Fixed LOD validation
16:22 Exclude LOD explained
17:15 Exclude LOD validation
17:39 Include LOD explained
18:00 Include LOD example
18:35 Include LOD validation
👍 If you enjoy this video, please like and share it.
🔔 Don't forget to subscribe to this channel to stay notified of new videos:
th-cam.com/users/OPXDataAnalytics
☕ If you would like to buy me a coffee:
paypal.me/opxdata
🔥Checkout the playlist to find more tips and tricks:
th-cam.com/play/PLpHJ_PjqnioijTdyTtLzakb7fr8jzluP9.html
🔥Watch other Videos:
👉 Tableau Ultimate Guide to comparing time period: th-cam.com/video/txm2zE1sdJ8/w-d-xo.html
👉Data Scientist vs Data Analyst vs Data Engineer : th-cam.com/video/olGI1NHa5z0/w-d-xo.html
👉 Tableau - Dynamic update of title and headers: th-cam.com/video/Y7wfNUvmjck/w-d-xo.html
มุมมอง: 102

วีดีโอ

Tableau Filters and order of operations
มุมมอง 13211 หลายเดือนก่อน
In this video of tableau explained, we will look into the different types of filters to learn how and why to use them and also understand the Example where context filter needs to be considered 👉 Fix incorrect Rank Filter: th-cam.com/video/5WEwpN3QzdA/w-d-xo.html 0:00 Intro 0:15 Extract Filter 0:58 Data Source Filter 4:10 Context Filter 5:55 Dimension and Measure Filter 7:48 Table Calculation 👍...
MUST READ for Data Analyst! Takeaways from Storytelling with Data
มุมมอง 585ปีที่แล้ว
In this video, i share my summary and takeaways from the book: Storytelling with Data 00:00 Intro 00:13 Personal Opinions 01:17 Context 02:00 Effective Visuals 03:36 Design Principles 05:42 Audience Attention 06:07 Think like a designer 10:32 Storytelling Find the book on amazon: amzn.to/44Eq4ph
How to Create a Chart for Rolling Month Comparisons - Tableau Tips
มุมมอง 2Kปีที่แล้ว
Here on another episode of tableau tips, we will learn how we can do a rolling month calculation to compare 12 rolling month/6 rolling month against the monthly results 0:00 Intro 0:15 Window calculation logic 1:45 Validating rolling month calculation 2:35 Creating Charts and potential problem 3:21 Combining final chart 3:55 Other examples of use case: running total, rolling month average 👍 If ...
How to Sort Data in Tableau
มุมมอง 3.6Kปีที่แล้ว
In this guide on tableau, we will learn basics to sorting and tricks on how to sort with multiple columns and values 0:00 Intro 0:13 Basic Sort - 1 column 0:48 Basic Sort - 2 column 1:33 Nested Sort 2:44 Logic - Sort on second column on entire table 3:27 Solution - Sort on second column on entire table 4:54 Dynamic sorting - select column 6:41 Dynamic sorting - select measure 👍 If you enjoy thi...
How to hide measure names from filter - Tableau Tips
มุมมอง 6Kปีที่แล้ว
Here on another episode of tableau tips, we will learn how we can hide and restrict the list of measure names available for the users 0:00 Intro 0:11 Use Case 1 1:11 Solution Logic 2:12 Solution - duplicate data source 3:36 Use Case 2 4:18 Solution - parameters 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new videos: th-cam...
How to Dynamically Update Column Headers and Titles in Your Tableau Dashboard - Tableau Tips
มุมมอง 5Kปีที่แล้ว
Here on another episode of tableau tips, we will look at how we can create dynamic title and custom column headers 0:00 Intro 1:20 Dynamic Title 1:35 Formatting dynamic date title 2:43 Setting up dynamic column headers 5:15 Aligning column headers with containers 6:52 Tips on how to work with conatiners 7:41 Formatting column headers and table 9:20 Demo 10:05 Line break column header 👍 If you e...
Hacks to filtering dates in Tableau - Tableau Tips
มุมมอง 2.6Kปีที่แล้ว
Here on another episode of tableau tips, we will look at alternative ways of how to filter dates in tableau 0:00 Intro 0:23 Basic date filters 1:38 Demo on using one parameter as filter 3:14 Using parameters as start and end date filter 6:45 Selecting data points as filter 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new vi...
66 days of data - Learning Power BI
มุมมอง 1.9Kปีที่แล้ว
As inspired by Ken Jee's #66daysofdata , I decided to try this out and learn Power BI. In this video, I documented my journey of how i started, what i did for these 66 days. 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new videos: th-cam.com/users/OPXDataAnalytics 🙏 If you would like to show some appreciation: paypal.me/opx...
How to Perform Basic Date Functions in Tableau
มุมมอง 9Kปีที่แล้ว
Here on another episode of tableau tips, we will look at the basic date functions: what are they, how they can be used. 0:00 Intro 0:37 Text to Date 1:48 DATEPARSE 2:33 DATE 3:07 How to get parts of date 3:17 Text part of dates - DATENAME 4:08 Numerical part of dates - DATEPART 4:32 What is start of week option 5:39 Use case of start of week 5:55 Start of the week - DATETRUNC 7:15 Start of mont...
SQL Crash Course for data analyst: Learn SQL in under 20 mins!
มุมมอง 9Kปีที่แล้ว
In this crash course, you will learn the basics to sql in under 20mins. You will learn what you need to at least know as a data analyst. sql online: www.w3schools.com/sql/trysql.asp?filename=trysql_select_where 00:00 Intro 00:47 select 01:54 where 02:25 like 04:08 order by 05:20 into 05:45 aggregation 07:21 groupby 08:25 case 09:35 Logical operator: AND, OR 12:05 join 15:14 left join vs inner j...
How to calculate percentages - Tableau Tips
มุมมอง 2.7Kปีที่แล้ว
Here on another episode of tableau tips, learn how to calculate percentages and percentage difference in tableau 0:00 Intro 0:10 Percentage differences 0:43 Percentage between 2 values 👍 If you enjoy this video, please like and share it. 🔔 Don't forget to subscribe to this channel to stay notified of new videos: th-cam.com/users/OPXDataAnalytics 🙏 If you would like to show some appreciation: pa...
Ultimate Guide: How to compare time periods in Tableau
มุมมอง 12Kปีที่แล้ว
Here on another episode of tableau tips, we will look at the different types of analysis involved with comparing dates and time. We will look at how to compare yearly trend, how to calculate percentage differences to compare YOY,QOQ,MOM results. We will also look at how we can do Period to date calculation such as YTD, QTD, MTD. 0:00 Intro 0:12 Overview of the type of time comparison 0:35 Yearl...
Stacked bar chart with 2 measures - Tableau Tips
มุมมอง 16Kปีที่แล้ว
Here on another episode of tableau tips, learn how to create bar charts with multiple measures and see how to add percentage of total label for separate measures on stacked bar chart 0:00 Intro 0:14 2 separate bar charts for each measures 01:02 how to create stacked bar chart with multiple measures 02:18 side by side bar chart 02:39 intro to add proportion % on bar chart 03:08 default proportio...
Hide item filter options - Tableau Tips
มุมมอง 966ปีที่แล้ว
Here on another episode of tableau tips, learn how to hide specific items from the list of filter options 0:00 Intro 0:43 Solution 🙏 If you would like to show some appreciation: paypal.me/opxdata 🔔 To stay notified of new videos, subscribe here: th-cam.com/channels/RPYChgxw1QjFV5ognREhGg.html 👉Checkout the playlist to find more tableau tips and tricks: th-cam.com/play/PLpHJ_PjqnioijTdyTtLzakb7f...
How to Fix Incorrect Rank and Rank Total | Tableau Tips
มุมมอง 698ปีที่แล้ว
How to Fix Incorrect Rank and Rank Total | Tableau Tips
Data Scientist vs Data Analyst vs Data Engineer
มุมมอง 21Kปีที่แล้ว
Data Scientist vs Data Analyst vs Data Engineer
Hide specific subtotal that has only one row - Tableau Tips
มุมมอง 5K2 ปีที่แล้ว
Hide specific subtotal that has only one row - Tableau Tips
Sync Axis Across Multiple Charts, Measure Values - Tableau Tips
มุมมอง 3K2 ปีที่แล้ว
Sync Axis Across Multiple Charts, Measure Values - Tableau Tips
Table and Inline Charts - Tableau Tips
มุมมอง 3.3K2 ปีที่แล้ว
Table and Inline Charts - Tableau Tips
Pivot Table | Dynamic Table - Tableau Tips
มุมมอง 4.4K2 ปีที่แล้ว
Pivot Table | Dynamic Table - Tableau Tips
P&L Table | Data Densification | Custom Subtotal | Color Headers - Tableau Tips
มุมมอง 1.3K2 ปีที่แล้ว
P&L Table | Data Densification | Custom Subtotal | Color Headers - Tableau Tips
Toggle Button Custom - Tableau Tips
มุมมอง 6K2 ปีที่แล้ว
Toggle Button Custom - Tableau Tips
Switch/Toggle Charts, Data - Tableau Tips
มุมมอง 2K2 ปีที่แล้ว
Switch/Toggle Charts, Data - Tableau Tips
Reset All Filters - Tableau Tips
มุมมอง 19K2 ปีที่แล้ว
Reset All Filters - Tableau Tips
Custom Shapes - Tableau Tips
มุมมอง 1.8K2 ปีที่แล้ว
Custom Shapes - Tableau Tips
Apply All Button for filter and parameter - Tableau Tips
มุมมอง 22K2 ปีที่แล้ว
Apply All Button for filter and parameter - Tableau Tips
Tableau Basics 10 - How to build tableau dashboard | Tableau dashboard design
มุมมอง 1.9K2 ปีที่แล้ว
Tableau Basics 10 - How to build tableau dashboard | Tableau dashboard design
Tableau Basics 9 - How to use Groups/Sets
มุมมอง 2K2 ปีที่แล้ว
Tableau Basics 9 - How to use Groups/Sets
Tableau Basics 6 - Creating Calculations
มุมมอง 4.5K2 ปีที่แล้ว
Tableau Basics 6 - Creating Calculations

ความคิดเห็น

  • @jennykuwn
    @jennykuwn 13 วันที่ผ่านมา

    Thank you.

  • @ParagSahasrabuddhe
    @ParagSahasrabuddhe 27 วันที่ผ่านมา

    How to combine both?

  • @rodolfopresa2821
    @rodolfopresa2821 หลายเดือนก่อน

    THANK YOU SO MUCH!!!!! SPENT HOURS TRYING TO FIGURE THIS OUT!

  • @elwyndude
    @elwyndude หลายเดือนก่อน

    OMG OMG OMG this was EXACTLY what I was looking for... amazing thank you thank you thank you

  • @TheQueenEPK
    @TheQueenEPK หลายเดือนก่อน

    This was so easy to follow! Thanks!

  • @kusumgupta8831
    @kusumgupta8831 2 หลายเดือนก่อน

    You have hidden the product name in the process of hiding extra row, what kind of stupid video is this

  • @AmaDavies
    @AmaDavies 2 หลายเดือนก่อน

    Thanks so much! Great job!

  • @ppjn348
    @ppjn348 2 หลายเดือนก่อน

    Are we able to still sort the data with this method?

  • @pattybaselines
    @pattybaselines 2 หลายเดือนก่อน

    You are awesome. Thank you.

  • @TheSeveer123
    @TheSeveer123 2 หลายเดือนก่อน

    I have an interview coming up and this video was extremely useful. Thank you for being so cute and smart 🙏🤍

  • @AI-hn1nr
    @AI-hn1nr 3 หลายเดือนก่อน

    Exactly what I was looking for. Thank you! 👍

  • @nismokid
    @nismokid 3 หลายเดือนก่อน

    Just want to say you do an excellent job in providing an easy to follow instructions with great examples! Thank you very much!!

  • @JillianSolomon-hm7qj
    @JillianSolomon-hm7qj 3 หลายเดือนก่อน

    Thank you for this! Love your content and I am hoping you know how to solve for doing some sort of fixed rank. I always have an issue setting up a rank calculation that does not change when a name filter is applied. An example is rank(sum(profit)) works for a list of employees, and let's say Joe is ranked number 3, but when I filter for Joe's name, his rank is now 1 instead of 3. Any ideas how to solve? I always solve for it in the query but would be nice to have a Tableau fix too. Thank you!

  • @ZheyuanZ
    @ZheyuanZ 4 หลายเดือนก่อน

    Thanks you so muchhhhhhhhhhhhh!!!! I have been struggling on this for 3 hours, it is so hard to integrate different measures together inside on chart. Really helpful!

  • @deepti61
    @deepti61 4 หลายเดือนก่อน

    Kudos to you👏 , You explained the SQL codes so well.

  • @RhushikeshHiralalChavan
    @RhushikeshHiralalChavan 4 หลายเดือนก่อน

    Great video! I will solve multi select parameter option problem But it is not working with filters there is any way like i dashboard we use the filters that also applied to this data source

  • @hetilemabunda9705
    @hetilemabunda9705 4 หลายเดือนก่อน

    This was so helpful, so glad I found this channel!

  • @edgarvasquez47
    @edgarvasquez47 4 หลายเดือนก่อน

    Exactly what I was looking for. Thanks!!

  • @gabonicabas
    @gabonicabas 4 หลายเดือนก่อน

    Great video. Thanks for sharing.

  • @BradStone-1
    @BradStone-1 5 หลายเดือนก่อน

    Thanks for the video. I created a toggle button like the one shown in the video. However, the toggle button must be double clicked in order to switch between values. It appears that when the button is clicked, it "selects" the button and triggers the Tableau action which properly switches the chart. However, the next click appears to "deselect" the button and does not trigger the action. Another click "selects" the button which triggers the action and the chart changes. It is hard to tell, but at the end of the video, it looks like the button in your example may have been double clicked to change the chart after the first click. Is this true? If so, is there a way to make it work so that a double click is not required? Tableau v2023.1.7

  • @burujulaseenu2388
    @burujulaseenu2388 5 หลายเดือนก่อน

    Hi, how you are moving with the blank container as well. Can you please explain

  • @burujulaseenu2388
    @burujulaseenu2388 5 หลายเดือนก่อน

    Hi, how amyou are moving by holding with blank container as well

  • @KevinWee90
    @KevinWee90 5 หลายเดือนก่อน

    This is a life saver!

  • @vigneshwaranm5836
    @vigneshwaranm5836 6 หลายเดือนก่อน

    How to show min and max labels for two measures in the stacked bar chart?

  • @thepenguin74
    @thepenguin74 6 หลายเดือนก่อน

    I have been looking for this -whith this detailed explanation- for hours. Thanks.

  • @user-nl7fx2th7p
    @user-nl7fx2th7p 7 หลายเดือนก่อน

    I tried to execute this step by step. When I then try to alter the selections in a multi-select dropdown on my dashboard, it triggers a query as soon as I click on any checkbox in the list. I was expecting it to not do anything at all, until I click the Apply Filters button I created. Am I missing something?

    • @zsBears
      @zsBears หลายเดือนก่อน

      Were you able to figure this out? have same issue

  • @mounikapulijala1327
    @mounikapulijala1327 8 หลายเดือนก่อน

    Please let me reason apply filter not working for one click...when i double click then its working

  • @Codewithmechs1996
    @Codewithmechs1996 9 หลายเดือนก่อน

    Why do we have to put the fields in detail tab can anyone explain

  • @sushilkokil1997
    @sushilkokil1997 9 หลายเดือนก่อน

    Thanks for the video....

  • @abhishek12865a
    @abhishek12865a 9 หลายเดือนก่อน

    Thank you so much dear I have been searching for this from long time

  • @abhishek12865a
    @abhishek12865a 9 หลายเดือนก่อน

    Thank you so much dear

  • @srikantbattula8408
    @srikantbattula8408 10 หลายเดือนก่อน

    great video

  • @garypansino2484
    @garypansino2484 10 หลายเดือนก่อน

    Great video! Exactly what I was wrestling with. Thank you.

  • @robespierre2575
    @robespierre2575 11 หลายเดือนก่อน

    Life saver!!!

  • @user-xz2ig2dh5t
    @user-xz2ig2dh5t 11 หลายเดือนก่อน

    I have the same question - will this method work for more than 2 measures? I am working with 5 measures

  • @ericpeterson6822
    @ericpeterson6822 11 หลายเดือนก่อน

    Wah this came at the right time.I am doing a project and these tips are helping me a lot! Thanks so much lah! Btw here's a suggestion. Can you do a video on what kinda qualifications and skills recruiters look for in an entry level data analyst position in SG?

    • @OPXDataAnalytics
      @OPXDataAnalytics 11 หลายเดือนก่อน

      I do have a video that talks about skills needed for data analyst. Not specifically from recruiter point of view, but it’s applicable to get an idea of what is required for the role. Data Scientist vs Data Analyst vs Data Engineer th-cam.com/video/olGI1NHa5z0/w-d-xo.html

  • @user-sh8ct5rx5w
    @user-sh8ct5rx5w 11 หลายเดือนก่อน

    THANK YOU ITS REALLY AMAZING

  • @vamsireddy5051
    @vamsireddy5051 11 หลายเดือนก่อน

    Great video, Thanks

  • @vamsireddy5051
    @vamsireddy5051 11 หลายเดือนก่อน

    Really great tip, liked it, Thanks,👍

  • @akak1816
    @akak1816 ปีที่แล้ว

    Hi, great video. But can you show how to created the Report Date parameter?

    • @OPXDataAnalytics
      @OPXDataAnalytics 11 หลายเดือนก่อน

      learn how to create parameter: th-cam.com/video/BVJGFp4S4AI/w-d-xo.html filtering with date parameter:th-cam.com/video/ZmPOD6zS5wk/w-d-xo.html Hope this helps

  • @rajainam1985
    @rajainam1985 ปีที่แล้ว

    and does this will work if we select different dimensions from filter?

  • @rajainam1985
    @rajainam1985 ปีที่แล้ว

    great video thanks! q quick question, can we add max ref line for two dual axis charts side by side

  • @jacobs8531
    @jacobs8531 ปีที่แล้ว

    Amazing

  • @user-xg9is2qi5i
    @user-xg9is2qi5i ปีที่แล้ว

    Even you can make this kind of dynamic column header by using this very complicated method. But if user export the data into Excel, these column headers won't go together with the data. In Excel, they will be lost what they are looking at because no column header.

    • @haniharun3267
      @haniharun3267 4 หลายเดือนก่อน

      is there any simpler method without using many objects? else need try this way. Thank You, OPX Data.

  • @jameshalko8713
    @jameshalko8713 ปีที่แล้ว

    Not sure if this method works for more than two measures. Or at least when I tried adding multiple toward the end it did not end up right.

  • @joaofstock
    @joaofstock ปีที่แล้ว

    Thanks for helping. It does work in a single sheet and it's amazing. However, when I make a dashboard I don't have the option to apply the filter to the other sheets.

    • @user-hj1em3fy7u
      @user-hj1em3fy7u ปีที่แล้ว

      if you use the multiple data sources solution i guess this would make sense since a filter prolly is bound by its data set and doesnt work across data sets?

  • @ousmaneniass550
    @ousmaneniass550 ปีที่แล้ว

    Hi , I have a requirement to give Dimension Names as a filter : I have many Dimensions like A,B,C....... i am creating a Tabular view with all of these dimensions, and i have to give Dimension names as a Multiple values select filter so that we can select multiple Dimension names from filter.If i select A,B then my table should have only Dimensions A and B , if i select A,C table should have only A and C like this. Parameter workaround will not work for this requirement because i have to select multiple values. I found same question in Community but i didn't find answer. Any Ideas ?

    • @anishsingh2460
      @anishsingh2460 5 หลายเดือนก่อน

      have you found the answer to it @ousm

  • @user-vy8pf8ne3e
    @user-vy8pf8ne3e ปีที่แล้ว

    When I publish the dashboard to tableau server. The dashboard still starts loading after change in each filter. Loading still does not change any data. How do I overcome this issue.

    • @yurizhang178
      @yurizhang178 ปีที่แล้ว

      Hi, I also encountered this issue. Have you solved this?

  • @adityaaranya6477
    @adityaaranya6477 ปีที่แล้ว

    Amazing explanation, overall great video! :) I just have one small issue, I have followed each and every step as is, when I do the selection I am getting values for the last filter I selected. Say if I just select region then I am getting just the region on all the KPI cards, but I have a country KPI, a region KPI and a store KPI, each should show unique value on each selection, but it is showing just last filter value on on each KPI card.

    • @OPXDataAnalytics
      @OPXDataAnalytics ปีที่แล้ว

      Yes, that happens. You will need to combine it with a clear all filter button. You can check the guide here: Reset All Filters - Tableau Tips th-cam.com/video/M6nqrGe3COo/w-d-xo.html

  • @Murtaza010
    @Murtaza010 ปีที่แล้ว

    Great! Short and to-the-point video. 👍