Redash is a tool to connect to any data source, easily visualize and share data using saved queries etc.
Redash is a tool to connect to any data source, easily visualize and share data using saved queries etc.
Check https://redash.io/ for more.
Questions tagged [redash]
140 questions
0
votes
1 answer
How to combine two different counts from two different date ranges sql
I'll try to keep this simple.
I have two queries that work just fine, they both count how many users signed up that day between a specific date range.
Query 1 - gets a list of users that signed up for each day a year from today. Here is a picture of…
user10869775
0
votes
1 answer
BI tool redash cannot parse unicode chinese
I want to query a column in Redash with SQL, but it does not support Chinese. Can anybody help me? Thanks!
SELECT user_history.id, user_history.user_id AS `汉字id`
FROM data_platform.user_history
WHERE dt = {{ dt}}
zuoli chen
- 1
- 2
0
votes
1 answer
502 bad request when I reboot aws AMI redash
I have created a new server redash in aws Region us-west-2.
after a setup superset in server but error. I reboot server instance in aws and redash don't active.
Bad Gateway: The proxy server received an invalid response from an
upstream server…
Nguyễn Hửu Vinh
- 13
- 1
0
votes
1 answer
How to get rows within specific sequence of value?
I need to get sessions where I one sequence of values in specific order.
Now I have this query which returns sessions for each user from raw data
select user_id, page, happened_at
from db as u1
where exists
(select 1 from db as u2
where…
Gleichmut
- 5,953
- 5
- 24
- 32
0
votes
1 answer
How to get user sessions?
I'm working with redash and I need to get user rows where for each row delta between date field is less than hour.
In more details: I need a session, user activity where it has some actions where end of the session defined by last action + 1 hour.…
Gleichmut
- 5,953
- 5
- 24
- 32
0
votes
0 answers
How to return both a scripted field as well as document fields in Elasticsearch?
I am trying to build a query that will return both its normal document values as well as one scripted field which I need to add some string to (enclose it in a anchor tag).
A friend told me to add _source: true but it just won't work. If I add…
Luis Novo
- 574
- 5
- 17
0
votes
2 answers
Aggregate data from days into a month
I have data that is presented by the day and I want to the data into a monthly report. The data looks like this.
INVOICE_DATE GROSS_REVENUE NET_REVENUE
2018-06-28 ,1623.99 ,659.72
2018-06-27 ,112414.65 …
Jason Quick
- 5
- 3
0
votes
2 answers
Get the list of user sessions SQL Redshift
I've got a table with 3 fields: userID, url and a loged datetime of user action. I want to write a query in sql Redshift in Redash, which returns a list of user session (all actions which have less that an hour between them) with fields userID,…
Migust_a
- 1
- 1
0
votes
1 answer
Redash how to change the dashboard datasource?
I'm new to Redash and trying to use it to analyze data.
I have created several queries and added to a dashboard.
Is Redash possible to change the datasouce on dashboard level instead of changing the datasouce of query one by one? (all datasource…
bns
- 397
- 1
- 5
- 13
0
votes
1 answer
Redash issue with Google Sheets
I have redash setup and I am able to connect to gsheet datasource but when I attempt a select query
select * from 1YaipA_nhUq5zl37EZ9tFa32qc4kgF1cMlo41ch1lcF4
I am getting
Error running query: Spreadsheet (select * from…
rbocchinfuso
- 15
- 3
0
votes
2 answers
How to uninstall Redash
My current installation of Redash is somehow corrupted (installing it in a new PC worked fine so I know my local copy is broken), and I want to basically remove it fully and install it again.
I cannot find any documentation of how to uninstall…
Srinath Ganesh
- 2,496
- 2
- 30
- 60
0
votes
1 answer
Change Values to Keys in MongoDB aggregation query
I have analytics documents in MongoDB that look like this:
{
"_id" : ObjectId("id1"),
"userObjectId" : "abc",
"eventType" : "First Signup",
"date" : ISODate("2017-09-10T20:46:42.144Z")
}
{
"_id" : ObjectId("id2"),
…
zorro2b
- 2,227
- 4
- 28
- 45
0
votes
0 answers
how to embed javascript ,html and css as a part of sql query through redash opensource tool
Postgres query:
SELECT "KPMID",
"CustomerID" as "cust_id::multi-filter",
"KPM_Name",
"Report_Period" as "rep_id::multi-filter", ''
"Actual",
CASE WHEN "TrendCode" = 'R' THEN '
Vijay Rajagopal
- 47
- 1
- 10
0
votes
1 answer
Redash chart converts x-axis to years when it's not
I ran a query that has results similar to these:
_col0 | _col1
1 | 151
2 | 4324
...
17 | 23413
When I try to create a chart, putting _col0 on the x-axis presto assumes the axis indicates years and gives me a graph with 20XX instead of…
Dotan
- 6,602
- 10
- 34
- 47
0
votes
0 answers
Without mysql stored procedure or udf
I am trying to implement a mysql query for some report and can't figure it out.
Let's say we have a 'companies' table, a 'users' and a 'company_users'.
The requested result set is:
'company_name', 'active_users', 'date'(lets say 30 days back).
So I…
Anton
- 540
- 3
- 13