I have created a custom field called Days Open using Calculated Number Field (by JWT)
Math/Numeric expression: {Date and time of resolution} !=null ? (( {Date and time of resolution} - {Date and time of creation})/ {DAY}) : (( {Current date and time} - {Date and time of creation} )/ {DAY})
Display format: Number with the following format: ##.#
The rounding to 1 decimal place works fine within JIRA but when displayed in Confluence using the macro; Insert Jira Issue/Filter, it displays a number to 15 decimal places.
Is there a way to get the rounding to come across in the Confluence view?
Hi @Spirit Super,
Your observation, that the number formatting is currently not forwarded to Confluence, is correct.
A current workaround, that results in your number being displayed with one decimal place in Jira and Confluence would be an update of your expression used within the calculated custom field as follows:
round(%yourOriginalCalculationHere% * 10) / 10
Cheers,
Thorsten
P.S. This is basically the recommended approach first mentioned by @Fabian Lim.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't believe you can do anything to format on the Jira Issues/filter macro.
I'm not a JWT expert, but I would try rounding it in the formula, if JWT allows you to.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Spirit Super ,
We can suggest trying our Table Filter and Charts for Confluence app and its Table Transformer macro.
Wrap your Jira Issues macro into the Table Transformer macro:
Here I use a simple manually created table, but our macros understand all the dynamically changing tabular Confluence macros such as Jira Issues, Page Properties Report, Content Report Table, etc.
Then use the following SQL query:
SELECT T1.'Issue',
ROUND(T1.'Days Opened', 1) AS 'Days Opened'
FROM T*
The Table Transformer macro also allows you to perform table calculations right in Confluence, and with the help of the other macros that are provided by our app you'll be able to create live Jira dashboards on your Confluence pages as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
As this Community thread mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.
The macro allows you to work with fully functional Excel spreadsheets right in Confluence.
You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.
The Table Spreadsheet macro is available for Cloud and Server/Data Center.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Katerina Kovriga _Stiltsoft_
It would be really awesome if I could wrap my Jira Issues macro into the new Table Spreadsheet macro! Is this possible today, and if not is it planned?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Keith Lanier,
Unfortunately, it is not possible as for now. But we do have such task on the roadmap – I’ve attached the link to this thread to the ticket. Once the feature is implemented, I’ll return here to notify you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great! Looking forward to when this will be released!
If you need beta tester, please reach out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Keith Lanier ,
Let me inform you we've released a new macro - Spreadsheet from Table - which allows transferring your regular table or a table outputting a macro's content (such as, for example, Jira macro or Page Properties Report) into Table Spreadsheet with all its tools. It is available starting from Table Filter and Charts for Confluence version 10.0.0.
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.