Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Time series chart macro with minutes Edited

I'm using the standard chart macro from Confluence to display time series data in a line diagram. I use the type timeSeries for the chart macro. In the first column of the input table, the timestamp is given in the format "dd.MM.yy HH:mm" and in the second column, the number of assets are given.

Despite there is no timestamp twice in the table, I get the following error:
"You are attempting to add an observation for the time period Thu Nov 07 00:00:00 UTC 2019 but the series already contains an observation for that time period. Duplicates are not permitted. Try using the addOrUpdate() method."

Screenshot 2019-11-22 at 21.44.55.png

Somehow, the macro cannot read the hours and minutes despite the date/time format should be ok.

The result should look similar to the following chart but as time series chart with correct gaps between the data points.

Screenshot 2019-11-22 at 22.25.12.png

Any idea?


3 answers

2 accepted

1 vote
Answer accepted

Hi, thanks for the help. Unfortunately, I do not have Table Filter and Charts installed. But the support team helped me to resolve it:
It looks like the time format field does not handle spaces well. I have altered the value to have "," between the date and time and adjusted the format and it looks good now.Screenshot 2019-11-28 at 23.26.47.png

Hi Christoph,

You can try Chart from Table macro as a workaround in case you have Table Filter and Charts installed. It can be combined with Pivot Table macro to aggregate time values by hours, for example, to get gaps when there are no values for corresponding time periods.

0 votes

Hello Christoph,

Thank you for contacting us. I noticed you raised the same question in our support queue. I'm not sure of the reason that you're getting this error, but when you are able to resolve it with the support team, could you please let us know where what the issue is?

I'd be interested to see and it can help users in the future.

Thank you!


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

408 views 23 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you