Why is all data summarized by year in my chart?

[Torkil Sinkaberg Johnsen]

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... :)

[Andrey Khaneev _StiltSoft_ · Accepted solution]

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]

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

[Torkil Sinkaberg Johnsen]

@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.

[Torkil Sinkaberg Johnsen]

Found it: https://docs.stiltsoft.com/display/public/TableFilter/FAQ#FAQ-Supporteddateformats

[Torkil Sinkaberg Johnsen]

I could get this to work with normal dates, but not with data that only has week numbers, like 2019-01, 2019-02 etc.

Tried both the yy-ww and yy-w formats, but the format is not recognized it says :( 

Any ideas on this one?

[Andrey Khaneev _StiltSoft_]

Support for weeks in dates was added in version 5.1.0. 

If you click What's new, then you'll see what version you are on: