Tableau - add row without making it a subset of previous row
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I want to add rows to a Tableau text table without making the row a subset of the previous row. Using the example below, I want values for teams and status to display on separate rows rather than status appearing as a subset of team. I also want to add a team filter so that if I filter on team blue, values for green row are zero and status values update . Is this possible? I tried creating separate worksheets but keeping things aligned is problematic.
Example Data:
Desired text table:
What I don't want:
tableau
asked Nov 26 '18 at 20:26
DreadDread
125212
add a comment |
I want to add rows to a Tableau text table without making the row a subset of the previous row. Using the example below, I want values for teams and status to display on separate rows rather than status appearing as a subset of team. I also want to add a team filter so that if I filter on team blue, values for green row are zero and status values update . Is this possible? I tried creating separate worksheets but keeping things aligned is problematic.
Example Data:
Desired text table:
What I don't want:
tableau
asked Nov 26 '18 at 20:26
DreadDread
125212
My initial reaction is that what you want to do is counter-intuitive and isn't the right thing to do. There is a way to do what you want but it's counter to how people intuitively view data and is confusing. And what happens when your users want subtotals or grand totals? Doing it the way you show will not yield correct answers.
– Sam M
Nov 27 '18 at 4:23
add a comment |
I want to add rows to a Tableau text table without making the row a subset of the previous row. Using the example below, I want values for teams and status to display on separate rows rather than status appearing as a subset of team. I also want to add a team filter so that if I filter on team blue, values for green row are zero and status values update . Is this possible? I tried creating separate worksheets but keeping things aligned is problematic.
Example Data:
Desired text table:
What I don't want:
tableau
asked Nov 26 '18 at 20:26
DreadDread
125212
I want to add rows to a Tableau text table without making the row a subset of the previous row. Using the example below, I want values for teams and status to display on separate rows rather than status appearing as a subset of team. I also want to add a team filter so that if I filter on team blue, values for green row are zero and status values update . Is this possible? I tried creating separate worksheets but keeping things aligned is problematic.
Example Data:
Desired text table:
What I don't want:
tableau
tableau
asked Nov 26 '18 at 20:26
DreadDread
125212
asked Nov 26 '18 at 20:26
DreadDread
125212
asked Nov 26 '18 at 20:26
DreadDread
125212
asked Nov 26 '18 at 20:26
DreadDread
125212
asked Nov 26 '18 at 20:26
DreadDread
125212
125212
My initial reaction is that what you want to do is counter-intuitive and isn't the right thing to do. There is a way to do what you want but it's counter to how people intuitively view data and is confusing. And what happens when your users want subtotals or grand totals? Doing it the way you show will not yield correct answers.
– Sam M
Nov 27 '18 at 4:23
add a comment |
My initial reaction is that what you want to do is counter-intuitive and isn't the right thing to do. There is a way to do what you want but it's counter to how people intuitively view data and is confusing. And what happens when your users want subtotals or grand totals? Doing it the way you show will not yield correct answers.
– Sam M
Nov 27 '18 at 4:23
My initial reaction is that what you want to do is counter-intuitive and isn't the right thing to do. There is a way to do what you want but it's counter to how people intuitively view data and is confusing. And what happens when your users want subtotals or grand totals? Doing it the way you show will not yield correct answers.
– Sam M
Nov 27 '18 at 4:23
My initial reaction is that what you want to do is counter-intuitive and isn't the right thing to do. There is a way to do what you want but it's counter to how people intuitively view data and is confusing. And what happens when your users want subtotals or grand totals? Doing it the way you show will not yield correct answers.
– Sam M
Nov 27 '18 at 4:23
add a comment |
1 Answer
1
active
oldest
votes
Select both the fields(team, status) simultaneously then right click and go to Transform > Pivot.
Then 2 Dimensions will be created. Drag the Pivot Field Values on to Rows section
and Year on to Columns section and keep Year in Discrete format.
Then drag Number of Records on to value field section.
Before Pivot:
After Pivot and final viz: 
answered Nov 27 '18 at 4:26
akshayakshay
617212
I don't have the Transform>Pivot option, but I was able to pivot by selecting the rows on the Data Source screen.
– Dread
Nov 27 '18 at 14:06
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53488532%2ftableau-add-row-without-making-it-a-subset-of-previous-row%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Select both the fields(team, status) simultaneously then right click and go to Transform > Pivot.
Then 2 Dimensions will be created. Drag the Pivot Field Values on to Rows section
and Year on to Columns section and keep Year in Discrete format.
Then drag Number of Records on to value field section.
Before Pivot:
After Pivot and final viz:
answered Nov 27 '18 at 4:26
akshayakshay
617212
I don't have the Transform>Pivot option, but I was able to pivot by selecting the rows on the Data Source screen.
– Dread
Nov 27 '18 at 14:06
add a comment |
Select both the fields(team, status) simultaneously then right click and go to Transform > Pivot.
Then 2 Dimensions will be created. Drag the Pivot Field Values on to Rows section
and Year on to Columns section and keep Year in Discrete format.
Then drag Number of Records on to value field section.
Before Pivot:
After Pivot and final viz:
answered Nov 27 '18 at 4:26
akshayakshay
617212
I don't have the Transform>Pivot option, but I was able to pivot by selecting the rows on the Data Source screen.
– Dread
Nov 27 '18 at 14:06
add a comment |
Select both the fields(team, status) simultaneously then right click and go to Transform > Pivot.
Then 2 Dimensions will be created. Drag the Pivot Field Values on to Rows section
and Year on to Columns section and keep Year in Discrete format.
Then drag Number of Records on to value field section.
Before Pivot:
After Pivot and final viz:
answered Nov 27 '18 at 4:26
akshayakshay
617212
Select both the fields(team, status) simultaneously then right click and go to Transform > Pivot.
Then 2 Dimensions will be created. Drag the Pivot Field Values on to Rows section
and Year on to Columns section and keep Year in Discrete format.
Then drag Number of Records on to value field section.
Before Pivot:
After Pivot and final viz:
answered Nov 27 '18 at 4:26
akshayakshay
617212
answered Nov 27 '18 at 4:26
akshayakshay
617212
answered Nov 27 '18 at 4:26
akshayakshay
617212
answered Nov 27 '18 at 4:26
akshayakshay
617212
617212
I don't have the Transform>Pivot option, but I was able to pivot by selecting the rows on the Data Source screen.
– Dread
Nov 27 '18 at 14:06
add a comment |
I don't have the Transform>Pivot option, but I was able to pivot by selecting the rows on the Data Source screen.
– Dread
Nov 27 '18 at 14:06
I don't have the Transform>Pivot option, but I was able to pivot by selecting the rows on the Data Source screen.
– Dread
Nov 27 '18 at 14:06
I don't have the Transform>Pivot option, but I was able to pivot by selecting the rows on the Data Source screen.
– Dread
Nov 27 '18 at 14:06
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53488532%2ftableau-add-row-without-making-it-a-subset-of-previous-row%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
My initial reaction is that what you want to do is counter-intuitive and isn't the right thing to do. There is a way to do what you want but it's counter to how people intuitively view data and is confusing. And what happens when your users want subtotals or grand totals? Doing it the way you show will not yield correct answers.
– Sam M
Nov 27 '18 at 4:23