Merging column names in Tableau
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I wish to merge the Q2 and Q3 columns into a single column and row and rename it to Q3 vs Q2 and I would like to rename the 2018 row to QoQ. The first image is where I am at and the second images is where I want to get to.
Is it possible to do this in tableau? Unfortunately I can't share the workbook due to data sensitivity issues, apologies.
Update: I have duplicated my date measure and renamed it to what I would like to display which has worked for the first row of the column but the second row still shows 2018 and I have no idea how to change it to 'Q3 vs Q2'.
tableau
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
add a comment |
I wish to merge the Q2 and Q3 columns into a single column and row and rename it to Q3 vs Q2 and I would like to rename the 2018 row to QoQ. The first image is where I am at and the second images is where I want to get to.
Is it possible to do this in tableau? Unfortunately I can't share the workbook due to data sensitivity issues, apologies.
Update: I have duplicated my date measure and renamed it to what I would like to display which has worked for the first row of the column but the second row still shows 2018 and I have no idea how to change it to 'Q3 vs Q2'.
tableau
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
add a comment |
I wish to merge the Q2 and Q3 columns into a single column and row and rename it to Q3 vs Q2 and I would like to rename the 2018 row to QoQ. The first image is where I am at and the second images is where I want to get to.
Is it possible to do this in tableau? Unfortunately I can't share the workbook due to data sensitivity issues, apologies.
Update: I have duplicated my date measure and renamed it to what I would like to display which has worked for the first row of the column but the second row still shows 2018 and I have no idea how to change it to 'Q3 vs Q2'.
tableau
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
I wish to merge the Q2 and Q3 columns into a single column and row and rename it to Q3 vs Q2 and I would like to rename the 2018 row to QoQ. The first image is where I am at and the second images is where I want to get to.
Is it possible to do this in tableau? Unfortunately I can't share the workbook due to data sensitivity issues, apologies.
Update: I have duplicated my date measure and renamed it to what I would like to display which has worked for the first row of the column but the second row still shows 2018 and I have no idea how to change it to 'Q3 vs Q2'.
tableau
tableau
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
edited Nov 26 '18 at 11:56
TheGoat
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
asked Nov 23 '18 at 14:33
TheGoatTheGoat
3982521
3982521
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Instead of using a table calculation as you have, you can create a calculation to achieve your desired result. This is done by isolating the quarters.
Something like this:
(sum(if datepart('quarter',[Date]) = 3 then [Pa Requests] end) -
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end))
/
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end)
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
thanks for the help with the calculated field this has inspired me for my YoY calculation also but I am still in the same position, I have the right values in my table but I still cannot change the column labels. I found a workaround where I created a duplicate dimension and renamed it. I then dropped this onto the column shelf and turned off the 'show header ' option but I am still left with the column showing 2018 and have no way to change it to 'Q3 vs Q2'.
– TheGoat
Nov 26 '18 at 11:51
add a comment |
Right click on the Q2 column header, and choose ‘hide’ to only display the second column
Similarly, try right clicking on column headers and editing an alias
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
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%2f53448579%2fmerging-column-names-in-tableau%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Instead of using a table calculation as you have, you can create a calculation to achieve your desired result. This is done by isolating the quarters.
Something like this:
(sum(if datepart('quarter',[Date]) = 3 then [Pa Requests] end) -
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end))
/
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end)
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
thanks for the help with the calculated field this has inspired me for my YoY calculation also but I am still in the same position, I have the right values in my table but I still cannot change the column labels. I found a workaround where I created a duplicate dimension and renamed it. I then dropped this onto the column shelf and turned off the 'show header ' option but I am still left with the column showing 2018 and have no way to change it to 'Q3 vs Q2'.
– TheGoat
Nov 26 '18 at 11:51
add a comment |
Instead of using a table calculation as you have, you can create a calculation to achieve your desired result. This is done by isolating the quarters.
Something like this:
(sum(if datepart('quarter',[Date]) = 3 then [Pa Requests] end) -
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end))
/
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end)
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
thanks for the help with the calculated field this has inspired me for my YoY calculation also but I am still in the same position, I have the right values in my table but I still cannot change the column labels. I found a workaround where I created a duplicate dimension and renamed it. I then dropped this onto the column shelf and turned off the 'show header ' option but I am still left with the column showing 2018 and have no way to change it to 'Q3 vs Q2'.
– TheGoat
Nov 26 '18 at 11:51
add a comment |
Instead of using a table calculation as you have, you can create a calculation to achieve your desired result. This is done by isolating the quarters.
Something like this:
(sum(if datepart('quarter',[Date]) = 3 then [Pa Requests] end) -
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end))
/
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end)
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
Instead of using a table calculation as you have, you can create a calculation to achieve your desired result. This is done by isolating the quarters.
Something like this:
(sum(if datepart('quarter',[Date]) = 3 then [Pa Requests] end) -
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end))
/
sum(if datepart('quarter',[Date]) = 2 then [Pa Requests] end)
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
answered Nov 23 '18 at 17:07
BernardoBernardo
2,3561516
2,3561516
thanks for the help with the calculated field this has inspired me for my YoY calculation also but I am still in the same position, I have the right values in my table but I still cannot change the column labels. I found a workaround where I created a duplicate dimension and renamed it. I then dropped this onto the column shelf and turned off the 'show header ' option but I am still left with the column showing 2018 and have no way to change it to 'Q3 vs Q2'.
– TheGoat
Nov 26 '18 at 11:51
add a comment |
thanks for the help with the calculated field this has inspired me for my YoY calculation also but I am still in the same position, I have the right values in my table but I still cannot change the column labels. I found a workaround where I created a duplicate dimension and renamed it. I then dropped this onto the column shelf and turned off the 'show header ' option but I am still left with the column showing 2018 and have no way to change it to 'Q3 vs Q2'.
– TheGoat
Nov 26 '18 at 11:51
thanks for the help with the calculated field this has inspired me for my YoY calculation also but I am still in the same position, I have the right values in my table but I still cannot change the column labels. I found a workaround where I created a duplicate dimension and renamed it. I then dropped this onto the column shelf and turned off the 'show header ' option but I am still left with the column showing 2018 and have no way to change it to 'Q3 vs Q2'.
– TheGoat
Nov 26 '18 at 11:51
thanks for the help with the calculated field this has inspired me for my YoY calculation also but I am still in the same position, I have the right values in my table but I still cannot change the column labels. I found a workaround where I created a duplicate dimension and renamed it. I then dropped this onto the column shelf and turned off the 'show header ' option but I am still left with the column showing 2018 and have no way to change it to 'Q3 vs Q2'.
– TheGoat
Nov 26 '18 at 11:51
add a comment |
Right click on the Q2 column header, and choose ‘hide’ to only display the second column
Similarly, try right clicking on column headers and editing an alias
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
add a comment |
Right click on the Q2 column header, and choose ‘hide’ to only display the second column
Similarly, try right clicking on column headers and editing an alias
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
add a comment |
Right click on the Q2 column header, and choose ‘hide’ to only display the second column
Similarly, try right clicking on column headers and editing an alias
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
Right click on the Q2 column header, and choose ‘hide’ to only display the second column
Similarly, try right clicking on column headers and editing an alias
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
answered Nov 25 '18 at 4:21
Alex BlakemoreAlex Blakemore
8,40821841
8,40821841
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%2f53448579%2fmerging-column-names-in-tableau%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
