I'm working on a BI request and I'm stuck and need your help :-) Here's the context : My company is receiving products and selling them. Until here, nothing complex :-) The selling price is varying depending on my available…
I have the following docker-compose.yml file networks: default: driver: bridge services: timescale: image: timescale/timescaledb:latest-pg15 ports: - "5432:5432" environment: POSTGRES_USER: timescaledb POSTGRES_PASSWORD: pass123 volumes: - ./timescaledb-data:/var/lib/postgresql/data metabase_admin_mysql: image: mysql:latest restart: always environment: MYSQL_ROOT_PASSWORD: your_root_password MYSQL_DATABASE: metabase MYSQL_USER: metabase_user MYSQL_PASSWORD: metabase_password healthcheck:…
How can I convert a Gregorian date to Jalali date in MongoDB? I tried adding the javascript function mentioned in this answer to my MongoDB query in Metabase but it doesn't support "$function" so I need a direct MongoDB query…
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 orders placed…