Tableau - Filter Dimension on Max Value of Measure Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?Getting the index of the returned max or min item using max()/min() on a listlist comprehension vs. lambda + filterPython Pandas add column for row-wise max value of selected columnsTableau: calculated field after data is reshapedHow to create an Average of a Measure based on a Dimension in Tableau?Tableau: Filter results based on measure valuesTableau - Filter on maximum date within dimensionTableau percentage change of same measurePowerPivot DAX Max of two values
2018 MacBook Pro won't let me install macOS High Sierra 10.13 from USB installer
Sally's older brother
Does the transliteration of 'Dravidian' exist in Hindu scripture? Does 'Dravida' refer to a Geographical area or an ethnic group?
Why are current probes so expensive?
First paper to introduce the "principal-agent problem"
Can gravitational waves pass through a black hole?
As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?
Fit odd number of triplets in a measure?
How does the body cool itself in a stillsuit?
systemd and copy (/bin/cp): no such file or directory
Does the main washing effect of soap come from foam?
Determine whether an integer is a palindrome
Short story about astronauts fertilizing soil with their own bodies
Releasing Patch File for BSD3 Licensed Project
Found this skink in my tomato plant bucket. Is he trapped? Or could he leave if he wanted?
Did pre-Columbian Americans know the spherical shape of the Earth?
Is Mordenkainens' Sword under powered?
Why are two-digit numbers in Jonathan Swift's "Gulliver's Travels" (1726) written in "German style"?
The Nth Gryphon Number
What is a more techy Technical Writer job title that isn't cutesy or confusing?
Problem with display of presentation
Should man-made satellites feature an intelligent inverted "cow catcher"?
Why complex landing gears are used instead of simple, reliable and light weight muscle wire or shape memory alloys?
Can two people see the same photon?
Tableau - Filter Dimension on Max Value of Measure
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?Getting the index of the returned max or min item using max()/min() on a listlist comprehension vs. lambda + filterPython Pandas add column for row-wise max value of selected columnsTableau: calculated field after data is reshapedHow to create an Average of a Measure based on a Dimension in Tableau?Tableau: Filter results based on measure valuesTableau - Filter on maximum date within dimensionTableau percentage change of same measurePowerPivot DAX Max of two values
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I'm trying to calculate the MAX value of column D of value E which resets for every A Column. Later I just need to show the MAX row of A.
Raw data looks like this:
The desired view would be like this:
Thanks!
filter max tableau
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
add a comment |
I'm trying to calculate the MAX value of column D of value E which resets for every A Column. Later I just need to show the MAX row of A.
Raw data looks like this:
The desired view would be like this:
Thanks!
filter max tableau
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
add a comment |
I'm trying to calculate the MAX value of column D of value E which resets for every A Column. Later I just need to show the MAX row of A.
Raw data looks like this:
The desired view would be like this:
Thanks!
filter max tableau
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
I'm trying to calculate the MAX value of column D of value E which resets for every A Column. Later I just need to show the MAX row of A.
Raw data looks like this:
The desired view would be like this:
Thanks!
filter max tableau
filter max tableau
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
edited Mar 22 at 12:52
L.Rencoret
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
asked Mar 22 at 12:40
L.RencoretL.Rencoret
709
709
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This is an excellent example of a question which can/should be answered using LOD Calculations.
To start, find the maximum [Percentage] (Column E) per [Name] (Column B):
Fixed [Name]: MAX(Percentage)
Then insert that calculation, call it "Max Per Name", into another calculation which will only show the [Letter] (Column D) if the [Percentage] and the [Max Per Name] match:
IF [Percentage] = [Max Per Name] THEN [Letter] END
The result will be a dimension which shows the [Letter] which matches the largest [Percentage] and 'Null' when not matched.
From here, just filter out 'Null' - the result will be exactly as you desire. You will even be able to take [Percentage] off the view and still see an accurate [Letter].
Please note that while LOD Calculations are extremely powerful, they require a little more work to maintain and operate. They are a little more complex than normal calculations. Please take some time and read through this LOD Overview document to further familiarize yourself with their use/limitations.
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
Any luck on getting this solved? If you've solved on your own, please post answer and give green check mark to yourself. This will help others in the future with similar questions.
– Daniel Sims
Mar 29 at 19:00
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%2f55299831%2ftableau-filter-dimension-on-max-value-of-measure%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
This is an excellent example of a question which can/should be answered using LOD Calculations.
To start, find the maximum [Percentage] (Column E) per [Name] (Column B):
Fixed [Name]: MAX(Percentage)
Then insert that calculation, call it "Max Per Name", into another calculation which will only show the [Letter] (Column D) if the [Percentage] and the [Max Per Name] match:
IF [Percentage] = [Max Per Name] THEN [Letter] END
The result will be a dimension which shows the [Letter] which matches the largest [Percentage] and 'Null' when not matched.
From here, just filter out 'Null' - the result will be exactly as you desire. You will even be able to take [Percentage] off the view and still see an accurate [Letter].
Please note that while LOD Calculations are extremely powerful, they require a little more work to maintain and operate. They are a little more complex than normal calculations. Please take some time and read through this LOD Overview document to further familiarize yourself with their use/limitations.
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
Any luck on getting this solved? If you've solved on your own, please post answer and give green check mark to yourself. This will help others in the future with similar questions.
– Daniel Sims
Mar 29 at 19:00
add a comment |
This is an excellent example of a question which can/should be answered using LOD Calculations.
To start, find the maximum [Percentage] (Column E) per [Name] (Column B):
Fixed [Name]: MAX(Percentage)
Then insert that calculation, call it "Max Per Name", into another calculation which will only show the [Letter] (Column D) if the [Percentage] and the [Max Per Name] match:
IF [Percentage] = [Max Per Name] THEN [Letter] END
The result will be a dimension which shows the [Letter] which matches the largest [Percentage] and 'Null' when not matched.
From here, just filter out 'Null' - the result will be exactly as you desire. You will even be able to take [Percentage] off the view and still see an accurate [Letter].
Please note that while LOD Calculations are extremely powerful, they require a little more work to maintain and operate. They are a little more complex than normal calculations. Please take some time and read through this LOD Overview document to further familiarize yourself with their use/limitations.
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
Any luck on getting this solved? If you've solved on your own, please post answer and give green check mark to yourself. This will help others in the future with similar questions.
– Daniel Sims
Mar 29 at 19:00
add a comment |
This is an excellent example of a question which can/should be answered using LOD Calculations.
To start, find the maximum [Percentage] (Column E) per [Name] (Column B):
Fixed [Name]: MAX(Percentage)
Then insert that calculation, call it "Max Per Name", into another calculation which will only show the [Letter] (Column D) if the [Percentage] and the [Max Per Name] match:
IF [Percentage] = [Max Per Name] THEN [Letter] END
The result will be a dimension which shows the [Letter] which matches the largest [Percentage] and 'Null' when not matched.
From here, just filter out 'Null' - the result will be exactly as you desire. You will even be able to take [Percentage] off the view and still see an accurate [Letter].
Please note that while LOD Calculations are extremely powerful, they require a little more work to maintain and operate. They are a little more complex than normal calculations. Please take some time and read through this LOD Overview document to further familiarize yourself with their use/limitations.
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
This is an excellent example of a question which can/should be answered using LOD Calculations.
To start, find the maximum [Percentage] (Column E) per [Name] (Column B):
Fixed [Name]: MAX(Percentage)
Then insert that calculation, call it "Max Per Name", into another calculation which will only show the [Letter] (Column D) if the [Percentage] and the [Max Per Name] match:
IF [Percentage] = [Max Per Name] THEN [Letter] END
The result will be a dimension which shows the [Letter] which matches the largest [Percentage] and 'Null' when not matched.
From here, just filter out 'Null' - the result will be exactly as you desire. You will even be able to take [Percentage] off the view and still see an accurate [Letter].
Please note that while LOD Calculations are extremely powerful, they require a little more work to maintain and operate. They are a little more complex than normal calculations. Please take some time and read through this LOD Overview document to further familiarize yourself with their use/limitations.
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
answered Mar 22 at 16:37
Daniel SimsDaniel Sims
1,334217
1,334217
Any luck on getting this solved? If you've solved on your own, please post answer and give green check mark to yourself. This will help others in the future with similar questions.
– Daniel Sims
Mar 29 at 19:00
add a comment |
Any luck on getting this solved? If you've solved on your own, please post answer and give green check mark to yourself. This will help others in the future with similar questions.
– Daniel Sims
Mar 29 at 19:00
Any luck on getting this solved? If you've solved on your own, please post answer and give green check mark to yourself. This will help others in the future with similar questions.
– Daniel Sims
Mar 29 at 19:00
Any luck on getting this solved? If you've solved on your own, please post answer and give green check mark to yourself. This will help others in the future with similar questions.
– Daniel Sims
Mar 29 at 19:00
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%2f55299831%2ftableau-filter-dimension-on-max-value-of-measure%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
