Delta between two macro dates

robert connet July 19, 2022

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?

2 answers

3 votes
Alexey Mikhaylov _Stiltsoft_ August 3, 2022

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:

image.png

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'

image.png

This is what you get as a result:

image.png

Best regards,

Alexey

0 votes
Bill Bailey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 20, 2022

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events