in Education by
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! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
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.

Related questions

0 votes
    Data that can be modeled as dimension attributes and measure attributes are called _______ data. (a) ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    What is Context Filter and show the steps on how to create the Context Filter Tableau?...
asked Nov 1, 2020 in Technology by JackTerrance
0 votes
    What is the difference between the quick filter and the normal filter in Tableau?...
asked Oct 31, 2020 in Technology by JackTerrance
0 votes
    How to remove the Show All option from a Tableau Auto Filter?...
asked Oct 29, 2020 in Technology by JackTerrance
0 votes
    How is the Context Filter different from other Filters in Tableau?...
asked Oct 29, 2020 in Technology by JackTerrance
0 votes
    Currently I'm returning column name of the max value in the each row. df['Active'] = df.idxmax( ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 5, 2022 in Education by JackTerrance
0 votes
    Currently I'm returning column name of the max value in the each row. df['Active'] = df.idxmax( ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 2, 2022 in Education by JackTerrance
0 votes
    Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    Which of the following value is the most common measure of statistical significance ? (a) P (b) A (c ... questions and answers pdf, Data Science interview questions for beginners...
asked Oct 28, 2021 in Education by JackTerrance
0 votes
    I have the following simplified query which should filter the decrypted column values SELECT ResourceId, ClientId, ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 5, 2022 in Education by JackTerrance
0 votes
    I am wanting to find the distance between two different points. This I know can be accomplished with the ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    ___ and ___ functions used to find the minimum and maximum value in a range. 1. Min , Max 2. Fast , Slow 3. ... , Filter 4. Less , More Select the correct answer from above options...
asked Dec 14, 2021 in Education by JackTerrance
0 votes
    The value of α in the pass band of constant k-low pass filter is? (a) 2 cosh^-1⁡(fc/f) (b) ... theory Questions for GATE EC Exam, Network Theory MCQ (Multiple Choice Questions)...
asked Oct 12, 2021 in Education by JackTerrance
...