Hi Bobby, I couldn't seem to open your packaged workbook, but have you tried creating a group by right-clicking the Result field and clicking on Create > Group? You can group the numbers together and the letters together. Then, you can put that new group to the left of the Result pill to get the breakdown you want. After that, it's just a matter of moving the slider for row borders until you get the border you want.
Note to self: V10.0 workbook.
So see the attached. I can conditionally add stuff to the text, but each mark is actually going to occupy the same space.
The [Extra line] actually has a carriage return in the middle of the quoted text. The logic in there detects when I am on a line that is no longer a numeric line, and also that the prior line WAS all numeric characters. I don't know what condition you will actually have in your real data, but the LOOKUP function is what you use to know what came before your current line.
But here's the rub. It's not adding a whole "row" of break before the data for the first Alpha row. It's just pushing down the 1 to fit the other stuff in there.
If you want a whole row of break, you'll have to hack up something else. (Which I have ideas for, but first let's see what this approach does for you.)
Sample A.twbx 14.0 KB
My intent is to have an entirely separate row break for purely cosmetic purposes. My real data variable is built in a hierarchy structure, so I ran into duplicate columns of output results when I tried creating groups on my end.
I wonder if the concept of panel charts would serve your needs.
Google "Tableau Panel Chart" and you'll get lots of examples.
Here is one such link:
Usually the examples show 50 little charts, one for each state, but maybe you could adapt the concept to your chunks of data.