12 Replies Latest reply on Jan 19, 2017 7:13 AM by ahmed.hasnaoui

Color Individual rows of cross-tab.

Shreya Gupta Jan 18, 2017 3:02 AM

Hi,

I have one dimension as date which I have plotted in columns. There are 8 measure names in rows. I want to color 4 measure name(specific) rows in one color and other 4 in other.
Please suggest how to color individual rows in one color.

Thank you

1. Re: Color Individual rows of cross-tab.

Norbert Maijoor Jan 18, 2017 3:11 AM (in response to Shreya Gupta)

Hi Shreya,

Would "Row Banding" be an option?
Like Show 0 Likes(0)

Actions
2. Re: Color Individual rows of cross-tab.

Shreya Gupta Jan 18, 2017 3:22 AM (in response to Norbert Maijoor)

Hi,

Thank you..
But this logic only worked when I had 8 rows..
In another sheet I have 16 rows and want to color 8 in 1 color and other in one color.
I was not able to achieve this.
Can you please help me with this query also?
Like Show 0 Likes(0)

Actions
3. Re: Color Individual rows of cross-tab.

Norbert Maijoor Jan 18, 2017 3:23 AM (in response to Shreya Gupta)

Hi Shreya,

Could you draw or "pica" your exact desired situation?
Like Show 0 Likes(0)

Actions
4. Re: Color Individual rows of cross-tab.

Shreya Gupta Jan 18, 2017 3:34 AM (in response to Norbert Maijoor)

There is a crosstab with dates in a column and there are 16 measure values in rows. I want first 7 rows to be in gray color and last 9 to be in green color. I have manually sorted the measure names as per my requirement.
Like Show 0 Likes(0)

Actions
5. Re: Color Individual rows of cross-tab.

Shreya Gupta Jan 18, 2017 3:53 AM (in response to Norbert Maijoor)

I want sth like this in tableau.
Like Show 0 Likes(0)

Actions
6. Re: Color Individual rows of cross-tab.

Norbert Maijoor Jan 18, 2017 5:37 AM (in response to Shreya Gupta)
Hi Shreya,

For sure not as desired but may be still an option

Colourrows.twbx 37.0 KB
Like Show 0 Likes(0)

Actions
7. Re: Color Individual rows of cross-tab.

Norbert Maijoor Jan 18, 2017 6:53 AM (in response to Norbert Maijoor)
Hi Shreya,

Here is the option you desire:) and found on the forum

It based on individual place holders so you are able to format each marks card separately.

Color of Entire row ML Multiple Axis Crosstab (1).twbx 15.3 KB
Like Show 1 Likes(1)

Actions
8. Re: Color Individual rows of cross-tab.

Shreya Gupta Jan 18, 2017 8:34 PM (in response to Norbert Maijoor)

For this method I will have to change the schema of the table and reinsert each and every detail.
Like Show 0 Likes(0)

Actions
9. Re: Color Individual rows of cross-tab.

Shinichiro Murakami Jan 18, 2017 10:38 PM (in response to Shreya Gupta)
Hi Shreya

This is still troublesome method, but might help a bit.
Edit datasource and create Union with two tables with same sheet.
Duplicate all the measure fields and create two groups of fields.
[Broadsoft BAS Available Capacity (copy)]
if [Table Name]="Sheet1" then [Broadsoft BAS Available Capacity] end
*
*
*
*
*
*
*
*
[SRP Requirements (CPS) (copy)]
if [Table Name]="Sheet11" then [SRP Requirements (CPS)] end

Then put numbr of records as Min in Row shelf and measure value as test with all newly created fields.
Put Table Name as Color.

Thanks,
Shin

Color_Rows_SM_9.3.twbx 36.4 KB
Like Show 2 Likes(2)

Actions
10. Re: Color Individual rows of cross-tab.

Shreya Gupta Jan 19, 2017 12:15 AM (in response to Shinichiro Murakami)

Hi Shin,

These are tables in my database and not excel sheets. I tried your method on tables with inner join, but did not solve my problem

Shreya
Like Show 0 Likes(0)

Actions
11. Re: Color Individual rows of cross-tab.

Shinichiro Murakami Jan 19, 2017 5:03 AM (in response to Shreya Gupta)

Mine is not inner join but UNION, only available >9.3 version.
Did you try union as well?

Thanks,
Shin
Like Show 0 Likes(0)

Actions
12. Re: Color Individual rows of cross-tab.

ahmed.hasnaoui Jan 19, 2017 7:13 AM (in response to Shreya Gupta)

I know this is not the answer you are looking for but Tableau is not build for that kind of viz.

I would recommend overthinking of what you try to visualize and chose the proper diagram/chart then.
I would recommend using small multiple column charts.

Cheers.
Like Show 0 Likes(0)

Actions