Forum Discussion

nmeliasp's avatar
nmeliasp
Regular Visitor
7 years ago

Here is an example of what i am trying to calculate. This would be a DATEDIFF between Completion X and Completion Y, however these columns were melted into an attribute->value columns when i did an unpivot action on them. Hope this helps...

 

Completion XCompletion YCompletion ZCycle Time X-YCycle Time Y-Z
10/1/201811/1/201812/1/20183130
10/2/201811/12/201812/2/20184120
10/3/201811/3/201812/3/20183130
10/4/201811/14/201812/4/20184120
10/5/201811/5/201812/4/20183129
10/6/201811/16/201812/4/20184118
10/7/201811/7/201812/4/20183127
AlB's avatar
AlB
Community Champion
7 years ago

So you already have it. A DATEDIFF and that is it. What is the problem?

 

  • nmeliasp's avatar
    nmeliasp
    Regular Visitor
    7 years ago

    my problem now is i did an unpivot action and now my columns look like this

     

    Completion TypeCompletion Date
    Completion X10/1/2018
    Completion Y11/1/2018
    Completion Z12/1/2018

     

    I am trying to pivot these columns back but having trouble retainig the values. Is there a different way to calcuate the DATEDIFFs between these completion types withouth having to pivot the columns back?