Ordering by Dates

[BiglifeMatt]

I'm trying to capture data from Nextcloud Tables using a date field for one of the columns. I want to list the totals of all the entries on a timeline. However, the dates are not laid out in chronological order, and I would like to find a way to actually represent the data by month, not the day. Any ideas how I can achieve this?

[Rello]

Hello,
can you show the data in the Nextcloud Table + enable the table in the report and post a screenshot?
did you use normal "line" or "timeline"?

[BiglifeMatt]

This one is using Line:

This one is using Timeline:

[Rello]

I can reproduce the error. I will check...

[Rello]

can you please enter this string in the chart options and let me know if it works?

{"scales": {"x": {"time": {"parser" : "YYYY-MM-DD"}}}}

[BiglifeMatt]

No, it looks the same. July 30, 2024 at 3:40 PM, "Rello" ***@***.***> wrote:

can you please enter this string in the chart options and let me know if it works? > > {"scales": {"x": {"time": {"parser" : "YYYY-MM-DD"}}}} > Bildschirmfoto.2024-07-30.um.21.39.52.png (view on web) https://github.com/user-attachments/assets/2f85b79c-b593-48ea-83f5-f2b9a15cf4f4 — Reply to this email directly, view it on GitHub #398 (comment) , or unsubscribe https://github.com/notifications/unsubscribe-auth/AWGSHRXHIPEQJQYZ5XWCOQLZO7T2ZAVCNFSM6AAAAABKVMDZO2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENJZGA3TONBSHE . You are receiving this because you authored the thread.

**Matt Coulter** **Director of Technology** ***@***.***** **(o) 706-940-5113**