You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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: