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
1 answer

How to connect metabase with Keycloak?

I am trying to connect Metabase with Keycloak. Currently metabase does not have modular SSO out the box. But it currently has is Google SSO or LDAP integration. Is their any way keycloak can simulate as LDAP server?
Sabyasachi
  • 1,484
  • 12
  • 20
2
votes
3 answers

Get list of active users per day

I have a dataset that has a list of users that are connected to the server at every 15 minutes, e.g. May 7, 2020, 8:09 AM user1 May 7, 2020, 8:09 AM user2 ... May 7, 2020, 8:24 AM user1 May 7, 2020, 8:24 AM user3 ... And I'd like to get a…
2
votes
1 answer

Hide header and footer panel in Metabase

I have tried Metabase which is basically for charts and dashboards. We integrated with an Java application using IFRAME so far everything fine. But we want to remove header panel such as logo, icons. It seems that not difficult but quite a…
Raj
  • 31
  • 5
2
votes
1 answer

Error: Unable to access jarfile metabase.jar on Windows 10

I am trying to run Metabase for SQL queries and data viz. I am getting the following error when I enter: java -jar metabase.jar on the commandline. Error: Unable to access jarfile metabase.jar I have the most updated version of Java (as the default…
Lori Brok
  • 21
  • 2
2
votes
1 answer

Metabase deployed on Google App Engine doesn't work

After deploying Metabase in Gcloud, GAE app url shows error page. I followed all the instructions on this link https://www.cloudbooklet.com/install-metabase-on-google-cloud-with-docker-app-engine/ to deploy metabase on GAE. I have tried with both…
2
votes
1 answer

How to get the numeric ID of an IIS 6 Metabase property in C#?

The code below works OK and can read everything in a remote IIS 6 server's metabase -- except the frikkin' numeric ID of the properties. I can't find them in the PropertyValueCollection object. var site = new DirectoryEntry("IIS://" + tbHost.Text +…
JCCyC
  • 16,140
  • 11
  • 48
  • 75
2
votes
1 answer

Connecting Metabase with Docker SQL or Docker MongoDB container

I am trying to connect my Metabase docker container to my containers database containers. docker ps Metabase container created such as the docs: docker run -d -p 3000:3000 --name metabase metabase/metabase This are my networks: mongodb container…
freecks
  • 137
  • 4
  • 18
2
votes
0 answers

Numeric filters not work, =,<,> operator filters not work

I have setup metabase version 0.31 and connect druid broker node for quring. But when i try to do numeric filters (Long, int, double column types), =,<,> operating filters not work. Please help me to fixed this issue.
2
votes
0 answers

Deploy to heroku invalid URL repository

I am trying to deploy metabase to Heroku using the button: https://dashboard.heroku.com/new?button-url=http%3A%2F%2Fdownloads.metabase.com%2Flaunch-heroku.html&template=https%3A%2F%2Fgithub.com%2Fmetabase%2Fmetabase-deploy When selecting deploy,…
FJ1993
  • 115
  • 1
  • 8
2
votes
0 answers

How scraping metabase with zombie

I would like to scrap my website who's using metabase. For that I'm using Zombie module. For the example I used this url https://stats.metabase.com/auth/login?redirect=%2F but my website is similar. My code : const browser = new Browser({ debug:…
2
votes
2 answers

SQL Keyword Search using multiple optional field filters (Metabase)

I'm new to SQL(Self Taught) and to StackOverflow. So I apologize if there's a bit a newbspeak. Currently I'm attempting to write a query within Metabase that allows a user to search multiple fields within a certain date period without being 100%…
zDogwatch
  • 57
  • 7
2
votes
2 answers

Metabase Database Connection To MySQL RDS: Timed out after 5000 milliseconds

My Metabase is running on an Amazon Beanstalk instance and I have created an RDS database (MySQL) to which I have access to using the MySQL Workbench. When I try to add my database to Metabase, I get the following error message: Timed out after…
disasterkid
  • 6,948
  • 25
  • 94
  • 179
2
votes
2 answers

Sql - group by a range (m2) and sum the price of the elements in the range

I'm sql rookie and I don't know how to proceed with this query. I have this table m2AndPrices. It contains assets and their surface and value associated. |---------------------------------------------| |id | code | m2 | value…
P.H
  • 23
  • 4
2
votes
1 answer

SQL: Running Total of Occurrences

I am using Metabase with a PostgreSQL implementation. I'd like to achieve the outcome in the photo. I wish to include a column that counts how many times a field has occurred above. It should include the current instance as well. Other examples…
2
votes
2 answers

How do you reference "current date" in a Metabase MongoDB native query?

I would like to use manual logic inside of a Metabase question. When referencing "Past 30 days" for example, the Metabase query builder can dynamically update the question to reference the current date. When converted to a native query, however, the…
tonyyin
  • 321
  • 2
  • 9