Stack Overflow
Stack Overflow

Questions tagged [metabase]

Metabase is an open source browser based analytics/data visualization tool.

Metabase is an open source browser based analytics/data visualization tool.

Its backend is implemented in Clojure and the frontend is built with React. Since Clojure is a JVM based language it can be deployed cross-platform as a single .jar.

382 questions
2
votes
2 answers

SQL Query to Bucket Table Items

I am trying to bucket values within my table by the range they fall in, for example, if my table is the following: course_name | current enrollment course_1 | 10 course_2 | 200 course_3 | 500 I get the following result: enrollment_range |…
rdurrani
  • 111
  • 1
  • 6
2
votes
2 answers

Not able to convert METABASE QUESTIONS to sql query for mongodb

I am using metabase as BI tool for our analytics and my current database is in mongodb. I am able to create questions in metabase but when I try to join collections or try to do some complicated operations then I am not able to do that without…
MAULIK MODI
  • 592
  • 6
  • 10
2
votes
0 answers

Kubernetes how do you create persistent volume on AWS Elastic Block Store

I try to create persistent volume with AWS Elastic Block Store, so whenever I deployed a metabase pods no need to worry to losing all initial data I've settled up. Here is Deployment yaml file: apiVersion: extensions/v1beta1 kind:…
Kris MP
  • 2,305
  • 6
  • 26
  • 38
2
votes
2 answers

Use Metabase on Ubuntu Service

I have tried to create an Ubuntu Upstart Service to Metabase, but I'm having trouble addressing the following points: 1) Set up database environment variables (port, ip and…
calebeaires
  • 1,972
  • 1
  • 22
  • 34
1
vote
1 answer

metabase path in iis

I am working on creating virtual directories for a website through a programmatic way. I couldn't get the concept of metabase- what is metabase path and need of it in IIS. thanks !
dotnetrocks
  • 2,589
  • 12
  • 36
  • 55
1
vote
1 answer

Invalid (private) key when connecting to Snowflake in Metabase

I'm running Metabase in a docker on a webserver. I'm trying to configure a connection to snowflake in the UI. I generated my (working) pkcs8 keys in the following way; ssh-keygen -t rsa -b 2048 -m pkcs8 -f ssh-keygen -e -f .pub -m…
Matthias Bakker
  • 31
  • 3
1
vote
1 answer

(Fiddle Link Available) ClickHouse changing column timezone by using a separate timezone column(string)

Fiddle Link -> https://fiddle.clickhouse.com/6a18d469-7019-44d2-a65b-828f5c6be755 Example Clickhouse Schema enter code here DateTable Date Timezone May 19, 2023, 04:00:00 Europe/London May 19, 2023, 04:00:00 Asia/Kolkata I can change…
Krishna Sai
  • 181
  • 1
  • 1
  • 11
1
vote
0 answers

Add Trino driver to metabase in docker - does not see Trino source in Metabase Web UI

I am trying to have Metabase in a Docker container and access Trino through it. So far I have added the trino-jdbc.jar in the plugins folder. But when I access the web ui and I am trying to add a new data source, it only shows the three sample…
luke33
  • 13
  • 3
1
vote
1 answer

How to get a percentage of weeks that have at least one occurrence?

In my app an area can have many happenings. I want to find out over a given timespan, what percentage of those weeks had at least one session listed. It doesn't matter how many were listed, so long as there was at least one. So as an example, say in…
DavidM
  • 173
  • 1
  • 9
1
vote
1 answer

Does MetaBase provide drill-down functionality?

I want to implement drilling in metabase dashboards. I discovered 'Custom Destinations' option which navigates user to any link upon clicking on a chart, but it does not carry forward the filter for selected dimension. Is there any way we can…
Abdullah Tariq
  • 55
  • 7
1
vote
1 answer

PostgreSQL/Metabase: How to create variable to filter by multiple numbers

I would like to filter by multiple ids (e.g. item ids of purchases). The following line of code does not seem to do the trick either for number or text variables (e.g. user names). How should I write this line of code so in the filtering field I…
Joehat
  • 979
  • 1
  • 9
  • 36
1
vote
1 answer

Dynamic filter based on boolean foreign value

Not being a SQL expert, and discovering Metabase here, so please be kind; I'm working on a dashboard that would offer a specific filter. For the sakes of clarity, I'll describe my simplified case. I have some projects in my DB. Some are "active",…
pixelboy
  • 739
  • 1
  • 12
  • 36
1
vote
2 answers

SQL query how to divide two selects that return multiple columns

I have the following table : city state numOrder date deadlineDate NY NY 111 2022/11/05 2022/11/06 LA CA 222 2022/11/01 2022/10/01 SD CA 333 2022/05/05 2022/11/06 LA CA 444 2022/11/01 2022/05/01 I need to calculate the number of…
mariana
  • 13
  • 3
1
vote
1 answer

Count unique Ids ($addtoSet) only if they meet a condition

I'm trying to modify this query generated by Metabase. It generates counts of unique Ids divided by weeks. What I'm trying to accomplish is get unique Id counts by weeks ONLY if each Id has at least X entries for that period of time. [ { …
visamagu
  • 37
  • 1
  • 4
1
vote
2 answers

Create XLSX file from file contents from server and save it

I got Node JS server which gets XLSX file contents from metabase: app.get('/channels', async (req, res) => { // make request to metabase and take response as XLSX const queryRequestURL =…
Alexander Guskov
  • 371
  • 1
  • 2
  • 14
1 2 3
…
25 26