These are chat archives for getredash/redash

14th
May 2015
martin sarsale
@runa
May 14 2015 14:01
@arikfr morning :)
@arikfr what do you think of g ? I need some highcharts cleverness here.
Arik Fraimovich
@arikfr
May 14 2015 14:04
@runa hi :) (it's 5pm over here)... about the chart: what would you like to see?
martin sarsale
@runa
May 14 2015 14:05
@arikfr well, currently I don't have many options. my first feature req for redash was being able to set a field as 'label' (apart from X, Y, Series and unused)
Arik Fraimovich
@arikfr
May 14 2015 14:06
let's assume we had this feature, what will happen then? I mean, there will be less values? but then it means it needs to draw more columns per X value, no?
martin sarsale
@runa
May 14 2015 14:06
@arikfr maybe highcharts could skip displaying a few of the X labels
Arik Fraimovich
@arikfr
May 14 2015 14:07
@runa I imagine it's possible to instruct it not to show them at all, will it help?
martin sarsale
@runa
May 14 2015 14:08
@arikfr if we had the 'use as label' option, yes
Arik Fraimovich
@arikfr
May 14 2015 14:10
because then you could use something else as X axis? (what?)
martin sarsale
@runa
May 14 2015 14:13
@arikfr well, I expected to get the columns without the labels; and those shown on mouse over
Arik Fraimovich
@arikfr
May 14 2015 14:14
@runa in such case, what you need is just "hide x axis labels", no? much simpler than deciding which column should be the label. I'll try to create an example on the demo instance.
martin sarsale
@runa
May 14 2015 14:14
@arikfr excelent!
Arik Fraimovich
@arikfr
May 14 2015 14:17
martin sarsale
@runa
May 14 2015 14:18
@arikfr yep!
Arik Fraimovich
@arikfr
May 14 2015 14:19
I'll try to add UI for it over the weekend, meanwhile you can manually enable it if you edit the visualizations options. What version of re:dash do you use?
martin sarsale
@runa
May 14 2015 14:19
@arikfr /opt/redash/redash.0.6.0.b722
Arik Fraimovich
@arikfr
May 14 2015 14:21
hmmm... newer versions have admin web interface which will make things easier, but you can edit stuff using the CLI. anyway you have 3 options:
  1. if you need to change a single visualization, you can edit its definition in the database/CLI.
  2. if you want to edit multiple, you can add additional permissions for your user to be able to edit the JSON from the UI (see screenshot).
  3. wait for me to implement UI for this.
blob
martin sarsale
@runa
May 14 2015 14:27
woa. shall I update to master?
Arik Fraimovich
@arikfr
May 14 2015 14:31
it will make things easier for you, as there is a web ui. or you can wait with upgrade until I imlpement the hide labels feature
martin sarsale
@runa
May 14 2015 14:31
nah, I'll upgrade
Arik Fraimovich
@arikfr
May 14 2015 14:32
k, after you upgrade the admin interface is at /admin
martin sarsale
@runa
May 14 2015 14:33
:)
tnx!
Arik Fraimovich
@arikfr
May 14 2015 14:33
you need to do the following:
  1. create new group (/admin/group/) with the permission: edit_raw_chart
  2. add this group to the list of groups your user has (/admin/user/)
