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
Apr 13, 2018, 5:37 AM

Calculate a value sequentially based on another field value.

Hi,

 

Please find the attached item for a sample data set. below is a snapshot of the same. I am trying to find out the Target value  using Tableau. can some one please help me to get this calculation. I have given the explanation of the target calculation in the attached excel.

 

RptdateItemSLAWeek start DateActualTarget4/12/2018Item1154/9/2018370100%4/12/2018Item1154/16/2018302100%4/12/2018Item1154/23/201833557.142864/12/2018Item1154/30/201824104/12/2018Item1155/7/201837504/12/2018Item1155/14/201829804/12/2018Item1155/21/201825804/12/2018Item1155/28/201838404/12/2018Item1156/4/201827504/12/2018Item1156/11/201836704/12/2018Item1156/18/20183810

 

Regards,

philip

Test Data.xlsx
2 answers
  1. Steve Martin (Turning Point)
    Apr 13, 2018, 6:19 PM

    Hi Philip,

     

    Please can you elaborate as to what it is you are trying to do. Checking your attached spreadsheet has no further indication of what it is you are trying to do, aside from a hard-coded calculation of (4/7)*100

     

    Steve

Write an answer...
0/9000