search

getredash / redash

Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
http://redash.io/
BSD 2-Clause "Simplified" License
26.02k stars 4.34k forks source link

Time series in pivot tables appear to be ordered by first letter of month - rather than by date #216

Open nickw-hailo opened 10 years ago

nickw-hailo commented 10 years ago

When dropping a "week" time series to get weekly metrics into the re:dash pivot table, re:dash appears to order based on first letter of the month instead of date/time eg. April, February, January, March, May). The query orders by time correctly, however.

arikfr commented 10 years ago

https://github.com/nicolaskruchten/pivottable/issues/169

rcoup commented 8 years ago

So, should re:dash be just using ISO format in the UI? (or pivot tables, at least). It's definitely a client-side formatting issue, since the JSON results data has timestamps in ISO format.

The comment on the above pivottable ticket implies it might be a wider issue...

I do think re:dash's time/date formatting could be more standardised. Another user has separately pointed out that when downloading date/time from re:dash via CSV, neither MS Excel nor GSheets can determine the fields with date/time are in fact date/time. This means a further reformat before they can be recognised and manipulated in a spreadsheet. Would be great to use a format that will get around both these issues.

arikfr commented 8 years ago

I don't we think should show ISO format in the UI, but rather just send it this way (or whatever format it needs) to the pivottable library.

matogertel commented 8 years ago

Having the same issue, but with weekdays instead of months. I agree with arikfr on this, send it in ISO to the pivottable library, and maybe add a field to the UI to customize the formatting. (with some sensible default)

kimiyuki commented 7 years ago

is it possible to apply REDAH_DATE_FORMAT config for the pivot UI? I don't understand technical details for it, but it would be great to fix the issue.

olilogic77 commented 7 years ago

Just trying out pivot tables and seeing the same issue - Friday, Monday, Saturday, Sunday ....

screen shot 2017-02-02 at 2 30 38 pm

dobesv commented 6 years ago

I ran into this and tried using DATE_FORMAT() to change the format of the date - but redash parsed the date and converted it into that format and sorted everything wrong anyway. I had to modify the date format to have a leading space to prevent it from being parsed and reformatted to the undesirable format starting with a week day.

dudanogueira commented 5 years ago

Same here. even tried YYYYMM format and always unsorted. It would be nice to be possible, for datetime pivot dates, to allow group an drill down by week, month, quarter and years.

dudanogueira commented 5 years ago

Obs: instalaled from the docker here: https://github.com/getredash/redash/blob/master/setup/docker-compose.yml

amirashakernady commented 2 years ago

Same here.it would be better if it solved