Show Individual Versus Group Performance
I am trying to do something I feel should be fairly easy, which is showing Individual vs. group performance. I have a relatively simple set of data for revenue by 10 agents split by 2 teams:
Sample Data Set
Agent Team Revenue
Agent 1 Team A 1000
Agent 2 Team A 500
Agent 3 Team A 800
Agent 4 Team A 600
Agent 5 Team A 400
Agent 6 Team B 700
Agent 7 Team B 600
Agent 8 Team B 600
Agent 9 Team B 800
Agent 10 Team B 1000
I want the end user to be able to select an agent and then see the revenue from that agent and compare to the agents entire team. So for example, if I selected Agent 1, I'd like to see:
Output result
Agent Dollars Team Dollars
1000 3300
I feel like this should be relatively simple, but cannot for the life of me figure it out.
tableau
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
add a comment |
I am trying to do something I feel should be fairly easy, which is showing Individual vs. group performance. I have a relatively simple set of data for revenue by 10 agents split by 2 teams:
Sample Data Set
Agent Team Revenue
Agent 1 Team A 1000
Agent 2 Team A 500
Agent 3 Team A 800
Agent 4 Team A 600
Agent 5 Team A 400
Agent 6 Team B 700
Agent 7 Team B 600
Agent 8 Team B 600
Agent 9 Team B 800
Agent 10 Team B 1000
I want the end user to be able to select an agent and then see the revenue from that agent and compare to the agents entire team. So for example, if I selected Agent 1, I'd like to see:
Output result
Agent Dollars Team Dollars
1000 3300
I feel like this should be relatively simple, but cannot for the life of me figure it out.
tableau
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
Welcome to stackoverflow. Please remember to add what have you tried so far for future questions. It will increase your chances of getting an answer.
– Jose Cherian
Nov 15 '18 at 21:38
add a comment |
I am trying to do something I feel should be fairly easy, which is showing Individual vs. group performance. I have a relatively simple set of data for revenue by 10 agents split by 2 teams:
Sample Data Set
Agent Team Revenue
Agent 1 Team A 1000
Agent 2 Team A 500
Agent 3 Team A 800
Agent 4 Team A 600
Agent 5 Team A 400
Agent 6 Team B 700
Agent 7 Team B 600
Agent 8 Team B 600
Agent 9 Team B 800
Agent 10 Team B 1000
I want the end user to be able to select an agent and then see the revenue from that agent and compare to the agents entire team. So for example, if I selected Agent 1, I'd like to see:
Output result
Agent Dollars Team Dollars
1000 3300
I feel like this should be relatively simple, but cannot for the life of me figure it out.
tableau
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
I am trying to do something I feel should be fairly easy, which is showing Individual vs. group performance. I have a relatively simple set of data for revenue by 10 agents split by 2 teams:
Sample Data Set
Agent Team Revenue
Agent 1 Team A 1000
Agent 2 Team A 500
Agent 3 Team A 800
Agent 4 Team A 600
Agent 5 Team A 400
Agent 6 Team B 700
Agent 7 Team B 600
Agent 8 Team B 600
Agent 9 Team B 800
Agent 10 Team B 1000
I want the end user to be able to select an agent and then see the revenue from that agent and compare to the agents entire team. So for example, if I selected Agent 1, I'd like to see:
Output result
Agent Dollars Team Dollars
1000 3300
I feel like this should be relatively simple, but cannot for the life of me figure it out.
tableau
tableau
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
edited Nov 15 '18 at 18:02
mustaccio
14.4k83940
14.4k83940
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
asked Nov 15 '18 at 16:44
Jesse UJesse U
61
61
Welcome to stackoverflow. Please remember to add what have you tried so far for future questions. It will increase your chances of getting an answer.
– Jose Cherian
Nov 15 '18 at 21:38
add a comment |
Welcome to stackoverflow. Please remember to add what have you tried so far for future questions. It will increase your chances of getting an answer.
– Jose Cherian
Nov 15 '18 at 21:38
Welcome to stackoverflow. Please remember to add what have you tried so far for future questions. It will increase your chances of getting an answer.
– Jose Cherian
Nov 15 '18 at 21:38
Welcome to stackoverflow. Please remember to add what have you tried so far for future questions. It will increase your chances of getting an answer.
– Jose Cherian
Nov 15 '18 at 21:38
add a comment |
1 Answer
1
active
oldest
votes
Create a calculation called 'Team Dollars' as below. (This uses a FIXED LOD)
FIXED [Team]:SUM([Revenue])
Build the view as below
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
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%2f53324148%2fshow-individual-versus-group-performance%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
Create a calculation called 'Team Dollars' as below. (This uses a FIXED LOD)
FIXED [Team]:SUM([Revenue])Build the view as below
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
add a comment |
Create a calculation called 'Team Dollars' as below. (This uses a FIXED LOD)
FIXED [Team]:SUM([Revenue])Build the view as below
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
add a comment |
Create a calculation called 'Team Dollars' as below. (This uses a FIXED LOD)
FIXED [Team]:SUM([Revenue])Build the view as below
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
Create a calculation called 'Team Dollars' as below. (This uses a FIXED LOD)
FIXED [Team]:SUM([Revenue])Build the view as below
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
answered Nov 15 '18 at 21:34
Jose CherianJose Cherian
3,31812327
3,31812327
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%2f53324148%2fshow-individual-versus-group-performance%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
Welcome to stackoverflow. Please remember to add what have you tried so far for future questions. It will increase your chances of getting an answer.
– Jose Cherian
Nov 15 '18 at 21:38