These are chat archives for getredash/redash

12th
May 2016
Neil Shah
@shahneil88
May 12 2016 01:28
@arikfr - Thanks for the response. I think the UI which is shown after clicking the menu button can be improved a bit. Especially when you have "grouped" dashboard
It is really difficult to navigate to "sub dashboard" . Also "Dashboard" word is not seen
Screenshot_20160511-160015.png
Yoshiki Ozaki
@ikazoy
May 12 2016 05:28
blob
hi, I am wondering if the label of x axis (2016-xx something) could be shown fully like auto-scale ( not sure if it is a proper English or not). any suggestion would be helpful. thanks.
Neil Shah
@shahneil88
May 12 2016 05:41
@ikazoy - You can try to keep the widget size as double in dashboard. This will increase the size and x-axis might look better.
Is your x axis selected as Datetime ?
Yoshiki Ozaki
@ikazoy
May 12 2016 05:44
@shahneil88 thank you for your suggestion. actually, it is not datetime but category because i want to make the graph more flexible so it can be either daily summary or monthly summary with one sql / visualization.
This message was deleted
yep, it looks better.
blob
Neil Shah
@shahneil88
May 12 2016 05:47
Not sure if I understand it correctly, as what you mean by being flexible. But, if you keep that as category, I believe, it would be difficult to realign x axis text
Yoshiki Ozaki
@ikazoy
May 12 2016 05:55
indeed.
if the graph is daily basis, the x axis is like '2016-05-12' and Datetime works well. but if the graph is monthly basis, the x asis is like '2016-05' and only Category works well instead of Datetime... I know i could have separate sql. now i am putting a parameter to decide how the sql is GROUPED BY.
anyway, i think there might be other people who want to show x-asis Category properly if the name of categories is kinda long, not only me.
Neil Shah
@shahneil88
May 12 2016 05:57
Yes, but as I understand, this is limitation from plot.ly library
Yoshiki Ozaki
@ikazoy
May 12 2016 05:57
yeah, i just looked over the library
Yoshiki Ozaki
@ikazoy
May 12 2016 06:02
for the meantime, the double sized graph will do. thanks.
Yoshiki Ozaki
@ikazoy
May 12 2016 06:18

blob

another question, is there a way to make the origin of y-axis 0 which is currently 1?

it looks more natural if the origin of y-axis is 0
Neil Shah
@shahneil88
May 12 2016 08:03
When I do "select now()" on redash metadata --> It shows me UTC time (Incorrect Timezone)
When I do "select now()" or "show timezone" on my PostgreSQL RDS it shows me my correct timezone (Singapore) . My Ubuntu timezone is also Singapore. Not sure what the issue is.
Has anybody faced this before? How to resolve it? @arikfr
When I schedule my queries to run at 7:00 AM, in admin panel, it shows me that it is scheduled at 23:00, the previous day, which is -8:00 hours