analytics icon indicating copy to clipboard operation
analytics copied to clipboard

Ordering by Dates

Open BiglifeMatt opened this issue 1 year ago • 5 comments

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?

Screenshot 2024-07-10 133135

BiglifeMatt avatar Jul 10 '24 17:07 BiglifeMatt

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"?

Rello avatar Jul 30 '24 13:07 Rello

This one is using Line: Screenshot 2024-07-30 132206

This one is using Timeline: Screenshot 2024-07-30 132226

BiglifeMatt avatar Jul 30 '24 17:07 BiglifeMatt

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

Rello avatar Jul 30 '24 19:07 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"}}}}

Bildschirmfoto 2024-07-30 um 21 39 52

Rello avatar Jul 30 '24 19:07 Rello

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 https://github.com/Rello/analytics/issues/398#issuecomment-2259077429 , 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

BiglifeMatt avatar Jul 30 '24 20:07 BiglifeMatt

Hello,

I just found this open topic. a date-sorting was introduced with recent releases. please report back if this issue is still exiting

Rello avatar May 25 '25 17:05 Rello