What you're trying to achieve is possible,
but it requires a lot of manual & tedious preparation.
I call this approach "Green Pills Table",
as it needs at least one Green Pill as a placeholder
for every measure column visible on a view.
I would use two Green Pills per column to mimic headers.
I couldn't advise to apply it broadly at work.
Better to use a different (simple & straightforward)
view to answer questions.
Anyway, please find the attached.
Green Pills Table_YF.twbx 1.2 MB
Try following steps:
1. Keep Customer Name on Rows in a new Worksheet.
2. Change marks to Shape
3.Drag Segment field to Shape and select required shapes. You can do this steps for color also.
4. Drag Segment field to Label.
5.Now you should have Shapes overlapping the Segment Names.
6. Change the fit to "Fit Width" or "Entire View".
Note: this method will work only if there is 1 to 1 relation between Customer and Segment for 1 particular row.
Your solution is exactly what I am looking for, but I don't understand where those green pills came from.
I tried using Number of Records, but that seems to be different that what you utilized?
1 of 1 people found this helpful
You may want to use a calculation like this:
It can be saved in the schema (in Measures)
and used as a drag-n-drop (Green) Pill on a view (on Columns).
Or it can be created right on a view via "in-place editing" --
simply double-clicking somewhere on Columns and entering a formula,
then pressing Enter, and voila -- the Green Pill would be created just in place.
Hope it helps.
BTW, I've used the MIN(7) pill in my wb, as you may notice :-)
This worked wonderfully! Now to just figure out how to resize the columns to fit the size of my text.
Thank you !
That's where it doesn't work as anticipated.
Tableau makes Panes (the 'Columns' in your notation) an equal size.
I could recall just one 'strange' example where on a particular view
the two adjacent Panes were of different sizes (their widths were different),
but i'm not sure where exactly it was.
So there would be cases where simply laying several single-column views
(with the same pill combinations on Rows) side-by-side on a dashboard
that makes the most sense.