Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Dec 26, 2018, 3:57 AM

Create a new measure from an existed measure

Hi, I have stuck with this problem for a while and cannot find a solution.

My data set looks like table below

  

NameidMeasure 1Measure 2 A10.290.01A20.770.86A30.730.51A40.760.80A50.060.36A60.030.64B10.760.07B20.380.49B30.620.71B40.980.89B50.160.71B60.390.79C10.970.48C20.090.55C30.310.76C40.640.35C50.980.65C60.520.71

 

what i want is a table like this. that's to pick the third value from measure 1 and pick the first value from measure 2 and then make them two new measures.

I knew it can be done by pivot function, but I was wondering if there a way to do the same thing by calculated field or other functions? Thanks in advance.

   

NameMeasure 1 when id = 3Measure 2 when id = 1A0.600.87B0.170.36C0.790.33
3 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Dec 26, 2018, 8:42 AM

    Hi Jiawei,

     

    Not sure but find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.

     

    Hi Jiawei, Not sure but find my approach as reference below and stored in attached workbook version 10.5 located in the original thread. M.

     

    M. Measure1/2:

    if [Id]=3 then [Measure 1]

    elseif [Id]=1 then [Measure 2]

    END

     

    Hope it helps.

     

    Regards,

    Norbert

Write an answer...
0/9000