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
Next: Root
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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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?
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.