Sherzodbek I.’s Post

🤔 Have you had a time when you want to consistently break a customer name, product name, or job title into two lines in Tableau.   ☝️ You can do this with a calculated field of the following format to force the line feed in a controlled place: [Last Name] + ',' + CHAR(10) + [First Name]   You could get identical results by putting the line feed between quotes: [Last Name] + ', ' + [First Name]   You could, of course, account for multi-part names with string functions or REGEX.   You could also extend this same technique for names with 3 or more parts across 3 or more lines.   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

🤔 Have you noticed that when you select marks in a Tableau view, your reference lines recalculate if they are not constants?   😲 It's actually an optional feature!   ⌛ I have to admit, if this was mentioned in my initial training, I missed it… for quite a while.   Then I rediscovered it.   You can find it at the bottom of the Edit Reference Line form.   Just uncheck "Show recalculated line for highlighted or selected data points"   (I'm curious why they used "data points" instead of "marks"?)   🙈 I tend to have a bit of situational blindness, so if I'm not actively looking for something, I easily overlook it, and that's why I forgot about that checkbox.   Anyway, while I'm not a frequent user of reference lines, when I do use them, I usually prefer that they don’t recalculate.   How about you? Do you find it helpful?   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

❓ So you have some stacked bar charts with unsightly 0's in Tableau?   🪤 There are a few ways to get rid of them.   You could check if the measure is >0 with a calculated field, and only return that same value if it is >0, and otherwise null and the null will display nothing.   The other alternative is to format 0s and a blank string, i.e., two double quotes. Even just a blank space after the ; works.   I like the formatting option - it's simpler and more efficient.   📝 This also works nicely on big tables in which a lot of repeating 0s tend to obscure 1s or other metrics.   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

🤔 Did you know you can give the same alias to multiple Measures in Tableau?   👆 Almost.   Say you have 2 or more versions of a Measures with a different aggregation or LOD, but you want then to have the same label on different worksheets for whatever reason.   🚫 Tableau will not allow this.   🪄 Unless… you use an old developer's trick: just put a space on the end.   I've done this with 4 versions of FTM (free throws made) in the example image.   Tableau will typically trim the spaces on the Header labels, so in these cases sizing does not matter.   Simple, but effective.   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

🤔 Have you ever seen an "*" in a Tableau Quick Filter?   🛸 I've only seen this on rare occasions in my years of using Tableau.   Last time, I forgot what the solution was.   Luckily, re-discovered it fairly quickly.   Somehow, I had placed ATTR(Dimension) in the Filters shelf rather than the Dimension itself.   That's all it was.   I probably Ctrl-dragged it there from a Mark label.   Regardless, it's a easy to miss and overlook the cause.   🔧 If you have this somewhere, go fix it!   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

🤔 Did you know that in Tableau you can put a Dimension in Size?   ⌛ For a long time, I never thought of that.   💭 But one day, I was testing an idea and I thought, "Man, it would be great if I didn't need to make another variable for a measure to put on size."   💣 So I dragged the dimension that was on color to size as well, and BAM! It worked.   Wait, it gets even better! You can drag the Dimension values into the order you want (wouldn't make much sense otherwise, would it?)   There are some use cases out there for this!   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

❓ Did you know you can put comments on variables in Tableau?   ❓ What do you put in these comments?   I'm not talking about // comments   Or even /* comments */ in calculated fields.   I'm talking about right-click > Default Properties > Comments.   That opens a form for formattable text.   And in those, you can put emojis if you like.   One good use for a comment is to put the original variable name if you happen to rename one - that way, you can see the name on over without having to click and revert (there is a way to see through the data source too but I can't remember it).   I definitely underutilize this feature.   How do you leverage it?   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

🤔 Have you ever heard of a Ziggurat Chart or a Chichen Itza Chart?   📖 It's not really a recognized thing…   I made it as a gag to tease fellow tableau developer who had recently made waffle charts and plum pudding charts.   I figured, why not try a Triangle?   🤪 It doesn't really work that well, but it *does* have 100 squares, and it's a weird way to show a percentage.   🏈 This is a Throwback Thursday viz!   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

🤔 Should you use Boolean expressions as formulas in Tableau calculated fields rather than IF/THENs producing 'Y' and 'N'?   ☝️ Answer: Usually, yes.   ✔️ And yes, I was going for irony in a Y/N Boolean question…   There is always a use case for anything you can do in Tableau, but you can make your calculations a little more compact by making them Boolean and using a simple conditional statement rather than assigning a text value based on that condition.   Go one step further and name that Boolean as the question that it answers and end the name with a ?   You can put that Boolean on Filters, Color, Shape, wherever, and be just as effective as a Y/N column.   Yes, you may want to display a Y/N - if so, you can alias the True and False values to Y and N!   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

👀 I've been looking into Data Stories in Tableau.   🪙 There is some definitely some useful functionality there.   However, in that process, I got the screen below.   Do you know what I thought?   "Where the heck is the More Options context menu?!"   I don't think I ever even read the "More Options" hint on the dropdown arrow (aka caret, aka "disclosure triangle", aka "menu indicator") on dashboard objects. Has that always been there?   Anyhow, I eventually figured it out.   And if you didn't know, now you do!   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay