Delta between two macro dates

[robert connet]

I am trying to get a delta from two macro dates that are pulling from two sperate tables.  Is there a line of code that can be used in the table transformations that could accomplish this?

[Alexey Mikhaylov _Stiltsoft_]

Hello Robert,

You can use our Table Filter and Charts for Confluence app for this purpose.

You will need to work with the Table Transformer macro. Just wrap both tables into it:

And use the SQL query like this:

SELECT T1.'Key', DATEDIFF(DAY,T1.'Start Date',T2.'End Date') AS 'Delta'
FROM T1 OUTER JOIN T* ON T1.'Key' = T*.'Key'

This is what you get as a result:

Best regards,

Alexey

[Bill Bailey]

Hello @robert connet , not sure what you mean by "table transformations", but I know of no such solution in Cloud. It would require a custom app.