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
0
votes
3 answers

asp.net iis metabase doesn't return all sites

I use code like the following in ASP.Net to enumerate the websites in IIS: string metabasePath = "IIS://localhost/W3SVC"; DirectoryEntry service = new DirectoryEntry(metabasePath); service.RefreshCache(); string className =…
mellamokb
  • 56,094
  • 12
  • 110
  • 136
-1
votes
1 answer

How to add metabase ip address to access my rds which in private subnet through VPC?

Metabase - IP addresses to whitelist There are some Amazon RDS databases that are in private subnet of my VPC. I want to connect to them through Metabase. I tried to add these IPs in the Security Group associated to the RDS instances. However, I was…
Logan
  • 11
  • 3
-1
votes
1 answer

Is there a way to filter AM and PM in time stamp?

I have a column contains values like 12:45 PM 11:00 AM . . ETC I want to count time contains AM and time contains PM in this column How to do this using select MYSQL ? I tried: (CASE WHEN start_booking_time LIKE'%AM%' THEN COUNT(id) ELSE 0…
Mohammad Al Mashwakhi
  • 21
  • 3
-1
votes
1 answer

How to extract specific info from JSON data on PostgreSQL

I would like to kindly ask for your help regarding the JSON Data on MySQL. [ {"type" : "PET", "rate_period" : "MONTHLY", "amount" : 100.00, "included" : false}, {"type" : "PARKING", "rate_period" : "MONTHLY", "amount" : 150.00, "included" :…
stefanos_1992
  • 1
  • 2
-1
votes
1 answer

SQL Code working but not giving the right numbers

SELECT bikers.id AS 'Biker ID', bikers.first_name AS 'Biker Name', SUM(offline_bookings.total_price) AS 'Offline Revenue', SUM(offline_bookings.main_service_count) AS 'Offline Cars' , SUM(offline_bookings.extra_service_count) AS…
Mohammad Al Mashwakhi
  • 21
  • 3
-1
votes
1 answer

How a new docker container based on the same image has custom files similar to a previous one?

I ran a metabase container using the command: docker run -d -p 8000:3001 -v metabase-data:/metabase-data -v ~/metabase-plugins:/plugins -e "MB_DB_FILE=/metabase-data" --name metabase-main metabase/metabase Afterward, I used docker cp to copy some…
Mike Abbey
  • 167
  • 1
  • 9
-1
votes
1 answer

SQL Join/Summarize/Fill empty columns - within one table

I think I need a join statement but all the join information I find is for 2 tables. I have data like this: And the rows refer to each other like this: I would like to combine the rows, and end up with this: I tried it with left join and inner…
user2133561
  • 155
  • 1
  • 10
-1
votes
1 answer

How can I generate a SQlite file?

I want to connect Sqlite to Metabase, however, Metabase asks for a .sqlite file to make the connection. I created a database using the command line and with Sqlite Browser. It creates the regular files (.db, journal) but I can't find any .sqlite…
Luis Felipe
  • 148
  • 9
-1
votes
1 answer

Remap SQL Using Case

I currently have a SQL query like this: SELECT `source`.`video_id` AS `video_id`, count(*) AS `count` FROM (SELECT *, (SELECT param.value.string_value FROM UNNEST(event_params) AS param WHERE param.key="content_type") as content_type, (SELECT…
Yogyakartas
  • 15
  • 4
-1
votes
1 answer

Replacing now () with current date and custom time

I'd like to replace now() with the current date and a custom time for example: 7/28/2021 8:00 AM (select count(*) from students where exams.id=students.exam_id and students.exam_id=exams.id and end_time <> ''and bb_user_id is not null and…
Vorcikle
  • 5
  • 2
-1
votes
1 answer

Metabase - Field Filter as text

I have this SQL query: select concept, count(*) from annotation where exists (select 1 from annotation a2 where a2.comment_commentid = annotation.comment_commentid and a2.concept = 'Fatigue' ) group by…
Renato Santos
  • 23
  • 4
-1
votes
1 answer

SQL joining a separate query as a column in original query

I am struggling with joining the below two queries. My main query is the first one below and what I am trying to achieve is the output of query 2's opt in rate column as a new column in my original query. SELECT…
Data Prospector
  • 27
  • 2
-1
votes
1 answer

metabase public link is not working. Website is not reachable

i finished my metabase dashboard and wanted to share it via the public link. But when using the public link i get an ERR_CONNECTION_TIMED_OUT error. "Website is not reachable. The answer of "IP" took too long. Metabase is running on a EC2 machine…
Russgo
  • 104
  • 6
-1
votes
1 answer

INNER JOIN of pagevies, contacts and companies - duplicated entries

In short: 3 table inner join duplicates records I have data in BigQuery in 3 tables: Pageviews with columns: timestamp user_id title path Contacts with columns: website_user_id email company_id Companies with columns: id name I want to display…
Patryk
  • 197
  • 1
  • 16
-1
votes
2 answers

How to get distance for the nearest city from Two different table and combining it into 1 column in PostgreSQL

i was stuck for days in this schema now. I am trying to populate distance column in a different table from other 2 tables. Inside the table there are lat, long, city id, distance, and location id. This is the current table that i wanted to…
William Adriel
  • 85
  • 6
1 2 3
…
25
26