The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi! I would like to know the best way to automatically show the difference between two cells in the same column. It should be a percent change from week to week. I'm using table transformer and SQL, and was wondering if there was code I could write to make this happen.
I was able to write SQL for the first column because I hardcoded a number into my formula:
SELECT T1.'Overall',
((T1.'Overall'-558785)/558785)*100 AS 'Percentage from Original, %'
FROM T1
but this is not effective for calculating the weekly percentage difference. Any help would be incredibly appreciated! See screen grab.
Hi @Holly Perry ,
It may be a little tricky to achieve with the Table Transformer macro, but here is the solution that our developers have come up with:
SELECT TT1.*,
TT2.'Week' AS 'Previous week',
((TT1.'Overall'-TT2.'Overall')/TT2.'Overall')*100 AS 'Percentage from Original, %'
FROM T1 AS TT1
LEFT JOIN T1 AS TT2 ON TT1.'Week' = (TT2.'Week' + 1)
We think that it will be easier to use the Table Spreadsheet macro - you'll be able to work with it like in Excel (use cells' formulas, etc.). It will be more user friendly to achieve the case.
This is incredible and works perfectly - thank you so so much! :) You are the best!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Holly Perry ,
Welcome to Atlassian community.
If you are using the table transformer then you should be able to use the formulas as per below doc
I could not try that but should be achievable i belive.
Have a good day.!
Thanks,
Srinath T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋♀️ ...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.