search

Rello / analytics

Analytics - Open source data warehouse and reporting for Nextcloud
GNU Affero General Public License v3.0
116 stars 32 forks source link

Ordering by Dates #398

Open BiglifeMatt opened 3 months ago

BiglifeMatt commented 3 months ago

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

Rello commented 3 months ago

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 commented 3 months ago

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

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

Rello commented 3 months ago

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

Rello commented 3 months ago

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
BiglifeMatt commented 3 months ago

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**