![OPX Data](/img/default-banner.jpg)
- 40
- 210 031
OPX Data
Singapore
เข้าร่วมเมื่อ 12 พ.ค. 2020
Hi i am an experienced data analyst specialising in data visualization and business intelligence.
I will be sharing my knowledge and journey on data, do follow and subscribe the channel if you wish to learn more about data analytics, data science, data engineering.
🙏 If you would like to show some appreciation:
paypal.me/opxdata
I will be sharing my knowledge and journey on data, do follow and subscribe the channel if you wish to learn more about data analytics, data science, data engineering.
🙏 If you would like to show some appreciation:
paypal.me/opxdata
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
👉 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
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
Switch/Toggle Charts, Data - Tableau Tips
มุมมอง 2K2 ปีที่แล้ว
Switch/Toggle Charts, Data - 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
Thank you.
How to combine both?
THANK YOU SO MUCH!!!!! SPENT HOURS TRYING TO FIGURE THIS OUT!
OMG OMG OMG this was EXACTLY what I was looking for... amazing thank you thank you thank you
This was so easy to follow! Thanks!
You have hidden the product name in the process of hiding extra row, what kind of stupid video is this
Thanks so much! Great job!
Are we able to still sort the data with this method?
You are awesome. Thank you.
I have an interview coming up and this video was extremely useful. Thank you for being so cute and smart 🙏🤍
Exactly what I was looking for. Thank you! 👍
Just want to say you do an excellent job in providing an easy to follow instructions with great examples! Thank you very much!!
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!
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!
Kudos to you👏 , You explained the SQL codes so well.
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
This was so helpful, so glad I found this channel!
Exactly what I was looking for. Thanks!!
Great video. Thanks for sharing.
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
Hi, how you are moving with the blank container as well. Can you please explain
Hi, how amyou are moving by holding with blank container as well
This is a life saver!
How to show min and max labels for two measures in the stacked bar chart?
I have been looking for this -whith this detailed explanation- for hours. Thanks.
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?
Were you able to figure this out? have same issue
Please let me reason apply filter not working for one click...when i double click then its working
Why do we have to put the fields in detail tab can anyone explain
Thanks for the video....
Thank you so much dear I have been searching for this from long time
Thank you so much dear
great video
Great video! Exactly what I was wrestling with. Thank you.
Life saver!!!
I have the same question - will this method work for more than 2 measures? I am working with 5 measures
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?
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
THANK YOU ITS REALLY AMAZING
Great video, Thanks
Really great tip, liked it, Thanks,👍
Hi, great video. But can you show how to created the Report Date parameter?
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
and does this will work if we select different dimensions from filter?
great video thanks! q quick question, can we add max ref line for two dual axis charts side by side
Amazing
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.
is there any simpler method without using many objects? else need try this way. Thank You, OPX Data.
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.
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.
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?
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 ?
have you found the answer to it @ousm
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.
Hi, I also encountered this issue. Have you solved this?
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.
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
Great! Short and to-the-point video. 👍