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
0 answers
How to return 0 if the value returned is null in MongoDB
So I'm trying to take a date from the user and then insert it into a mongodb query and then the query would return a number on this specific date. What I'm trying to reach is whenever the user enters a date that doesn't have a value in the db I need…
Mohamed Wahba
- 31
- 5
0
votes
1 answer
How do we calculate a monthly average value in MongoDB?
I have a list of documents in Mongo, each containing the value of a metric for a service for that day. The scheme is as follows:
_id: ObjectId("..."),
name: '',
service: '',
timestamp_unix:…
Emre Chomko
- 81
- 1
- 6
0
votes
3 answers
I want to calculate the sum of last transaction for A&B
Let's say the table looks like this:
user id
date
Amount
123
2022/11/01
5
456
2022/11/02
6
789
2022/11/03
8
123
2022/11/02
9
456
2022/11/04
6
789
2022/11/05
8
I want to calculate the sum of the very last transaction (only one…
Nanosa
- 3
- 3
0
votes
0 answers
Can we hide the parameter but the url remains dynamic
I want to hide the parameter - store user id from the users so that they can see their own data only not of others but It should be shown in the url so that we can give the value to it and change it to different users.
I tried to change the…
0
votes
0 answers
In clickhouse when I am storing the date in Char(50) field of a table in the redash output it is giving the date in Unix Epoch Timestamp
I am storing the data in clickhouse MergeTree table some of the fields are dates in that table and containing null values so I have stored these dates in type char(50) so that I don't have to store the null values instead I am storing blank string…
Vaibhav Yadav
- 3
- 2
0
votes
0 answers
Redash: Import Google Sheet with URL Parameters
I'm trying to generate a dashboard using information from Google Sheets.
I would like to be able to import the sheet ID dynamically (using URL params), but Redash won't allow it (unless the viewer has full database access) because it's a text…
Folded Panda
- 53
- 4
0
votes
0 answers
Accessing Postgress That is available through iap tunnel on local machine to a docker
I'm trying to access the Postgres that is available through IAP tunnel from GCP on a port in a docker application. But not able to access that one on that port. Tried using host.docker.internals and other solutions that are available on stack…
Nitro
- 41
- 5
0
votes
1 answer
How to use list of object ids inside $in inside $match in mongodb aggregation for redash visualization
I am trying to create a visualization in redash using mongo query, for few ids.I am trying to add multiple ids inside match , but its giving error, how we can give a list of object ids to match
{
"collection": "abc",
"aggregate": [
{
…
Mila
- 53
- 6
0
votes
0 answers
Is there any way to delete or hide Automated Materialized Views (AutoMV) tables from redshift users
I copied the tables from 1 Redshift Database to another Redshift Database through amazon redshift snapshots.
After successfully copying the tables from 1 DB to another DB there are some auto generated redshift tables "pg_automv.*" created.
I tried…
Tarun Bhardwaj
- 13
- 3
0
votes
1 answer
Redash v7 on Docker can't connect to RDS MySQL: "SSL connection error: unknown error number"
My Redash v7 server can't connect to Amazon RDS MySQL 8.0.28.
The error says "SSL connection error: unknown error number".
How can I solve this?
The server is running on Docker. Its image is redash/redash:7.0.0.b18042.
I tried replacing ca…
mythosil
- 273
- 1
- 9
0
votes
2 answers
Checking integer lists under a column for each record to tag/classify each record (SQL) - reverse index match (or some other way)?
I have a problem I'm trying to resolve. I'd love to get your ideas or help with the method I have in my mind. I created a good analogy for it: I need to tag each record in a table if they're partial purchases or not. It is clearer if you can look at…
0
votes
1 answer
I want to maintain a copy of the prod DB for analytics Rails 5.2.5 postgresql
I'm working on a Rails 5 app with postgres db. I want to expose the data to https://redash.io/ for reposting and data visualization but for safety reasons I don't want to directly expose the production db.
I'm thinking about trying to…
DukeSmellington
- 83
- 8
0
votes
1 answer
Connecting jira to redash
Has anyone an experience in connecting jira into redash? I've found the instruction on redash website, and finely connected to my jira account, but i want to do something like tempo report (in jira) in redash, with user filters to make reports for…
Dmitri
- 11
- 2
0
votes
1 answer
How to convert timestamp in Redshift so that I get seconds/milliseconds?
I have a dataframe like:
id state city time
123.04 ny 1 01-10-2021 12:30
123.05 ny 2 01-10-2021 12:30
I want the the id that that is associated with the most recent time by state. So I do:
select id, state…
mjoy
- 606
- 2
- 9
- 19
0
votes
1 answer
Query to display names for values instead of IDs between 2 tables
I have a table with the name of different sports
Sports Table
id name
----------
1 None
2 Baseball
3 Basketball
4 Football
And another table that associated states and their sports teams, based on the level of play for each…
Tim
- 11
- 1