How to add dynamic up and down KPI arrows in Tableau - 2 ways | Tableau Quick Tip | sqlbelle
Вставка
- Опубліковано 16 жов 2020
- LET'S CONNECT
sqlbelle.ck.page
Practice Questions and other digital products
sqlbelle.gumroad.com
This video tutorial walks you through two (2) ways to add dynamic up and down arrows in Tableau (in text table and tooltip). I will show you not only how to do it, but also explain how it works. This is a trick you can use not only for arrows but other visuals in Tableau.
Arrows are typical icons (glyphs or pictographs) used for KPIs (Key Performance Indicators) - Наука та технологія
Thank you. This was extremely useful!
Thank you Yolinda, happy to hear you found it useful! 🙂
Anybody ever tell you you have such a "soothing" teaching voice that allows the student to relax, and take in things and process information much easier?
Thank you Doug :)
Thank you for the great tip, I tried the same but due to some reason I couldn't get the triangle shapes, so used ascii ALT+30 and ALT+31 to get triangle shapes.
You are Magician!!! Thank you SqlBelle. Happy Holidays.
Thank you Raj!
One word Amazing... You saved my day. God Bless YOU & ur family, friends, neighbors etc..
Thank you Danish! Glad to hear you found the video helpful!
you dont know how much i really need this, thank you sooooo much
Hello sqlbelle, thanks for the excellent tutorial! I have adapted this method in a particular way, but need help with color. My table shows the median days it took to process a particular kind of document each month, plus arrows or equal signs indicating whether that value is more, less, or equal to the previous month's value (so I've created three calculated fields--one for each arrow, and one for the equal sign, and they are using the same Quick Table Difference calculation which determines whether the current month is more, less, or equal to the previous month).
The challenge I'm facing is: I need the arrow or equal sign (which is generated by the running difference calculation) to be either red or green based on whether the monthly median processing days value is below/equal to OR above a certain threshold--the symbol (which is tied to the difference calculation) needs to be green if the monthly median value is below or equal to the threshold, and red if above. So the median value would control the color of the running difference symbol. If you're interested in this problem, is there a way I can get in touch with you?
I’ve Made so many charts I’m running out of ways to show data. This was nice. Thanks
Thank you :)
Thank You. It is extremely useful. Added Bonus for me was dragging the measure from the Mark and making it a calculated field. Amazing
Thank you Krish! So happy to hear you found the video useful :)
THIS IS GOLD. Thanks so much! Really helpful
Thank you Marie! Happy you found the video helpful :)
Thank you so much. Appreciated your effort. You have provided me with great learning resources.
Thank you Dhruv! That is great to hear :)
Thank you, i like the most things in your video are used for business dashboard really thank you again
That is great to hear, thank you for your feedback Peter! 🙂
You are teaching difficult things in easy way, thanks
Thank you Rajendra! Glad you found it helpful! :)
Thank you for sharing this! very simple and effective!!!
Thank you Brenden
Very nice!! There's a way to add colour with the first way? I have many columns and with the second way only work with one colum
thank you for your tutorial!, How can show indicators without showing the previous months?
Great Nicely Explained,Enjoyed the Video. Thanks
this is awesome, lovely tip. thank you soo much
This was asked in my last Interview. Thanks for the solution
That's great, thanks for sharing Sagar! Glad it was helpful :)
Thank you! This is very helpful 👍🙏
Thank you so much, Very detailed and informative video.
Thank you Tarun!
Niiiiiceee!!! Just the thing I needed :) Thank you!
Glad to hear, thank you Raluca!
Awesome 🤩Exceptional skills or should i call it Expertise 🤔
HI , Excellent Explanation. Please upload more videos on Tableau. Thank you
Thank you Naresh!
If we get fixed color for the negative and positive values from client then we can take those shapes of those color from text editor here ms word directly and can put in measure format under pane window in last custom option
Thank you. That should work as well.
If you wanted to compare values a time series to the prior value in the which of the following would allow you to accomplish this easiest in Tableau
Thank you Laxmipriya, I think your best bet is Table Calculations: ua-cam.com/video/3_DeQdE25Bc/v-deo.html
Very Simple and extremely useful.
Thank you Imthiyaz, happy to hear you found it useful :)
Wonderful! Thank you!
thank you, very simple and effective
Thank you Abdullah!
Thanks for such amazing video.
Thank you Abhinav!
How would I show the up/down once at the end of the list which should represent increase/decrease when comparing Current Year Volume to Previous Year Volume (at all times). So even if they expand the date view, it still is based on Current Year vs Previous.
My head I am thinking this would be added as a shape, separately as a calculated field... and then calculated fields for current and previous year total.
Can this be used for just increase or decrease by number and not percentage?
awasome . Extremly simple and very useful
Happy to hear that, thank you Madhu!
@sqlbelle, How can I limit the indicator to just one column like a column that indicates the total or sum of other columns?
How I can get the shapes only for specific measure, by using this method its place icons on all measure, please let me know.. thanks in advance
Brilliant use of font colour , I thought we were going to create a separate calc field for color and drop it to color field
Thank you maseed, I hope it was helpful! 🙂
hehe, me too.
Thanks for this it's great. Do you have a video for creating the same visual but showing the difference between today and yesterday
Hello Edward, there are a few ways to do this depending on what you have on your canvas. Table calculations can be one way to do it; but it can also be done with regular calculations. Here is the table calculations video: ua-cam.com/video/3_DeQdE25Bc/v-deo.html
Thanks a lot. Very useful !!
Glad it was helpful!
Hi,
Thank you for the video. That was very helpful. Can you please explain what to do if you only want to show the result for the most recent year or month and its trend indicator (arrow) without showing the other columns (or years / months)? Is it possible?
Hello Estee,
Thank you for your feedback! And yes we can show just the most recent year or month indicator. I can add a follow on video to this, but the general strategy will involve another calculated field using the following table calculation functions:
LOOKUP() - to look up the last value/point; will determine if symbol should be shown
LAST() - to show last value
Hope this helps, thank you again for your comment!
Donabel
How can I only show the colored arrows in one column and not all of them? Thanks
This is awesome. Thanks!
Thank you :)
Could you tell how you copied the arrows from word to custom format? I am trying and its not working. Thank you Belle
The tooltip color is not changing for up and down arrows for 2017, its showing same how to achieve that?
how about arrow up and down comparing months like for example Feb is 10 then March is 15 so arrow up then April is 12 so arrow down
Super cool! Thanks!
Thank you Mehdi!
Thx Bella. Well it really helps 👍
Happy to hear this Aryo!
Can you please make video for conditional colour formatting .. like we have different table for threshold value and as per that another table data color will change
Hi Aryan! I just posted the video tutorial that tackles conditional formatting. Hope you will find it helpful! ua-cam.com/video/e8yQGdKG6dI/v-deo.html
Great video!
Thank you Dj Tible
@@sqlbelle I’ll be using this on a dashboard I’m designing. Keep it up!
Nice content, but how to doif we have multiple measures ?
Thanks you.. Extremely useful..
Thank you Rohit! Glad you found the video useful :)
Extremely useful.
Thank you Rahul!
hi , great technique is there a way to create the up and down arrows only for a specific measure , if i have multiple measures in tabular chart ?
Likewise. Using method # 2 with multiple measures, the arrows appear for all the measures -- not just the specific measures I have formatted as percentages.
Thank you 🦋
AMAZING!!!!!
Thank you Rachit!
Amazing. Thanks a lot.
Thank you Ronald!
This is perfect!
Very nice video thanks!
What if I have multiple measures? I tried to create a calculated field for each measure but it does not work :/
Thanks :)
Hello Lorentius. You may need to do a strategy similar to this, where there would be multiple axes for each one: ua-cam.com/video/e8yQGdKG6dI/v-deo.html
i have many columns and i want to use only 2 and this doesn't work at all on my problem
pls do same kind of session for Animations in tableau
Awesome video and tips!!!! I need some assistance. I’m following all of the suggestions you mention in terms of coloring the arrows but when I implement it there is no coloring. In the preview window, I get my value then the black up arrow followed by 2 NULLS displayed with the appropriate coloring. Not sure what I’m doing wrong.
Hello Jose,
If you are able to provide the definitions for the calculated fields, and the text in your label, I may be able to help check. Please let me know.
Donabel
@@sqlbelle Thanks for your time. To give you a little bit of background. I have one data source that I want to compare the inventory from yesterday and today. I have a worksheet that display the appropriate inventory counts. As an example, I have a sheet that displays today’s inventory count 100 units. Yesterday’s sheet displays as 80 units. I have a 3rd sheet that displays the difference of 20 units. What I would like to do is have an arrow that point upward and color of red when the difference is positive (rising inventor is not good), and green when negative. Keep I mind that the data source is the same table that lists the number of records per day. I’ve tried to implement the tips you provided but the arrows do not come out on the sheet; neither the up or down arrow come out as part of the calculation when using your methods.
Any advise would be greatly appreciated. Thanks for your time.
Hello Jose - it may be dependent on how your data is structured in your data source and how you are presenting it in the worksheets. If you are able to provide a sample workbook (with sanitized/fictional data, but with similar structure) - either in Tableau public where I can download it from or if you are able to email me, I am happy to have a look.
Wow... Can't believe it can be done in such a simple way. 👍
Wondering if I can use negative arrow in "else" clause 🤔 not sure if I am missing something if this not work 😀
Thank you for your comment, Pulak! Much appreciated!
I think she created 2 different calculated fields because we could give them different colors. If we would have used jst one field with if-else I dont know how the colors could have been differentiated.
@@SaniyaMapari Yes... Completely agreed with you. I realised this when I was doing it practically.
Hi Really great..Can you please share the dataset for the viz.
Thank you abishek! The data set is based on the Chinook database, which can be downloaded from here:
archive.codeplex.com/?p=chinookdatabase
Hope this is helpful!
Merci Miss.
Hi.. I a using tableau public and not able to get the arrows instead i am getting different numbers while pasting the arrow from
MS word to tableau.Can you help
Thank you nupur. You can try to copy and paste characters from other websites that offer these (if you search for copy paste character, there should be a few). Please give this a try. You should be able to use the text arrows with edition of Tableau.
This works if you don’t need totals. What if i want to insert up and down arrows with colors and totals for only specific measures?
Thanks! You're right. If there needs to be certain conditions, you may need to use strategies similar to these: ua-cam.com/video/e8yQGdKG6dI/v-deo.html
Fantastic
Thank you Sonder :)
So underrated
Thank you Pushkar!
Hi!
THE ARROWS...HOW DO I GET THEM?
I cannot seem to copy into Tableau the Word or PNG arrows that I have on file and the ALT+30 0r 31 is not working- Please help
Hello - you can try to copy from some online resources like this: copypastecharacter [dot] com
Thankyou ,very beneficial but I want to ask what actually KPI's are ??
Thanks Diksha, KPIs are Key Performance Indicators. It's usually a series of numbers for important metrics in the business that let you know how a business is doing. For example, whether sales are up or down (and by how much) compared to previous months, previous years, against a goal etc.
What about 0% change values. Using your method, for 0% values sometime up or sometime down arrow is appearing. Can you show how to add a different symbol for 0%
Thanks Raja. Tableau follows the Microsoft number format. If you are pertaining to the custom numeric format, there is specific formatting for zero values:
support.microsoft.com/en-us/office/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68?_fsi=jcj31lht&ui=en-us&rs=en-us&ad=us
If you are using calculated fields, then you will simply need to have 3 conditions.
hi. is it possible to have checkbox icon in just one column in a spreadsheet view? basically it a normal table but one column is a conditional true or false in a form of a check/uncheck box icon
Thanks Lar - I don't think we can do this out of the box. Workarounds I can think of are:
- putting an image (possibly from the shapes property in the marks card)
- Tableau extension
@@sqlbelle i did a workaround. my client wanted me to replicate their excel sheet which shows a combination of regular cells, cells that are colored, and cells with checkboxes. in order to customize this, all my columns are dual axis pills from calculated fields with values 1 and 0. one contains the text/shape, one containes the background color (white if regular cell). tnx
@@sqlbelle do you have a video where you have a table with text values then when you click on a row, the table will repopulate showing the related records? its like a drill down but in ecxel table form
What if I have to add one more Measure to the table? It is showing the arrow for both the % difference and the actual measure. I want it only for the % difference
Hello Ameya - you may need to create a few calculated fields if you have multiple measures. For example 2 calc fields for sale (one for positive, one for negative), 2 calc fields for Profit (one for positive, one for negative) and put them all in the tooltip.
@@sqlbelle can you please explain the same scenario as described by ameya , i have a similar use case
Hi I need help .. how can we show these arrows with colors for different measures on same worksheet like u have only profit measure but I have different measures like MOM% for : profit ,sales , balances and many more.. pls help
Hello Supriya, if it's for a tooltip as text, you may need to employ the same strategy I mentioned in the video. Another alternative is to possibly create another worksheet, and use that as a viz in tooltip (and use shape instead, and put measure names in color to vary the color).
@@sqlbelle thanks for the reply.. actually I need only two colors and two shapes up arrows in green and down with red. If I put measure names in color and shapes instead of automatic/text I will get colors but how the shapes will change according to positive and negative value.
@@supriyah8631 You will need to create a calculated field which gives 2 values: positive and negative. You can use this field in your Shapes, one for the upward arrow, another for the downward arrow.
@@sqlbelle yes u r right . This is possible if I have only one measure like when profit < 0 , profit > 0 and will put this into shapes n I will get two shapes based on calculated results . But now If I do same for sales then I cannot put again sales calculation in shape ...right?
Thank You ! But the lower triangle is not working dynamically for my KPI, I am using 2020.4.2 in first method
Hmm the triangle should show up regardless of the version... the strategies in the video are not version-specific. Would you be able to share your formula?
@@sqlbelle Thanks for the response! #,##0;-#,##0▲;#,##0;-#,##0▼
Hello, When I try to copy the arrow marks from Word I get check marks in Tableau?
Hello Mike,
I feel that sometimes happens with font differences. I think there's a couple things you can try:
1. check the font in the tableau editor to ensure it's the same as the font you selected in Word, or
2. (preferred) go to a website with the text based characters (for example copychar dot cc) and copy from there
Please let me know if either of these help..
Donabel
@@sqlbelle Thanks I wasn't able to get the Word symbols to work but copychar worked perfectly! Thanks again !
What about 0%change. With your method, 0% values are showing as up arrow for some rows and vice versa. Can you show how to add a different symbol for 0%change.
Tableau follows the Microsoft number format. If you are pertaining to the custom numeric format, there is specific formatting for zero values:
support.microsoft.com/en-us/office/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68?_fsi=jcj31lht&ui=en-us&rs=en-us&ad=us
If you are using calculated fields, then you will simply need to have 3 conditions.
Hi
How can we show the same in Month on moth growth or decline of profit
Pls help
In comparison with the previous month sales
.........Bravo! 👍
☄ A Request:
Can you please make a crash course about "Data Mining" using Tableau? (If possible 🙏)
Thanks in advance! 🙏
Thank you for your support, as always, Mustapha. Much appreciated. I will definitely look into adding these topics in future videos - thank you for your suggestion!
My image isn't pasting in formula. Please help
Paste the icon from the word document not the image
Great video, but sad that Tableau has not integrated an easy and convenient way to do this.
Yes, I agree. Although I am quite hopeful as the new versions that come out keep on adding awesome stuff. Every version is better :)
Overall, I've learned to live with some of the workarounds (I use Tableau almost daily). I might be biased though; I love working with Tableau (warts and all)
I don’t know why. But this worked the 1st time. Now it won’t Color anything anymore 🤔
Hmm .. do you have a published workbook I can look at?
@@sqlbelle hi. It’s ok now. I cleared everything and rebuilt and it is now working. Not sure what happened.
When I try this I am getting 2 arrows mam
Hello chandra,
Please check the condition for your two calculated fields for arrows.
One should be a less than sign, the other should be a greater than sign.
Please let me know how it goes.
Donabel
2015 year values are not visible...
Hello Manoj. The chart is showing change from previous year, and the first year is 2015 hence there will be no reported change. There is nothing to compare against, that's why it is showing as blank. Hope this helps clarify the chart. Once the chart is developed and ready to be rolled out, typically the first year is hidden.
@@sqlbelle thanks for the reply... I have requirement can you able to help... Can I have your mail I'd?
Iam not able to paste that arrow 😢😢😢😢
have you tried one the websites? for example from here? copypastecharacter.com/arrows
great explanation, but damn, tableau is stupid -- this should be so easy, yet they make it so convoluted
Thank you!!
Thank you Andreas!