These are chat archives for getredash/redash

6th
Apr 2016
Neil Shah
@shahneil88
Apr 06 2016 09:47
@arikfr - Any special requirements that we need to adhere to before plotting cohort charts?
I am trying to plot a chart, but it shows blank values.
I have 4 columns
1) date
2) Period (day1,day2...day9)
3) new_users
4) retention values
Screen Shot 2016-04-06 at 5.50.19 PM.png
Screen Shot 2016-04-06 at 5.50.38 PM.png
Arik Fraimovich
@arikfr
Apr 06 2016 09:59
@shahneil88 see this example: http://demo.redash.io/queries/67#table
Neil Shah
@shahneil88
Apr 06 2016 09:59
I did. Do not see much difference though. Or may be, I am missing something
Arik Fraimovich
@arikfr
Apr 06 2016 10:00
It expects the column names to be as in the example
Neil Shah
@shahneil88
Apr 06 2016 10:09
Alright. Thanks
Alex Sukstansky
@alexsukstansky
Apr 06 2016 16:17
Greetings. I've started to get "Query in queue…" message on each request (before, the same requests took like 20 sec each to execute). Redshift doesn't show any new queries created. Is there anything I should check to fix the issue?
Alex Sukstansky
@alexsukstansky
Apr 06 2016 16:26
I've tried to restart server and celery, but got error "http://localhost:9001 refused connection"
Arik Fraimovich
@arikfr
Apr 06 2016 17:05
@alexsukstansky it might be that your workers are busy with another query or that this query is "locked". If you run a different query, does it get the same message?
re. "localhost:9001 connection refused" - might be some issue with supervisord, you can try restarting it
Alex Sukstansky
@alexsukstansky
Apr 06 2016 17:07
@arikfr Hi, yes. the other workers were pretty busy... with apparently more than 100K rows of unexpected stuff.
one more question/request - is it possible to collapse dimensions in pivot tables? and if not do you have plans to implement it
Arik Fraimovich
@arikfr
Apr 06 2016 17:11
You can add more workers if you need (and your server has enough resources).
Collapse dimensions - can you explain what do you mean?
Alex Sukstansky
@alexsukstansky
Apr 06 2016 17:14
Sure... Let me give an example. This folks have demo table on the front page. http://orbjs.net/ So there is a dimension "Adventure works" that splits in 3 "Monitors", "laptops" and "desktops"
You can open|collapse a group, and it automatically sums up the content of subgroups
Arik Fraimovich
@arikfr
Apr 06 2016 17:24
Nice! I don't think our current pivottable library supports this, but maybe we should switch to orbjs.
Alex Sukstansky
@alexsukstansky
Apr 06 2016 17:25
Glad that you liked :)
martin sarsale
@runa
Apr 06 2016 18:06
@arikfr hi! I just dropped by to say that even if I'm not here much, we're using redash daily
@arikfr and that we just updated to the latest release and it's cool :)
Arik Fraimovich
@arikfr
Apr 06 2016 18:06
:+1: :clap:
0.10 is going to be even more awesome ;)
martin sarsale
@runa
Apr 06 2016 18:06
@arikfr so, thank you for all your help :)
Arik Fraimovich
@arikfr
Apr 06 2016 18:06
(did you see the screenshots of the new UI?)
martin sarsale
@runa
Apr 06 2016 18:06
@arikfr no, where?
Arik Fraimovich
@arikfr
Apr 06 2016 18:06
I posted yesterday or the day before here.
martin sarsale
@runa
Apr 06 2016 18:07
letme scroll up
martin sarsale
@runa
Apr 06 2016 18:07
:)
looks great