-
1. Re: Color Individual rows of cross-tab.
Norbert MaijoorJan 18, 2017 3:11 AM (in response to Shreya Gupta)
-
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?
-
3. Re: Color Individual rows of cross-tab.
Norbert MaijoorJan 18, 2017 3:23 AM (in response to Shreya Gupta)
Hi Shreya,
Could you draw or "pica" your exact desired situation?
-
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.
-
5. Re: Color Individual rows of cross-tab.
Shreya Gupta Jan 18, 2017 3:53 AM (in response to Norbert Maijoor) -
6. Re: Color Individual rows of cross-tab.
Norbert MaijoorJan 18, 2017 5:37 AM (in response to Shreya Gupta)
-
Colourrows.twbx 37.0 KB
-
-
7. Re: Color Individual rows of cross-tab.
Norbert MaijoorJan 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.
-
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.
-
9. Re: Color Individual rows of cross-tab.
Shinichiro MurakamiJan 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
-
-
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
-
11. Re: Color Individual rows of cross-tab.
Shinichiro MurakamiJan 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
-
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.