Hi....I am new to Creating charts and tables with confluence.
I am using Table transformer macro. In a page I created the macro by typing {table transformer} inside the macro I pasted my table which looks like this
And then I am going to Edit mode of Table Transformer and Clicking on Custom transformation in Presets and in SQL i see SELECT * FROM T*
What I wanted to do is, create a Column in addition to the existing table as 'Remaining' which is 'Total' - 'Finished'.
How should i write an SQL Query to do this?
Kindly help me with this.
Hi Priya,
The query is
SELECT *, 'Total' - 'Finished' AS 'Remaining' FROM T*
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.