Dividing values in a column

[Ramkumar Subramanian]

Hi, I am relatively new to Confluence.

Currently, I am trying to get a graphical output (bar chart) based on a report generated through Jira Core; X axis having all the users list and the Y axis with data of total time spent / remaining time left on a task.  Unfortunately, Jira Core only outputs the time in seconds and it seems there is no way to modify.

I am looking for a way to divide only 2 columns (Total time spent, Remaining time left) to be divided by 21600, so that the seconds can be converted to days. It would be great if there is some way to directly implement it in Confluence through a macro rather than depending on excel to do the conversion every time I plan to generate a report.

Any help would be appreciated. Thank you! 

[Katerina Kovriga _Stiltsoft_]

Hi @Ramkumar Subramanian

There are no any out-of-the-box tools to make calculations in Confluence tables.

We can recommend to use our app - Table Filter and Charts for Confluence.

It includes the Table Transformer macro: you wrap your table (or Jira macro) into its body and type in a simple SQL query to convert seconds into days. For example, something like this:

SELECT T1.'Total time spent'/21600 as 'Total time spent in days', T1.'Remaining time left'/21600 as 'Remaining time left in days', * FROM T*

Then you can use the Chart from Table macro and build a real-time dashboard. You can find different examples here.

As your instance is Cloud, you'll need to use the Table Toolbox to nest macros.

[Ramkumar Subramanian]

Hi @Katerina Kovriga _Stiltsoft_ 

Thanks for the quick reply. I will try using that and see if it works.