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
asked Nov 23 at 0:08
TheGoat
3182420
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
asked Nov 23 at 0:08
TheGoat
3182420
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 at 1:31
can you add a screenshot?
– Siva
Nov 23 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 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 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
asked Nov 23 at 0:08
TheGoat
3182420
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
asked Nov 23 at 0:08
TheGoat
3182420
asked Nov 23 at 0:08
TheGoat
3182420
edited Nov 23 at 11:02
asked Nov 23 at 0:08
TheGoat
3182420
asked Nov 23 at 0:08
TheGoat
3182420
asked Nov 23 at 0:08
TheGoat
3182420
3182420
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 at 1:31
can you add a screenshot?
– Siva
Nov 23 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 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 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 at 1:31
can you add a screenshot?
– Siva
Nov 23 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 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 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 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 at 1:31
can you add a screenshot?
– Siva
Nov 23 at 9:08
can you add a screenshot?
– Siva
Nov 23 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 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 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 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 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.
answered Nov 24 at 20:03
Kalidas
863
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.
answered Nov 24 at 20:03
Kalidas
863
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.
answered Nov 24 at 20:03
Kalidas
863
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.
answered Nov 24 at 20:03
Kalidas
863
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 at 20:03
Kalidas
863
answered Nov 24 at 20:03
Kalidas
863
answered Nov 24 at 20:03
Kalidas
863
answered Nov 24 at 20:03
Kalidas
863
863
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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 at 1:31
can you add a screenshot?
– Siva
Nov 23 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 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 at 19:18