then when you edit a visualization you will see the raw JSON like in the screenshot above
in the xAxis property at the bottom, add: labels: {"enabled": false}
martin sarsale
@runa
May 14 2015 14:52
@arikfr erm. sorry. already updated; now 'create a new group' where?
@arikfr ah. sorry :)
(!) I had never seen this screen before ;)
martin sarsale
@runa
May 14 2015 14:57
nice, @arikfr . tnx g
Arik Fraimovich
@arikfr
May 14 2015 15:43
@runa you didn't have this screen before this update.
@runa happy it works for you :)
martin sarsale
@runa
May 14 2015 15:43
@arikfr lol :) I always have the feeling I'm overlooking redash features
Arik Fraimovich
@arikfr
May 14 2015 15:44
@runa I'm pretty sure you overlook some, as there is no documentation ... :\ Did you know you can group dashboards in categories, if you name them "Category: Dashboard Name"? Or about filters? Variables in queries?
martin sarsale
@runa
May 14 2015 15:46
@arikfr none of this ;)
Arik Fraimovich
@arikfr
May 14 2015 15:46
:)
martin sarsale
@runa
May 14 2015 15:50
@arikfr um. I renamed my dashboards to "BR:Foo", "BR:Bar"
Arik Fraimovich
@arikfr
May 14 2015 15:50
and it grouped them under "BR"? if not, you might need to add a space after the ":"
"BR: Foo", "BR: Bar"
martin sarsale
@runa
May 14 2015 15:51
ups. I forgot the space. now what? everything seems kind of broken. shall I fix it from the db directly?
Arik Fraimovich
@arikfr
May 14 2015 15:51
no, you can rename from the dashboard settings
martin sarsale
@runa
May 14 2015 15:52
@arikfr yep, but now, I click on the 'dashboards' menu or the 'queries' menu but they seem to be empty
Arik Fraimovich
@arikfr
May 14 2015 15:52
strange, try to refresh the page?
martin sarsale
@runa
May 14 2015 15:53
still, everything is empty g
Arik Fraimovich
@arikfr
May 14 2015 15:53
hmmm
martin sarsale
@runa
May 14 2015 15:53
I think it happened exactly after I renamed the dashboards
Arik Fraimovich
@arikfr
May 14 2015 15:53
seems like something didn't load. can you check the browser's console for erros?
martin sarsale
@runa
May 14 2015 15:56
seems to be something broken in Uncaught SyntaxError: Unexpected identifier(anonymous function) @ plugins.f20b772b.js:formatted:12682(anonymous function) @ plugins.f20b772b.js:formatted:12682
letme debug this a little
here
CodeMirror.defineMIME("text/x-sql", {name: "sql",keywords: d(e + "begin"),builtin: d("bool boolean bit blob enum long longblob longtext medium mediumblob mediumint mediumtext time timestamp tinyblob tinyint tinytext text bigint int int1 int2 int3 int4 int8 integer float float4 float8 double char varbinary varchar varcharacter precision real date datetime year unsigned signed decimal numeric"),atoms: d("false true null unknown"),operatorChars: /^[*+\-%<>!=]/,dateSQL: d("date time timestamp"),support: d("ODBCdotTable doubleQuote binaryNumber hexNumber")}), CodeMirror.defineMIME("text/x-mysql", {name: "sql",client: d("charset clear connect edit ego exit go help nopager notee nowarning pager print prompt quit rehash source status system tee"),keywords: d(e + "accessible action add after algorithm all analyze asensitive at authors auto_increment autocommit avg avg_row_length before binary binlog both btree cache call cascade cascaded case catalog_name chain change changed character check checkpoint checksum class_origin client_statistics close coalesce code collate collation collations column columns comment commit committed completion concurrent condition connection consistent constraint contains continue contributors convert cross current_date current_time current_timestamp current_user cursor data database databases day_hour day_microsecond day_minute day_second deallocate dec declare default delay_key_write delayed delimiter des_key_file describe deterministic dev_pop dev_samp deviance directory disable discard distinctrow div dual dumpfile each elseif enable enclosed end ends engine engines enum errors escape escaped even event events every execute exists exit explain extended fast fetch field fields first flush for force foreign found_rows full fulltext function general global grant grants group groupby_concat handler hash help high_priority hosts hour_microsecond hour_minute hour_second if ignore ignore_server_ids import index index_statistics infile inner innodb inout insensitive insert_method install interval invoker isolation iterate key keys kill language last leading leave left level limit linear lines list load local localtime localtimestamp lock logs low_priority master master_heartbeat_period master_ssl_verify_server_cert masters match max max_rows maxvalue message_text middleint migrate min min_rows minute_microsecond minute_second mod mode modifies modify mutex mysql_errno natural next no no_write_to_binlog offline offset one online open optimize option optionally out outer outfile pack_keys parser partition partitions password phase plugin plugins prepare preserve prev primary privileges procedure processlist profile profiles purge query quick range read read_write reads real rebuild recover references regexp relaylog release remove rename reorganize repair repeatable replace require resignal restrict resume return returns revoke right rlike rollback rollup row row_format rtree savepoint schedule schema schema_name schemas second_microsecond security sensitive separator serializable server session share show signal slave slow smallint snapshot soname spatial specific sql sql_big_result sql_buffer_result sql_cache sql_calc_found_rows sql_no_cache sql_small_result sqlexception sqlstate sqlwarning ssl start starting starts status std stddev stddev_pop stddev_samp storage straight_join subclass_origin sum suspend table_name table_statistics tables tablespace temporary terminated to trailing transaction trigger triggers truncate uncommitted undo uninstall unique unlock upgrade usage use use_frm user user_resources user_statistics using utc_date utc_time utc_timestamp value variables varying view views warnings when while with work write xa xor year_month zerofill begin do then else loop repeat"),builtin: d("bool boolean bit blob decimal double enum float long longblob longtext medium mediumblob mediumint mediumtext time timestamp tinyblob tinyint tinytext text bigint int int1 int2 int3 int4 int8 integer float float4 float8 double char varbinary varchar varcharacter precision date datetime year unsigned signed
Arik Fraimovich
@arikfr
May 14 2015 15:57
it's minified, so hard to tell
ummm
Arik Fraimovich
@arikfr
May 14 2015 15:59
I need to go to put my girl to sleep. Be back later. Meanwhile you can try to rename them back (from the admin web UI: /admin/dashboard)
martin sarsale
@runa
May 14 2015 16:00
@arikfr sure :) good night!
martin sarsale
@runa
May 14 2015 16:17
interesting. seems to be random.
@arikfr I can reproduce this JS error in http://demo.redash.io/queries/146
martin sarsale
@runa
May 14 2015 17:11
(!!!)
wow filters
Arik Fraimovich
@arikfr
May 14 2015 17:59
@runa what's the steps to reproduce?
@runa re. filters: :) & it's possible to enable them in dashboards.
martin sarsale
@runa
May 14 2015 18:08
@arikfr not sure. it happens randomly. now everything works...
Arik Fraimovich
@arikfr
May 14 2015 18:11
Well, if you find some pattern, let me know. Anyway, glad it works for you.
martin sarsale
@runa
May 14 2015 18:47
crashed again, it's not reproducible..
Uncaught SyntaxError: Unexpected token ILLEGAL
plugins.f20b772b.js:1 Uncaught Error: [$injector:modulerr] Failed to instantiate module redash due to:
Error: [$injector:modulerr] Failed to instantiate module highchart due to:
Error: [$injector:nomod] Module 'highchart' is not available! You either misspelled the module name or forgot to load it. If registering a module ensure that you specify the dependencies as the second argument.
http://errors.angularjs.org/1.2.18/$injector/nomod?p0=highchart
at http://redash.int.properati.com/scripts/plugins.f20b772b.js:1:9490
at http://redash.int.properati.com/scripts/plugins.f20b772b.js:1:17394
at b (http://redash.int.properati.com/scripts/plugins.f20b772b.js:1:16977)
at http://redash.int.properati.com/scripts/plugins.f20b772b.js:1:17289
@arikfr can I make redash not use the minimized js?
@arikfr because I suspect chrome's prettyprint + breakpoints is not doing what I want
Arik Fraimovich
@arikfr
May 14 2015 18:48
@runa not with the "production" version.
martin sarsale
@runa
May 14 2015 18:49
@arikfr and.. what should I do to convert it to 'development' ? :)
I closed the tab, opened again and now it works
Arik Fraimovich
@arikfr
May 14 2015 18:50
@runa you can run a dev box in vagrant (http://redash.io/development/vagrant.html) and copy into your data