Grouping dimensions in Tableau but keep ungrouped data
I am plotting sales vs departments over time in tableau. Time is on the column shelf, departments are on the rows shelf while sales is on text marks.
My departments measure is made up of depts. A-E and I would like to roll up depts. A as well as B into "A&B" and leave the rest as is.
On my bar chart I wish to plot time on the x axis, departments on the y-axis and the length of the bars are determined by value.
On my y axis I should see depts A - E as well as a bar for "A&B", in all there should be 6 bars in the bar chart.
I am aware of how to group data in Tableau but when I try it, it just rolls up the group I created and doesn't allow you to retain the original individual entries for comparison.
I'm pretty sure there's an easy way to do this in Tableau but true to form it does the hard things easily and.....
grouping tableau
add a comment |
I am plotting sales vs departments over time in tableau. Time is on the column shelf, departments are on the rows shelf while sales is on text marks.
My departments measure is made up of depts. A-E and I would like to roll up depts. A as well as B into "A&B" and leave the rest as is.
On my bar chart I wish to plot time on the x axis, departments on the y-axis and the length of the bars are determined by value.
On my y axis I should see depts A - E as well as a bar for "A&B", in all there should be 6 bars in the bar chart.
I am aware of how to group data in Tableau but when I try it, it just rolls up the group I created and doesn't allow you to retain the original individual entries for comparison.
I'm pretty sure there's an easy way to do this in Tableau but true to form it does the hard things easily and.....
grouping tableau
1
Shooting in the dark without a screenshot but try keeping the new group dimension on rows and then dragging the original depts dimension onto the Details mark card (or Labels mark card if you want it as a label).
– Sam M
Nov 23 '18 at 1:31
can you add a screenshot?
– Siva
Nov 23 '18 at 9:08
@SamM thanks for the response but that doesn't get me to where I want. I was hoping to group A & B together but also retain A and B individually, I would therefore have 6 rows, A -> E and another row for A&B grouped. I hope this makes sense.
– TheGoat
Nov 23 '18 at 10:57
1
@TheGoat From a usability and design perspective, what you are describing doesn't make much sense. If your users wants to see grand totals, you will end up having incorrect values. I'd suggest instead that you create a hierarchy with your new grouped dimension and the original dimension. This will allow your user to drill-down or drill-up, seeing detail or summary.
– Sam M
Nov 23 '18 at 19:18
add a comment |
I am plotting sales vs departments over time in tableau. Time is on the column shelf, departments are on the rows shelf while sales is on text marks.
My departments measure is made up of depts. A-E and I would like to roll up depts. A as well as B into "A&B" and leave the rest as is.
On my bar chart I wish to plot time on the x axis, departments on the y-axis and the length of the bars are determined by value.
On my y axis I should see depts A - E as well as a bar for "A&B", in all there should be 6 bars in the bar chart.
I am aware of how to group data in Tableau but when I try it, it just rolls up the group I created and doesn't allow you to retain the original individual entries for comparison.
I'm pretty sure there's an easy way to do this in Tableau but true to form it does the hard things easily and.....
grouping tableau
I am plotting sales vs departments over time in tableau. Time is on the column shelf, departments are on the rows shelf while sales is on text marks.
My departments measure is made up of depts. A-E and I would like to roll up depts. A as well as B into "A&B" and leave the rest as is.
On my bar chart I wish to plot time on the x axis, departments on the y-axis and the length of the bars are determined by value.
On my y axis I should see depts A - E as well as a bar for "A&B", in all there should be 6 bars in the bar chart.
I am aware of how to group data in Tableau but when I try it, it just rolls up the group I created and doesn't allow you to retain the original individual entries for comparison.
I'm pretty sure there's an easy way to do this in Tableau but true to form it does the hard things easily and.....
grouping tableau
grouping tableau
edited Nov 23 '18 at 11:02
TheGoat
asked Nov 23 '18 at 0:08
TheGoatTheGoat
3782520
3782520
1
Shooting in the dark without a screenshot but try keeping the new group dimension on rows and then dragging the original depts dimension onto the Details mark card (or Labels mark card if you want it as a label).
– Sam M
Nov 23 '18 at 1:31
can you add a screenshot?
– Siva
Nov 23 '18 at 9:08
@SamM thanks for the response but that doesn't get me to where I want. I was hoping to group A & B together but also retain A and B individually, I would therefore have 6 rows, A -> E and another row for A&B grouped. I hope this makes sense.
– TheGoat
Nov 23 '18 at 10:57
1
@TheGoat From a usability and design perspective, what you are describing doesn't make much sense. If your users wants to see grand totals, you will end up having incorrect values. I'd suggest instead that you create a hierarchy with your new grouped dimension and the original dimension. This will allow your user to drill-down or drill-up, seeing detail or summary.
– Sam M
Nov 23 '18 at 19:18
add a comment |
1
Shooting in the dark without a screenshot but try keeping the new group dimension on rows and then dragging the original depts dimension onto the Details mark card (or Labels mark card if you want it as a label).
– Sam M
Nov 23 '18 at 1:31
can you add a screenshot?
– Siva
Nov 23 '18 at 9:08
@SamM thanks for the response but that doesn't get me to where I want. I was hoping to group A & B together but also retain A and B individually, I would therefore have 6 rows, A -> E and another row for A&B grouped. I hope this makes sense.
– TheGoat
Nov 23 '18 at 10:57
1
@TheGoat From a usability and design perspective, what you are describing doesn't make much sense. If your users wants to see grand totals, you will end up having incorrect values. I'd suggest instead that you create a hierarchy with your new grouped dimension and the original dimension. This will allow your user to drill-down or drill-up, seeing detail or summary.
– Sam M
Nov 23 '18 at 19:18
1
1
Shooting in the dark without a screenshot but try keeping the new group dimension on rows and then dragging the original depts dimension onto the Details mark card (or Labels mark card if you want it as a label).
– Sam M
Nov 23 '18 at 1:31
Shooting in the dark without a screenshot but try keeping the new group dimension on rows and then dragging the original depts dimension onto the Details mark card (or Labels mark card if you want it as a label).
– Sam M
Nov 23 '18 at 1:31
can you add a screenshot?
– Siva
Nov 23 '18 at 9:08
can you add a screenshot?
– Siva
Nov 23 '18 at 9:08
@SamM thanks for the response but that doesn't get me to where I want. I was hoping to group A & B together but also retain A and B individually, I would therefore have 6 rows, A -> E and another row for A&B grouped. I hope this makes sense.
– TheGoat
Nov 23 '18 at 10:57
@SamM thanks for the response but that doesn't get me to where I want. I was hoping to group A & B together but also retain A and B individually, I would therefore have 6 rows, A -> E and another row for A&B grouped. I hope this makes sense.
– TheGoat
Nov 23 '18 at 10:57
1
1
@TheGoat From a usability and design perspective, what you are describing doesn't make much sense. If your users wants to see grand totals, you will end up having incorrect values. I'd suggest instead that you create a hierarchy with your new grouped dimension and the original dimension. This will allow your user to drill-down or drill-up, seeing detail or summary.
– Sam M
Nov 23 '18 at 19:18
@TheGoat From a usability and design perspective, what you are describing doesn't make much sense. If your users wants to see grand totals, you will end up having incorrect values. I'd suggest instead that you create a hierarchy with your new grouped dimension and the original dimension. This will allow your user to drill-down or drill-up, seeing detail or summary.
– Sam M
Nov 23 '18 at 19:18
add a comment |
1 Answer
1
active
oldest
votes
You can create a dashboard with 2 sheets. First one will have the A & B group and second one will have all have the rows from A to B.
This may not be an elegant solution but may meet your requirement.
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%2f53439285%2fgrouping-dimensions-in-tableau-but-keep-ungrouped-data%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
You can create a dashboard with 2 sheets. First one will have the A & B group and second one will have all have the rows from A to B.
This may not be an elegant solution but may meet your requirement.
add a comment |
You can create a dashboard with 2 sheets. First one will have the A & B group and second one will have all have the rows from A to B.
This may not be an elegant solution but may meet your requirement.
add a comment |
You can create a dashboard with 2 sheets. First one will have the A & B group and second one will have all have the rows from A to B.
This may not be an elegant solution but may meet your requirement.
You can create a dashboard with 2 sheets. First one will have the A & B group and second one will have all have the rows from A to B.
This may not be an elegant solution but may meet your requirement.
answered Nov 24 '18 at 20:03
KalidasKalidas
1363
1363
add a comment |
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%2f53439285%2fgrouping-dimensions-in-tableau-but-keep-ungrouped-data%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
1
Shooting in the dark without a screenshot but try keeping the new group dimension on rows and then dragging the original depts dimension onto the Details mark card (or Labels mark card if you want it as a label).
– Sam M
Nov 23 '18 at 1:31
can you add a screenshot?
– Siva
Nov 23 '18 at 9:08
@SamM thanks for the response but that doesn't get me to where I want. I was hoping to group A & B together but also retain A and B individually, I would therefore have 6 rows, A -> E and another row for A&B grouped. I hope this makes sense.
– TheGoat
Nov 23 '18 at 10:57
1
@TheGoat From a usability and design perspective, what you are describing doesn't make much sense. If your users wants to see grand totals, you will end up having incorrect values. I'd suggest instead that you create a hierarchy with your new grouped dimension and the original dimension. This will allow your user to drill-down or drill-up, seeing detail or summary.
– Sam M
Nov 23 '18 at 19:18