OPX Data
OPX Data
  • 40
  • 225 887
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
มุมมอง: 152

วีดีโอ

Tableau Filters and order of operations
มุมมอง 196ปีที่แล้ว
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
มุมมอง 595ปีที่แล้ว
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
มุมมอง 2.3Kปีที่แล้ว
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
มุมมอง 4.4Kปีที่แล้ว
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
มุมมอง 7Kปีที่แล้ว
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
มุมมอง 6Kปีที่แล้ว
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.6K2 ปีที่แล้ว
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.9K2 ปีที่แล้ว
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
มุมมอง 9K2 ปีที่แล้ว
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!
มุมมอง 10K2 ปีที่แล้ว
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.9K2 ปีที่แล้ว
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
มุมมอง 12K2 ปีที่แล้ว
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
มุมมอง 22K2 ปีที่แล้ว
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
มุมมอง 1.3K2 ปีที่แล้ว
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
มุมมอง 8402 ปีที่แล้ว
How to Fix Incorrect Rank and Rank Total | Tableau Tips
Data Scientist vs Data Analyst vs Data Engineer
มุมมอง 21K2 ปีที่แล้ว
Data Scientist vs Data Analyst vs Data Engineer
Hide specific subtotal that has only one row - Tableau Tips
มุมมอง 6K2 ปีที่แล้ว
Hide specific subtotal that has only one row - Tableau Tips
Sync Axis Across Multiple Charts, Measure Values - Tableau Tips
มุมมอง 3.7K2 ปีที่แล้ว
Sync Axis Across Multiple Charts, Measure Values - Tableau Tips
Table and Inline Charts - Tableau Tips
มุมมอง 3.7K2 ปีที่แล้ว
Table and Inline Charts - Tableau Tips
Pivot Table | Dynamic Table - Tableau Tips
มุมมอง 4.6K2 ปีที่แล้ว
Pivot Table | Dynamic Table - Tableau Tips
P&L Table | Data Densification | Custom Subtotal | Color Headers - Tableau Tips
มุมมอง 1.4K2 ปีที่แล้ว
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
มุมมอง 2.2K2 ปีที่แล้ว
Switch/Toggle Charts, Data - Tableau Tips
Reset All Filters - Tableau Tips
มุมมอง 20K2 ปีที่แล้ว
Reset All Filters - Tableau Tips
Custom Shapes - Tableau Tips
มุมมอง 2K2 ปีที่แล้ว
Custom Shapes - Tableau Tips
Apply All Button for filter and parameter - Tableau Tips
มุมมอง 24K2 ปีที่แล้ว
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
มุมมอง 2.1K2 ปีที่แล้ว
Tableau Basics 9 - How to use Groups/Sets
Tableau Basics 6 - Creating Calculations
มุมมอง 4.5K3 ปีที่แล้ว
Tableau Basics 6 - Creating Calculations

ความคิดเห็น

  • @dominico.s.6376
    @dominico.s.6376 5 วันที่ผ่านมา

    The fact that these tutorials are necessary demonstrates why Tableau is a terrible product. Reset all filters? Why is this not a default functionality in Tableau, for crying out loud!

  • @annaani6766
    @annaani6766 11 วันที่ผ่านมา

    hi! Tell, please: How to do Index column?

  • @cmchouhchs
    @cmchouhchs 18 วันที่ผ่านมา

    3Q

  • @noammaman3942
    @noammaman3942 25 วันที่ผ่านมา

    god bless you dear, thank you

  • @張皓TimChang
    @張皓TimChang หลายเดือนก่อน

    Awesome

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

    How can I contact you?

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

    that’s exactly what i needed because everything i was reading was confusing……..thank you very much

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

    Thank youu!!! Been struggling with this for ages!

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

    Awesome

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

    A standard P&L statement lists expenses with positive numbers (the assumption being that they would be understood as negative, given that they are under the Expenses section of the statement), which would complicate your net income calculation. How would you address that?

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

    Thank you.

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

    How to combine both?

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

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

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

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

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

    This was so easy to follow! Thanks!

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

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

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

    Thanks so much! Great job!

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

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

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

    You are awesome. Thank you.

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

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

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

    Exactly what I was looking for. Thank you! 👍

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

    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 7 หลายเดือนก่อน

    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 8 หลายเดือนก่อน

    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 8 หลายเดือนก่อน

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

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

    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 8 หลายเดือนก่อน

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

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

    Exactly what I was looking for. Thanks!!

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

    Great video. Thanks for sharing.

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

    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 9 หลายเดือนก่อน

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

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

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

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

    This is a life saver!

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

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

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

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

  • @WadeSteele-m7l
    @WadeSteele-m7l 10 หลายเดือนก่อน

    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 5 หลายเดือนก่อน

      Were you able to figure this out? have same issue

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

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

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

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

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

    Thanks for the video....

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

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

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

    Thank you so much dear

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

    great video

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

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

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

    Life saver!!!

  • @TariniMathur-i1b
    @TariniMathur-i1b ปีที่แล้ว

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

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

    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 ปีที่แล้ว

      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

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

    THANK YOU ITS REALLY AMAZING

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

    Great video, Thanks

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

    Really great tip, liked it, Thanks,👍

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

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

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

      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