Leat Time Scatter Plot

Question

I'm putting together a lead time graph in COnfluence, extracting data from Jira and manipulating it in a transformer table in Confluence.
I managed to create the graph, using the Time line type, replacing the line with bubbles. All of this worked ok, but the problem is that when creating the graph when I have more than 1 record per date, it is adding up.
I don't want you to add up, I would like you to add the balls for each record.
it's possible?
example:
01 Feb 2024 3
01 Feb 2024 6
When placing the data on the graph, the values ​​3 and 6 are being added together, therefore it only shows 1 record with the sum (9).

Márcia Croce · Answer

It would be awesome to use this gadget, but I'm not authorized to instal anything in the Jira's company

Márcia Croce · Answer

Thanks a lot!!
It worked as I wanted!!!

Stiltsoft support · Answer

Hi @Márcia Croce ,

As you've mentioned the Table Transformer macro, I suppose you use our Chart from Table macro to create your graph.

So, the behavior is an expected one for Line Chart and Time Line Chart: if you have several numbers of smth belonging to one place (date, project, etc.), these numbers are summed up and then reflected on the graph.

You've mentioned that you use "the Time line type, replacing the line with bubbles" - so, I suppose that this is the case. And by the "bubbles" you mean using dots or dashes instead of a solid line. But the graph itself still remains Line or Timeline.

As a workaround, you may use the Bubble Chart type:

SELECT *,
"1" AS 'Dot'
FROM T*

Now as we draw real dots and not a dotted line, you can have several separate numbers to be reflected under the same date.