#Tableau

Ғылым және технология

Aggregations can be difficult to understand. I find the ATTR (attribute) aggregation the hardest to get my head around in Tableau.
In this video, I teach you:
1. What an attribute is
2. Why the attribute aggregation exists
3. Examples that show how it works
4. The difference between ATTR and other aggregations like MIN & MAX
5. How Tableau write the ATTR aggregation as a formula
6. How to ensure you're not misleading your audience
7. How to work around the pesky *
Data - drive.google.com/file/d/1pQsx...

Пікірлер: 77

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

    We need more and more these simple but important videos to rectify our mistakes. Thank you Andy for sharing this. Respect you 🙏🙏

  • @davidfeldman603

    @davidfeldman603

    Жыл бұрын

    ##not simple at all

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

    Thank you very much Andy! You make it is so easy to understand and communicate what the ATTR is.

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

    This is great Andy! Love your content brother, thanks for always keeping it fresh!

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

    Wow that was one of the best tableau vids I have seen. The examples are easy to follow and you explained it in such a way a beginner like myself could understand. Thanks!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Glad it was helpful!

  • @katiepoznanski-ring998
    @katiepoznanski-ring998 Жыл бұрын

    Fantastic explanation, Andy! Love the multiple examples to reinforce understanding.

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Great! Thanks for the feedback.

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

    Thanks for publishing this (and so much other content!) Andy. With Tableau, I find a lot of people (experts) skip over explaining the nuts-and-bolt essentials, but those are the bits on which *everyone's* understanding is ultimately built.

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Was my explanation ok?

  • @RemotePossibilities1

    @RemotePossibilities1

    Жыл бұрын

    @@vizwiz Yes! The concrete examples made it very tangible. Having access to the data (or workbook) would make it better still, as I was itching to try it out in 'Bleau. (Please see my recent comment to that effect.)

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

    Nicely explained @Andy Kriebel ! I too practiced ATTR in last 2 weeks and was able to understand where and how to use it. Your video helped to get my concepts cleared , THANKS!!! It will be good if you put some video on handling cannot compare aggregate and non aggregate functions tableau and similar types of issues. Not sure if you already explained it in any video , I am yet to complete your entire play list :)

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Yup, that’s on my list 👍🏻

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

    Great Video and explanation Andy! Awesome job as usual!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Thanks for watching

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

    Love this I am doing so much at my job by looking at your videos

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

    Andy, Thank you so much for all your content!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    My pleasure!

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

    That was super awesome. We need more like this. 🤩

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

    Very Helpful. Thanks for this, Andy🙌❤️

  • @ezhankhan1035
    @ezhankhan10352 ай бұрын

    Brilliant Explanation - Thanks Andy! :)

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

    Glad I’m not the only one who took some time to understand attribute! Thank you for this video!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    My pleasure!

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

    You are simply awesome thank you for your efforts

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

    Thank you Andy. Lesson Completed

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

    Super helpful, Andy!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Glad you think so!

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

    I was wondering what the ATTR function was for. This video helped me to understand its concept in a practical way. Appretiate your efforts.

  • @vizwiz

    @vizwiz

    Жыл бұрын

    My pleasure!

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

    Great demonstration!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Thank you 👍🏻

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

    Very clear explanation, thank you!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Glad it was helpful!

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

    You’re a Tableau legend

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

    thanks Andy, that ATTR thing has been confused me for a long time.

  • @vizwiz

    @vizwiz

    Жыл бұрын

    If it’s all cleared up now, I did my job. 😊

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

    Thanks for great explanation!

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

    I like this format!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Good to know…thanks

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

    thank you for the great video 🙏

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Glad you enjoyed it!

  • @romanvasiura6705
    @romanvasiura670511 ай бұрын

    Thank you!

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

    Thank you so much!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    You're welcome!

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

    thank you!

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

    Thanks and Regards..

  • @mohanrao-fw9ix
    @mohanrao-fw9ix Жыл бұрын

    Awesome❤️❤️❤️

  • @noueruz-zaman7894
    @noueruz-zaman7894 Жыл бұрын

    great video

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Thanks!

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

    Thanks Andy, one question - When we use exclude LOD, why does Tableau uses the ATTR function?

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Good question, I’m not sure. But you can change the default aggregation if you find it confusing. I never, ever use and Exclude LOD anyway.

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

    Great

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

    Thanks! I did learn sth!

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

    Sir i have created a calculated field it is working when I am filtering one dimensional value but when I am filtering two or more it is showing star.. How would I be able to break the star so that i can show the sum of those two dimensional value..

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

    A couple of questions, if I may. Is there an easy way to get rid of the "Abc" that Tableau (infuriatingly!) insists on adding to crosstabs, as seen at 2:48? (Do you have any idea what the supposed benefit of that is?) And is there a public copy of the sample employee data (or the workbook) you use? (I'd love to follow along.) Thanks!

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Tableau includes the ABC to show you where data exists. You can always make the font white. 😊 As for the data for this example, you can find it here. drive.google.com/file/d/1pQsxgPNd4QOEiV7X3iX7xRaWPJPMcI5A/view?usp=drivesdk

  • @RemotePossibilities1

    @RemotePossibilities1

    Жыл бұрын

    @@vizwiz Thanks so much! ✔

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

    There are those WINDOW functions that I don't quite understand. I get the general idea, but I am not sure when they are the most useful.

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Good topic!

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

    i want to use top N and bottom N in One parameter with or without indexing

  • @vizwiz

    @vizwiz

    Жыл бұрын

    A calculation with the combination of “Rank ascending or rank descending” will work

  • @MuhammadShoaib-ui5jz
    @MuhammadShoaib-ui5jz Жыл бұрын

    how can we use ATTR() in Calculations and what would be the case? Can you please explain with an example?

  • @vizwiz

    @vizwiz

    Жыл бұрын

    I went through several examples in the video. What use case did I not cover?

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

    Something I have been wondering - is there a way for us to aggregate the attributes by comma separate all relevant field values. Not sure if someone has a solution here.

  • @vizwiz

    @vizwiz

    Жыл бұрын

    I don’t understand what you mean.

  • @hhyperball

    @hhyperball

    Жыл бұрын

    @@vizwiz Thank you for the reply. So let's say we have salary $50000 for both John and Jenny. Is there a way for me to show them in one row such that "John, Jenny" (instead of simply "*")?

  • @vizwiz

    @vizwiz

    Жыл бұрын

    @@hhyperball that’s where the viz in tooltip option I showed will help. Perfect use case for it.

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

    We need to know more and more about the basic concepts...

  • @vizwiz

    @vizwiz

    Жыл бұрын

    That’s what I’m trying to do. 👍🏻

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

    @Andy why it's take 5 years to upload this video

  • @vizwiz

    @vizwiz

    Жыл бұрын

    Good question! I never thought about it until I asked people what confused them about Tableau.

  • @RiffswithMohit

    @RiffswithMohit

    Жыл бұрын

    @@vizwiz just one suggestion if u can explain ATTR with LOD that will be a great help. for ex:- CAL: {EXCLUDE [City]: SUM([Sales])} why it's became ATTR(CAL)

  • @vizwiz

    @vizwiz

    Жыл бұрын

    I’m not sure. I would just change the default aggregate to whatever you want it to be.

  • @petterbohman8468

    @petterbohman8468

    Жыл бұрын

    Tanks for very clear explanation video. But the final example (6:09) is a bit misleading for me. The scatter plot level of detail doesn’t make sense to me. Why would you aggregate everyone that are on the same salary to one point in the chart? The solution for me is not to add attr(Name) to the Tooltip shelf, but rather ‘Name’ as a dimension to the Detail shelf.

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

    Everything is great, but just slow down the speed of speaking. When trying to understand some new concept such a quick speaking is a little annoying. I have tried to adjust the speed of speaking to 0.75 in KZread, but it gets too slow and annoying as well.

  • @vizwiz

    @vizwiz

    Жыл бұрын

    I do my best to accommodate everyone with the free videos I produce. Some say it's too fast, some say it's too slow. Those that have said it's too fast in the past will pause along the way to follow along.

  • @RemotePossibilities1

    @RemotePossibilities1

    Жыл бұрын

    To pause (or resume playback), you can simply press Space. So if you'd like a moment to absorb something that's just been said (or to try it out in Tableau), just press Space. Then press it again when you're ready to carry on. Simple!

Келесі