These are chat archives for getredash/redash

15th
Aug 2016
Travis Theune
@ttheune
Aug 15 2016 16:47
@arikfr I'm still having problems with the elasticsearch queries. mind if I PM you a link?
Mango Baaz
@Orange19810_twitter
Aug 15 2016 18:20
@arikfr or anyone else. Is there a way of combining two queries into one query but maintaining different column names?
Wesley
@WesleyBatista
Aug 15 2016 18:46
@Orange19810_twitter, I don't know if I got your doubt, but a JOIN would be an option?
Arik Fraimovich
@arikfr
Aug 15 2016 18:56
@ttheune you're welcome to send it, although me & my wife had a new baby last week so I got some back log :) will try to help if it's something simple or look into it later when things calm down.
Wesley
@WesleyBatista
Aug 15 2016 19:06
@arikfr, congratulations for the baby! :clap:
Arik Fraimovich
@arikfr
Aug 15 2016 19:06
Thanks :)
@WesleyBatista that's why I also didn't have the time to look at your pull request :-(
Wesley
@WesleyBatista
Aug 15 2016 19:07
oh, thats ok... it was for a good reason hahaha :grin:
Arik Fraimovich
@arikfr
Aug 15 2016 19:07
:D
Wesley
@WesleyBatista
Aug 15 2016 19:09
hope that he/she follow the path of the older one :)
blob
Arik Fraimovich
@arikfr
Aug 15 2016 19:09
LOL :) I don't even remember sharing this one.
Wesley
@WesleyBatista
Aug 15 2016 19:13
I don't know if it is easy to tell something about it right now, but I will make the question anyway. Hope not being taking to much from your time.
I am having issues with CircleCI. It is raising an error about redis.
Arik Fraimovich
@arikfr
Aug 15 2016 19:14
What's the error?
Wesley
@WesleyBatista
Aug 15 2016 19:15
It fails on this step:
$ nosetests --with-xunit --xunit-file=$CIRCLE_TEST_REPORTS/junit.xml --with-coverage --cover-package=redash tests/
Arik Fraimovich
@arikfr
Aug 15 2016 19:17
It's as if Redis isn't running. Maybe you need to specify Redis explicitly in circle.yml? I know we don't do it in our repo, but it's possible your tests run on a newer instance of their platform or something like this.
You should also remove the Gitter webhook.
Wesley
@WesleyBatista
Aug 15 2016 19:22
oh, sorry, I did not notice the notifications coming to here...
I will change it then I will try to specify the redis service along with docker.
thanks for the help! :+1:
Arik Fraimovich
@arikfr
Aug 15 2016 20:04
:+1:
Mango Baaz
@Orange19810_twitter
Aug 15 2016 20:24
@arikfr . Congraulations!. @WesleyBatista Its more a UI question then a query question. Want Two headers generated from one query
Arik Fraimovich
@arikfr
Aug 15 2016 20:27
@Orange19810_twitter can you give an example of such queries to better understand what you're trying to do? are they both querying the same db?
Mango Baaz
@Orange19810_twitter
Aug 15 2016 20:40
REVENUE MTD
Partner1 108.73
Partner2 17,385.30
Partner3 24,222.39
Total Revenue 41,716.42
Profit MTD
Partner1 54.37
Partner2 8,692.65
Partner3 12,111.20
Total Revenue 20,858.21
First is a revenue query result, another is a tac query result. Want to join both these queries. Showing it as a report
Having more then 1 header in a query for better visualization. Does it make sense?
Arik Fraimovich
@arikfr
Aug 15 2016 20:43
What database is this?
oh
you want each one to have its own header
no it's not possible
but why not create a dashboard and add each of these queries there?
dashboard is a more suitable medium for a report (when you ignore its name).
Mango Baaz
@Orange19810_twitter
Aug 15 2016 20:45
Amazon redshift.
Arik Fraimovich
@arikfr
Aug 15 2016 20:46

You can make a query that will have this side by side, i.e. result set the look slike:

partner | revenue mtd | profit mtd

But I think this is not what you're looking for.

Mango Baaz
@Orange19810_twitter
Aug 15 2016 20:46
Can i export all the data in the dashboard together?
Arik Fraimovich
@arikfr
Aug 15 2016 20:46
no
Mango Baaz
@Orange19810_twitter
Aug 15 2016 20:47
Yeah not really.
Thanks anyways
Wesley
@WesleyBatista
Aug 15 2016 23:33
Captura de Tela 2016-08-15 às 20.31.52.png
@arikfr, just as you said :)

Feature • Ubuntu 14.04 Trusty as the default OS for new projects

August 15 by Hirokuni Kim
We've switched the default OS for new Linux projects to Ubuntu 14.04 Trusty. Please note that the change applies only to new projects added to CircleCI from today on. If you wish to change the OS of your existing projects, you can do so from the “Build Environment” tab under Build Settings on your project's settings page.