These are chat archives for getredash/redash

11th
Jun 2015
rm420
@rm420
Jun 11 2015 14:29
Hi guys, starting to trial redash, when creating a chart, I choose to "sort x values" but when the same chart is viewed again the values are reset to the original "random" order, is there a way I can fix this outside of a query? Thanks in advance
Arik Fraimovich
@arikfr
Jun 11 2015 14:31
@rm420 do you know what version of re:dash you're using? (I want to try and reproduce this)
@rm420 I just tried it on the demo instance (http://demo.redash.io/queries/323/source#417) and it seems to work (notice there are two charts on this query, one sorted and one not). can you add a screenshot of how it looks on your side?
rm420
@rm420
Jun 11 2015 14:52
@arikfr using the latest bigquery build from the installation instructions (redash.0.6.0.b812-bq)
alt
The above is incorrect, with x sorted.
alt
The above is correct, with x sorted, but the values only stay sorted whilst on that page.
Interestingly enough, I have the same issue when pre-sorting the data in my query, the table view appears as should be, just the graph seems to re-order? I haven't done too much digging into this matter as I've only just started using the redash project, however if there is anything glaringly obvious I'm doing wrong, any help would be much appreciated. Thanks!
Arik Fraimovich
@arikfr
Jun 11 2015 14:58
@rm420 btw, on your instance, isn't "Sort X Values" enabled by default?
rm420
@rm420
Jun 11 2015 15:02
@arikfr yes, the value is defaulting to checked. Just not always adhering to this. I've managed to fix it with another sub query now.
Just to try to re-explain. I go to the edit query view, look at the chart and it appears fine, with x sorted correctly. After a page refresh this x value is unsorted again. It's by no means a major issue but I thought I'd bring it up anyhow.
Arik Fraimovich
@arikfr
Jun 11 2015 15:10
@rm420 first, thanks for reporting! I failed to reproduce it. Just to try and better understand the scenario:
  1. the x value is it an actual timestamp or string?
  2. did you save the chart before refreshing?
rm420
@rm420
Jun 11 2015 15:17
@arikfr
  1. x value is string value of a timestamp (SUBSTR(STRING(TIMESTAMP(timestamp/1000)),1,7))
  2. saved the chart before the refresh, confirmed by the "Visualisation saved" dialog.
Arik Fraimovich
@arikfr
Jun 11 2015 15:19
@rm420 an the x axis type is set to "date/time" or "category"?
(if you can screenshot the whole visualization settings, it will be great)
rm420
@rm420
Jun 11 2015 15:25
Screen Shot 2015-06-11 at 16.24.46.png
Arik Fraimovich
@arikfr
Jun 11 2015 15:25
Thanks.
rm420
@rm420
Jun 11 2015 15:25
np
Arik Fraimovich
@arikfr
Jun 11 2015 15:26
If I find the issue, should I ping you here or you want me to send your email address (mine is arik@arikfr.com)?
rm420
@rm420
Jun 11 2015 15:27
Sent you an email. Cheers
Arik Fraimovich
@arikfr
Jun 11 2015 15:29
I think I have an idea, why this happens to you, but didn't happen in my example. Anyway, will keep you updated.
gabrielcrowdtilt
@gabrielcrowdtilt
Jun 11 2015 18:12
what makes this blank page happen, sometimes the homepage comes up blank? have other people seen this, what would you suggest, https://www.dropbox.com/s/mz3r65cwgkzzqc1/Screenshot%202015-06-11%2011.11.33.png?dl=0
Arik Fraimovich
@arikfr
Jun 11 2015 18:21
@gabrielcrowdtilt Some buggy build tool generated bad minified JS that was working until recent update to Chrome. Upgrading to the latest version of re:dash should fix this.
gabrielcrowdtilt
@gabrielcrowdtilt
Jun 11 2015 18:22
thx ! i dont mind upgrading. ill look now.
Arik Fraimovich
@arikfr
Jun 11 2015 18:24
@gabrielcrowdtilt super. please let me know if it wasn't fixed by the upgrade.