nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Why is all data summarized by year in my chart?

Torkil Sinkaberg Johnsen_sav6z4

I hope someone can help me understand why the Chart from Table macro summarizes year on the X-axis, instead of showing all dates.

I have the following table. It goes from 2019-01-01 to 2019-12-31, and the "Sheep" value from 1 to 365. Obviously just test data to see if I can get a linear line graph showing. Here are the first 10 lines:

But my graph just looks like this, with a single point where all the days are summarized:

How can I display a graph with all 365 data points? I don't get it...

Accepted answers

Andrey Khaneev _StiltSoft_

Hello @Torkil Sinkaberg Johnsen,

Please, switch the chart type from Line to Time Line and then set date format to yy-mm-dd.

All comments

Andrey Khaneev _StiltSoft_

Hello @Torkil Sinkaberg Johnsen,

Please, switch the chart type from Line to Time Line and then set date format to yy-mm-dd.

Torkil Sinkaberg Johnsen_sav6z4

My god... That easy eh? YOU ARE A LIFESAVER! Thanks Andrey!

Torkil Sinkaberg Johnsen_sav6z4

@Andrey Khaneev _StiltSoft_ do you know where I can find the documentation for those date formats?

Andrey Khaneev _StiltSoft_

Here are the docs.

Ans if you use the /dateMacro (entered with a slash), then you do not need to take care of the format - the chart will detect it automatically.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

chart