OPX Data

OPX Data

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

How to Sort Data in Tableau

How to Sort Data in Tableau

Custom Shapes - Tableau Tips

Custom Shapes - Tableau Tips

Пікірлер

  • @rodolfopresa2821
    @rodolfopresa28212 күн бұрын

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

  • @elwyndude
    @elwyndude5 күн бұрын

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

  • @TheQueenEPK
    @TheQueenEPK6 күн бұрын

    This was so easy to follow! Thanks!

  • @kusumgupta8831
    @kusumgupta8831Ай бұрын

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

  • @AmaDavies
    @AmaDaviesАй бұрын

    Thanks so much! Great job!

  • @ppjn348
    @ppjn348Ай бұрын

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

  • @pattybaselines
    @pattybaselinesАй бұрын

    You are awesome. Thank you.

  • @TheSeveer123
    @TheSeveer123Ай бұрын

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

  • @AI-hn1nr
    @AI-hn1nr2 ай бұрын

    Exactly what I was looking for. Thank you! 👍

  • @nismokid
    @nismokid2 ай бұрын

    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-hm7qj2 ай бұрын

    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
    @ZheyuanZ3 ай бұрын

    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
    @deepti613 ай бұрын

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

  • @RhushikeshHiralalChavan
    @RhushikeshHiralalChavan3 ай бұрын

    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
    @hetilemabunda97053 ай бұрын

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

  • @edgarvasquez47
    @edgarvasquez473 ай бұрын

    Exactly what I was looking for. Thanks!!

  • @gabonicabas
    @gabonicabas3 ай бұрын

    Great video. Thanks for sharing.

  • @BradStone-1
    @BradStone-14 ай бұрын

    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
    @burujulaseenu23884 ай бұрын

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

  • @burujulaseenu2388
    @burujulaseenu23884 ай бұрын

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

  • @KevinWee90
    @KevinWee904 ай бұрын

    This is a life saver!

  • @vigneshwaranm5836
    @vigneshwaranm58365 ай бұрын

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

  • @thepenguin74
    @thepenguin745 ай бұрын

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

  • @user-nl7fx2th7p
    @user-nl7fx2th7p5 ай бұрын

    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
    @zsBears18 күн бұрын

    Were you able to figure this out? have same issue

  • @mounikapulijala1327
    @mounikapulijala13277 ай бұрын

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

  • @Codewithmechs1996
    @Codewithmechs19968 ай бұрын

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

  • @sushilkokil1997
    @sushilkokil19978 ай бұрын

    Thanks for the video....

  • @abhishek12865a
    @abhishek12865a8 ай бұрын

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

  • @abhishek12865a
    @abhishek12865a8 ай бұрын

    Thank you so much dear

  • @srikantbattula8408
    @srikantbattula84088 ай бұрын

    great video

  • @garypansino2484
    @garypansino24849 ай бұрын

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

  • @robespierre2575
    @robespierre25759 ай бұрын

    Life saver!!!

  • @user-xz2ig2dh5t
    @user-xz2ig2dh5t9 ай бұрын

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

  • @ericpeterson6822
    @ericpeterson682210 ай бұрын

    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
    @OPXDataAnalytics10 ай бұрын

    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 kzread.info/dash/bejne/oaB7q5OHeMSbqpM.html

  • @user-sh8ct5rx5w
    @user-sh8ct5rx5w10 ай бұрын

    THANK YOU ITS REALLY AMAZING

  • @vamsireddy5051
    @vamsireddy505110 ай бұрын

    Great video, Thanks

  • @vamsireddy5051
    @vamsireddy505110 ай бұрын

    Really great tip, liked it, Thanks,👍

  • @akak1816
    @akak181611 ай бұрын

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

  • @OPXDataAnalytics
    @OPXDataAnalytics10 ай бұрын

    learn how to create parameter: kzread.info/dash/bejne/dIp-qaipZLaacaw.html filtering with date parameter:kzread.info/dash/bejne/jKGEsaZvqrabp84.html Hope this helps

  • @rajainam1985
    @rajainam198511 ай бұрын

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

  • @rajainam1985
    @rajainam198511 ай бұрын

    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
    @haniharun32673 ай бұрын

    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-hj1em3fy7u10 ай бұрын

    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
    @anishsingh24604 ай бұрын

    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
    @yurizhang17811 ай бұрын

    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 kzread.info/dash/bejne/f2qi09SAlZapf9I.html

  • @Murtaza010
    @Murtaza010 Жыл бұрын

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

  • @dailydriver5942
    @dailydriver5942 Жыл бұрын

    Great video! Really helped me solve the same axis across multiple sheets issue I was running into

  • @charmelink
    @charmelink Жыл бұрын

    you are the best! keep it up 🙌🙌🙌