Thursday, October 30, 2014

My Favorite Tableau Trick For Work: MIN(1)

Many of us found +Tableau Software from the work that we do in our day jobs, and have since taken our passions to our free time.  When given the ability to build visualizations we're passionate about, people come up with creative solutions like Anya A'Hearn's Stairs Of The CityKK Molugu's Playoff Quarterback TouchdownsRussell Spangler's Bacon Viz (and WAY too many more to mention).  

HOWEVER...

In our day jobs, there is much less room to be creative and more of a need to be direct.  As a result, designs usually involve displaying more numbers than visualizations.  And while there are best practices by Nelson Davis about when to use numbers and when to use visuals, numbers end up more often than us 'creative types' would prefer.  


FEAR NOT!

You can still let loose your creative side even when displaying numbers.  My personal favorite trick is the MIN(Number of Records) trick, or simply MIN(1).  You can create the field like so, and then set the default aggregation to MIN



You can create a new field or simply use 'Number of Records' that is in default Tableau
Set the default aggregation to Minimum to make ongoing use easier

And get results like this



WHAT?!


MIN(1) is a calculated field that you can create that give you a measure in your worksheet that acts as a place holder for other measures.  You can then add whatever measure, or combination of measures, to the text charm of your field and display that in a very organized fashion.

???????????

An example then.

Normally, if we wanted to show a series of numbers on a sheet, we put 'Measure Names' in the rows, 'Measure Values' in the Text, and it would look something like this....

But if you want to color just the Profit Margin line, based on a set percentage of 20%, you can't.  An attempt would make your result looks something like this...

However, using MIN(1), you can set placeholders for each of the measures and then analyze them however you want.  Here's the same sheet, redesigned....


Notice how I've dragged four copies of 1 on the screen that show up as MIN(1) because that is the default aggregation I have set.  Every row is now on a scale of 0-2, with 1 dead in the middle, but more importantly it provides it's own measure to color, size, give level of detail, etc.  Now I can just color the Profit Margin line by itself and leave the other lines alone.


NOT ENOUGH, YOU SAY?!

What about combination charts, a chart that shows both bars and text.  If we try the traditional example again, we get something like this.

While we are able to achieve both text and charts, the text is aligning to the value it represents thus making it hard to read the numbers.  Now let's' rebuild this using MIN(1)

The result is that the numbers are all aligned for each metric, a bar chart is in the middle for the specific metric worth highlighting, they are still separate measures which allows us to edit color, size, and level of detail, with an overall clean look.

UPDATE:  Steven Carter wrote a post to do filled cell conditional formatting with text.  Forcing the cell lengths and using Gantt charts you can now have a look that is similar to Excel (for helping people transition away from it)
Way to go Steven!
In addition in both cases, because this is all done in 1 chart there is one query back to the data source, and if you have too many values to fit on the screen, you can SCROLL (!!!!!) and know that one scroll will move all of the fields necessary.


ONE MORE EXAMPLE

I was working with a customer where on a dashboard, we wanted a way to highlight the number of alerts that people needed to pay attention to.  To make it stand out, I put the number in a text box with a highlighted background and a border. 

Using MIN(1) as a bar chart and setting the range from 0 to 1, I can set the border on the bar chart, change the background color based on any value you want.  All of this is happening while also never having to worry about the bar chart range.  Here's what the sheet looks like.


CONCLUSION

If you're building a dashboard and need to display numbers in some capacity, MIN(1) is another tool in your Swiss Army Knife of Tableau skills.  It allows you clean layouts but with all of the customization we've come to know and love using Tableau. 

Please comment or tweet at me (@DanRMonty) with other ways you've found you can use MIN(1)!



DISCLAIMER: you do need to have text fields on your dashboard now to label your measures (you can put them in a container to make it easier to manage).  You can see this in the dashboard above.

