Confluence - Quarter wise totals display in Gantt Chart

[Nagarajan Kalyana Subramanian]

Hi, i have a table with Task, Start Day, End Day and Count. I have used a Gantt macro to display this data. i have Gantt displayed with the count value as label.

i need to extend this table to show quarter wise totals (split of count value in quarters) and display in Gantt. is that possible?

please let me know. below is my current display.

[Stiltsoft support]

Hi @Nagarajan Kalyana Subramanian ,

Please define what macro (and what app) you are using to create your chart.

[Nagarajan Kalyana Subramanian]

i used table transformer macro to create the table data from jira, and then i used Gantt macro to create the Gantt chart. Hope this helps.

[Stiltsoft support]

The Table Transformer and Chart from Table are our macros and here is a bunch of useful hints how to built an advanced Gantt chart. 

But I'm not sure that it is possible to implement your case as it is.

As a workaround, you may try to divide your Count by the number of quarters in a period and show each quarter as a separate line on your chart.