Calculate date differences in Data Discovery formats

Sometimes you might want to calculate the difference between 2 dates - or maybe the difference between today and a certain date.

The data source could look something like this:

mceclip0.png

 

Now we want to calculate the difference between expected and actual dates.

First we add the data source, right click it and choose to create a format:

mceclip1.png

 

Now we add a new column by clicking the + sign in the upper right corner:

mceclip2.png

 

We define the new column like this - use the formula durationdays and make sure the destination type is integer:

mceclip3.png

 

Now we have a new column that shows the difference between these days in the column difference.

mceclip4.png

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.