82 comments:

  1. I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting tableau online training india

    ReplyDelete
  2. Thank you so much. I have been trying this for a while and the min measure made the huge difference. cheers

    ReplyDelete
  3. Thank you so much for providing information about Tableau and other such aspects.Tableau is actually the best way to learn more about complex database operations.

    Tableau Rest Api Connection

    ReplyDelete
  4. Your blog is very nice and provide me informative content thanks for sharing for more information about What is Tableau

    ReplyDelete
  5. Hi,

    Thanks for you post, found it rerally useful.

    Just in addition, would you know how to add headders to MIN1 tables?

    Best wishes

    ReplyDelete
  6. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating
    Tableau Online Training
    Tableau Training

    ReplyDelete
  7. Hi Dear,

    I Like Your Blog Very Much. I see Daily Your Blog, is A Very Useful For me.

    You can also Find Refrigerator Lock BoxesProvide your practice with easily accessible glove box holders. Shop the Omnimed store online today for high-quality medical office equipment like glove box holders and accessories.


    Visit Now:- https://omnimedstore.com/glove-box-holders/

    ReplyDelete
  8. I would like to say that this blog really convinced me to do it! Thanks, very good post. https://europa-road.eu/hu/nemzetkozi-nehezgep-szallitas-budapest.php

    ReplyDelete
  9. Thanks for sharing useful information.. I have learned so much information from your blog..... keep sharing

    Tableau Online Training

    ReplyDelete
  10. This solution is fantastic! But how do you get any values to do anything but center justify? I want to right justify as currencies normally do.
    I used this solution to enable displaying a currency based on a parameter control only in one column but I can't get anything to use a right justify as needed for currency.

    ReplyDelete
  11. Hey, I was planning my career in cyber security training online but I was in delima, but after reading your blog I have decided to do tableau training. Thanks for your blog.

    ReplyDelete
  12. This arrangement is incredible! In any case, how would you get any qualities to do everything except focus legitimize? I need to right legitimize as monetary forms regularly do.

    I utilized this answer for empower showing a money dependent on a boundary control just in one section yet I can't get anything to utilize a right legitimize on a case by case basis for cash.
    If you are Looking for Online Business Strategy Implementation Services Click here....

    ReplyDelete
  13. i am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me
    Tableau Desktop Professional Crack

    ReplyDelete
  14. We are offering, Blank Cereal Boxes at very economical rates compared with the market rates for mini cereal boxes. The higher demand for cereals has resulted in the greater use of cereals boxes.

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. I am new to your site. which is quite surprisingly good. soo let me tell you about our business.Custom Boxes. Get premium quality packaging at affordable rates from Urgent Boxes. Customize your Custom Boxes in any custom design and shape.for more details:
    Pre Roll Packaging
    Sleeve Boxes
    Candle Packaging
    Serum Boxes
    Cake Boxes
    Cereal Boxes
    Wax Paper Bags
    Cannabis Seed Boxes
    Dispenser Boxes

    ReplyDelete
  17. https://viraltechgo.com/5-versatilities-custom-packaging-tends-in-the-world/
    https://www.newsplana.com/make-your-candles-product-catchier-glamorous-by-using-candles-boxes/
    https://www.articlering.com/make-your-candles-product-catchier-glamorous-by-using-candles-boxes/
    https://www.articlestheme.com/make-your-candles-product-catchier-glamorous-by-using-candles-boxes/
    https://www.articlesbids.com/2021/11/11/make-your-candles-product-catchier-glamorous-by-using-candles-boxes/
    https://www.newsplana.com/get-yourself-the-coolest-game-boxes-for-your-games/
    https://www.articlering.com/get-yourself-the-coolest-game-boxes-for-your-games/
    https://www.xpertposting.com/2021/11/04/appealing-aesthetics-for-presentation-boxes/

    ReplyDelete
  18. thank for dropping this story. I am definitely tired of struggling to find relevant and intelligent commentary on this subject. Everyone nowadays seem to go to extremes to either drive home their viewpoint or suggest that everybody else in the globe is wrong. thank for your concise and relevant insight. data science from scratch

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. What a great and amazing post.

      https://kbcinquiryoffice.blogspot.com/2021/10/kbc-head-office-number-mumbai-kbc.html

      Delete
  20. I was searching for gate.io review. Thanks, admin, for sharing such wonderful content on this topic. Now I have got everything I need about it. Here’s another informative content Gate.io Review , you may find here more information.

    ReplyDelete
  21. Thanks for sharing, Here New Version available;

    https://licensedinfo.com/tableau-desktop-crack-2/

    ReplyDelete
  22. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.

    ReplyDelete
  23. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    https://eduxfactor.com/tableau-online-training

    ReplyDelete
    Replies
    1. What ideas you have like this post.


      https://kbcinquiryoffice.blogspot.com/2021/10/kbc-head-office-number-mumbai-kbc.html

      Delete
  24. I am from the USA. I am an SEO expert at UrgentBoxes, UrgentBoxes provide the best packaging boxes that are suitable for your business. In international marketing and branding, the packaging is the most sensitive part as it directly affects the consumer’s behavior.
    Pink Donut Boxes
    Cereal Boxes

    ReplyDelete
    Replies
    1. I have same ideas like you.


      .https://kbcinquiryoffice.blogspot.com/2021/10/kbc-head-office-number-mumbai-kbc.html

      Delete
  25. Its a great and tremendous blog post.

    https://kbcinquiryoffice.blogspot.com/2021/10/kbc-head-office-number-mumbai-kbc.html

    ReplyDelete
  26. Keep on sharing and writing such a great post.
    https://bolgameshowluckydraw.blogspot.com/2021/09/bol-news-head-office-number-2021.html

    ReplyDelete
  27. It's a amazing and astonishing post.

    https://kbclotterywinnerlistjio.blogspot.com/2021/10/kbc-helpline-number-kolkatamumbaionline.html

    ReplyDelete
  28. So nice and helpful post.


    https://kbcluckywinner4.blogspot.com/p/kbc-online-check-whatsapp-lottery.html?m=1

    ReplyDelete
  29. I am happy by seeing your post.


    https://kbcwhatsappheadofficenumber.blogspot.com

    ReplyDelete
  30. A niece way too sincere. I have offered for all of you Custom Vape Cartridge Boxes. We are providing exceptionally designed Custom Boxes with free shipping services.
    Custom Vape Cartridge Boxes
    Bath Bomb Boxes

    ReplyDelete

  31. Custom cosmetic boxes bulk
    are exclusive- stylized printed boxes for cosmetic products, produced mainly for the purpose of presenting a variety of cosmetic products on the retail shelve. These private label customized costmetic packaging boxes are creatively produced with advanced machinery and complete dedication from the experts. Being manufactured out of thick cardboard material, Custom printed cosmetic boxes bulk can be crafted in various shapes, sizes, styles, and designs, in accordance with the requirement of the customers. Custom cosmetic packaging boxes plays a vital role in improving brand identity.

    ReplyDelete
  32. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. wahabtech.net I hope to have many more entries or so from you.
    Very interesting blog.
    Tableau Desktop Crack

    ReplyDelete
  33. If you want to downlaod the latest version of this software so links given below!
    piratelink.org
    Tableau Desktop Professional Crack

    ReplyDelete
  34. Its a very informative post.we are providing quality custom boxes with logo in all over USA. we are also providing free shipping in the state of USA.

    ReplyDelete
  35. Very Nice Blog and the best explanation of uses tableau, This blog will help students a lot. I am glad to announce that ducat is offering best expert training for Tableau and guaranteed placement assistance for students to help the grow in your career

    ReplyDelete
  36. Gambling in a casino: What does it mean, how does it work? - JT Hub
    As a general rule, the gambling establishment does not go as far as 창원 출장샵 the dealer is concerned. In terms of how the game 포항 출장안마 works, 전라남도 출장안마 the 동두천 출장안마 casino will 나주 출장샵 not

    ReplyDelete



  37. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. wahabtech.net I hope to have many more entries or so from you.
    Very interesting blog.
    Scratch Desktop Crack

    ReplyDelete
  38. I guess I am the only one who came here to share my very own experience. Guess what
    I am using my laptop for almost the past 2 years, but I had no idea of solving some basic issues.


    ReaConverter Pro Crack

    EF Commander Crack

    Directory Monitor Pro Crack

    Recover My Files Crack

    VueScan Pro Crack

    ReplyDelete

  39. Wow. It is a very helpful topic for me . Do You know about the Turkey visa application form ?ya I have a good experience about it. When I applied for my Turkey visa I got my Approved Turkish visa in only 3 days in my Registered gmail id.

    ReplyDelete
  40. The customize boxes does not only manufacture Vape Boxes but custom packaging bags are also developed in which the customers can hold their e cigarette boxes. A lot of attention is given on custom packaging boxes of vapes because it is trendy product and for classy product that are used public ally, people never comprise on its packaging boxes.

    ReplyDelete
  41. very same largesse? His account published a few days ago should pay off his debt without much loss of sleep.
    Pakistani Drama Website

    ReplyDelete
  42. Keep up the good work. I’ll be coming back lots.
    SEO Firm Chicago

    ReplyDelete
  43. Thank you once again for your love and willingness to share your feelings
    lederjacke damen
    leather jacket

    ReplyDelete
  44. I really like the blog.I have shared your site with many friends and family. It is always a pleasure to read.
    lederjacke damen
    leather jacket

    ReplyDelete
  45. I am browsing this website daily, and get nice facts from here all the time. A Russian visa is required in case you enter Russian Federation for tourism purposes. You can read all info about Russia visa via our electronic visa Russia website.

    ReplyDelete
  46. Hi guys, are you interested in traveling to any country? Yes, you can apply for an e visa online. You can fill out your visa application form online through our Visacent website within 5 to 10 minutes. We offer visas to citizens of over 190 countries. You can read more information about visas through our website.

    ReplyDelete
  47. wow what is this really? Why aren't you doing this now? I think it's so awesome and awesome I have to share this with my friends and my 공주출장아로마
    논산출장아로마
    계룡출장아로마
    보령출장아로마
    서산출장아로마son and wife right now I feel like I found an oasis in the desert Thank you so much for finding your site.

    ReplyDelete
  48. I seriously don't have enough words to thank you.
    Custom Eyeshadow Boxes

    ReplyDelete
  49. https://www.worldinforms.com/2018/12/achieve-full-coverage-for-uneven-skin-tone.html

    ReplyDelete
  50. Your blog is an innovative initiative in the world of blogging. You have a unique imagination and have come up with some of the most creative ideas I've ever seen. Best of luck for your blogging journey. Keep engaging us! Buying A House From Owner

    ReplyDelete
  51. We greatly value the information you gave us. Qatar On Arrival Visa For Indians: Qatar opens its arms to Indian travelers with the convenience of on-arrival visas, marking a significant step in strengthening bilateral ties and boosting tourism.

    ReplyDelete
  52. Hello, I'm delighted to express my enjoyment in reading your posts. The content is both captivating and enlightening, making me a returning reader seeking more. Discover Kenya's beauty through these Photogenic Spots in Kenya. From the iconic Maasai Mara to the turquoise waters of Diani Beach, capture unforgettable moments at these picturesque locations.

    ReplyDelete
  53. I really hope you all are doing well and enjoying life to the fullest. I thank you so much for your unmistakable generosity in sharing this kind of invaluable information. Luxembourg citizens intending to visit India need to obtain an India visa. India Visa for Luxembourg Citizens. This process generally includes completing an online application form, submitting a valid passport with at least six months of validity, a recent passport-sized photograph, and providing details about travel plans and accommodations in India. An application fee is typically required.

    ReplyDelete
  54. Our packaging company does not charge you extra on the shipment of Custom vape boxes at your doorstep.

    ReplyDelete
  55. I'm a fan of your writing style. It makes complex topics easy to understand and engaging. A US Regular B1/B2 Multiple Entry Visa allows travelers to visit the United States for business or tourism purposes multiple times.

    ReplyDelete
  56. Your openness in sharing these is sincerely acknowledged. In the future, I'll eagerly participate in the event, as this topic is exceptionally intriguing. Top Turkey Airports Info. Turkey boasts several major airports, with Istanbul Airport being the largest and busiest, serving as a vital international hub. Other notable airports include Ankara Esenboğa Airport, Antalya Airport, and Izmir Adnan Menderes Airport. These airports offer modern facilities, convenient transport links, and access to the diverse attractions of Turkey.

    ReplyDelete
  57. This comment has been removed by the author.

    ReplyDelete
  58. Your adeptness at simplifying intricate subjects is truly admirable. Eagerly anticipating more of your content. Do you know about Turkey Visa for United States of America? Discover the application process, requirements, and validity for travelers

    ReplyDelete
  59. Wao Amazing.
    My name is Tim J. I have been living in the UK and working for UniVapez for the last 2 years. I like research-based work. I love Disposable Vapes , the best ones are Crystal Prime 7000, Crystal Pro Max 4000 , Bar Juice 5000 and Elux Legend.

    ReplyDelete
  60. The fees may vary depending on factors such as the exam level, geographical location, and registration deadlines. Candidates need to stay informed about the ACCA exam fees to effectively plan and budget for their professional development in the field of accountancy.

    ReplyDelete
  61. Thank you for this wonderful post. In the realm of vaping, the Elux Legend 3500 Puffs stands as a true game-changer, offering an unparalleled experience for enthusiasts. With an impressive puff count of 3500, this device redefines endurance and satisfaction. Imagine indulging in the rich flavors and smooth inhales for an extended period, all within the sleek and stylish design of the Elux Legend.

    Crafted with precision and innovation, the Elux Legend 3500 Puffs brings together cutting-edge technology and exceptional craftsmanship. Whether you're a seasoned vaper or a newcomer, this device caters to all, ensuring a seamless and enjoyable vaping journey. Its longevity and convenience make it a standout choice in the ever-evolving world of vaping devices. Elevate your vaping experience to new heights with the Elux Legend 3500 Puffs – where performance, style, and endurance converge for an unmatched sensation.

    ReplyDelete
  62. Thanks for sharing.
    Regards jajaaradesign!
    jajaaradesign, your best choice for online jewelry stores in the USA. Explore our unique online jewelry boutique for custom, elegant pieces,Stainless Steel Cuban. Shop with us today.

    ReplyDelete