Grouping dimensions in Tableau but keep ungrouped data












0















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.....



enter image description here










share|improve this question




















  • 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
















0















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.....



enter image description here










share|improve this question




















  • 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














0












0








0








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.....



enter image description here










share|improve this question
















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.....



enter image description here







grouping tableau






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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














  • 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












1 Answer
1






active

oldest

votes


















0














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.






share|improve this answer























    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
    });


    }
    });














    draft saved

    draft discarded


















    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









    0














    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.






    share|improve this answer




























      0














      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.






      share|improve this answer


























        0












        0








        0







        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.






        share|improve this answer













        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.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 24 '18 at 20:03









        KalidasKalidas

        1363




        1363
































            draft saved

            draft discarded




















































            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.




            draft saved


            draft discarded














            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





















































            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







            這個網誌中的熱門文章

            Post-Redirect-Get with Spring WebFlux and Thymeleaf

            Xamarin.form Move up view when keyboard appear

            JBPM : POST request for execute process go wrong