These are chat archives for getredash/redash

27th
Aug 2016
J C Lawrence
@clearclaw
Aug 27 2016 00:23
A really small thing, but it would be nice if the list of tables in the current schema could be dragged/resized/made wider. Some of our table names have longer common prefixes and we can't see which are which because they're cropped at the right.
Other than that my users are loving the new version.
Norbert Bede
@norbertbede
Aug 27 2016 12:04
orderby-axis-filter.png
hi. i have created a "deliveries driver/Month. my goal you can see in attached figure

my issue, cant answer is how influence filter order by. looks me only 1 option is order by clause. i aware no option atm, my select is:

select
date(shipdate),
shipregion,
year as "Year::filter",
month as "Month::multi-filter",
(sum(count(1)) over (partition by month, shipregion)) as shipments

from olap.logistic_facts
group by shipdate, shipregion, year,month

order by shipments desc, year asc, month asc

Arik Fraimovich
@arikfr
Aug 27 2016 12:09
iirc, its order is taken from the order in the result set. it's possible the first year in your result set doesn't have January hence it gets added last. unfortunately if you change the order to month, year you might get the year out of order :-\
@clearclaw you're welcome to open an issue to document this request (or better yet: submit a pull request) :+1:
Norbert Bede
@norbertbede
Aug 27 2016 12:13
@arikfr would be better to take order by parameters other way - independently
eg in chart def
there is on x axis = Sort Values
Arik Fraimovich
@arikfr
Aug 27 2016 12:17
filters are not only for charts
Norbert Bede
@norbertbede
Aug 27 2016 12:17
this override result set order
Arik Fraimovich
@arikfr
Aug 27 2016 12:17
eventually we will have a UI for them though, as it makes no sense to enable them or control from the query text
Norbert Bede
@norbertbede
Aug 27 2016 12:21
is this plan ?
Arik Fraimovich
@arikfr
Aug 27 2016 12:21
what do you mean? is it on the roadmap?
Norbert Bede
@norbertbede
Aug 27 2016 12:21
yes.
because not understand exactly your last response
Arik Fraimovich
@arikfr
Aug 27 2016 12:22
it's the way I think it should be solved. I have no concrete plans to work on it in the immediate future.
Norbert Bede
@norbertbede
Aug 27 2016 12:23
is it necessary to enter issue for later improvement ?
however i was not sure im understand all possibilites, that was the reason why asking this topic
to achive my use case
Arik Fraimovich
@arikfr
Aug 27 2016 12:25
you can check the code, but if I remember correctly, it just takes the values from the result set in the order they appear. so you need to make sure they are ordered properly in the query...
Norbert Bede
@norbertbede
Aug 27 2016 12:26
ok. i will collect all my requests - cant achieve . thanks for followup
Arik Fraimovich
@arikfr
Aug 27 2016 12:26
:+1: