my issue is that when I want to group a set of employees according to the month of their birth date, Odoo separates the months by years, which I want to avoid b
I'd like to make a visual with average amount (totalled per one or more teams) per month (while keeping date hierachy to show data per day). I have a table with
I have this Table (Counters): cell_id tftralacc tfnscan thtralacc thnscan date_time 13997 10 360 94 360 2022-02-22 00:00:00+01 13997 0 360 0 360 2022-02-22 01:
loan_id coll_date coll_pay_mode 8007571771 APR-2022 CH 8007571771 FEB-2022 CH 8007571771 JAN-2022 CH 8007571771 MAR-2022 CH 8007571771 MAR-2022 CL 8007571771 M
I have the following dataframe: # A tibble: 8 x 5 Year Group Unit Profit Sales <dbl> <chr> <chr> <dbl> <dbl> 1 2021 One
I have the following table of orders for users like the following: CREATE TABLE orders ( order_id UUID, user_id UUID, date date,
I have a query that looks like this: SELECT ordDetails.OrderId FROM orders.OrderDetail ordDetails WHERE ordDetails.Class <> 'O' GROUP BY ordDetails.
I have a long format dataset of 100,000+ individuals, capturing clinic visits at 5 different time points (not chronological). I've included an example dataset b
I have event, cases and roads tables. I want to join these 3 tables but i have a problem because there is two different road_id which matched same firstpoint, l
after 4 days of tries and researchs over the web I can't make my wishes working. Any help would be appreciated !Performed on MYSQL WORKBENCH I got a DB made of
I’m having trouble on a query right now to retrieve only the last value saved for each group of results. I explain myself with a table. I have these value
Can someone help me with the below. I have an input dataframe. ID process_type STP_stagewise 1 loan_creation Manual 1 loan creation NSTP 1 reimbursement STP 2
Here is what I am trying to get done. Partly I am thru, Partly I am stuck, and need some help. Table structure: CREATE TABLE UserRole ( Id bigint NOT NULL A
I am trying to find percentage based on id column. issue - I am trying to use count(column)/select count(column) from table which is giving output as 'Zero' Tab
I want to do a rolling sum based on different levels of the index but am struggling to make it a reality. Instead of explaining the problem am giving below the
I have 3 tables structure like below:- products id name 1 apple 2 orange branches id name 1 Branch 1 2 Branch 2 stocks id branch_id product_id qty 1
I have a following data: I want o summarise the data in three columns by Subject type and other two columns sates number of schools and number of students by ea
I have a set of records in a db table like this. The thing that logically links these records is guid1 and guid2 but not all records in the table have a full re
I have a pandas dataframe indexed by createdAt grouped by pid (participant identifiers). The created at column are unix timestamps. Now I would like to add a ne
I have a table like Date Balance A Balance B --------------------------------- 2022.03.01 100 200 2022.03.01 200 500 2022.03.02 300