Can anyone help me figure out why no date (only default) groupings are available?
Hmm, that definitely does not look right. Can you tell me the database type, what that column’s underlying data type is in the database, and what (if any) metadata type you’ve assigned to that column in the Data Model section of the Admin Panel?
Hi @maz,
The database type is MySQL.
This is the query:
SELECT
MIN(CAST(T.fecha AS DATE)) AS Fecha_primer_paciente,
MAX(CAST(T.fecha AS DATE)) AS Fecha_ultimo_paciente,
MAX(CAST(D.fecha AS DATE)) AS Fecha_ultima_visita,
COUNT (T.id) AS No_Atenciones,
SUM(ABS(PD.saldo - PD.abono - PD.desc) + PD.abono) as Ventas,
CONCAT( A.apellidos, ’ ', A.nombre ) AS Doctor,
B.nombre_padre as Direccion,
B.nombre_madre as Direccion2,
(
SELECT CONCAT( M.apellidos, ’ ', M.nombre )
FROM adm_user M
WHERE M.id = B.id_vendedor
) AS Vendedor
FROM test_completo T
INNER JOIN pagos_detalles PD ON PD.id_test_completo = T.id
INNER JOIN adm_empresa L ON T.id_empresa = L.id
INNER JOIN adm_user A ON T.id_doctor = A.id
INNER JOIN adm_user_doctor B ON A.id = B.id
INNER JOIN visitas_doctor D ON T.id_doctor = D.id_doctor
INNER JOIN comisiones C ON C.id = B.id_comisiones
INNER JOIN pacientes P ON P.id = T.id_paciente
INNER JOIN adm_empresa E ON E.id= T.id_empresa
INNER JOIN forma_pago F ON F.idformapago = PD.tipopago
INNER JOIN registro_pagos R ON R.id_pagos_detalles = PD.id
GROUP BY Doctor
In the data model the field “Fecha” by default it is set “Select a special type”
@rviteri Just to make totally sure, you’re using the final version of 0.33.0 and not one of the previews/RC builds? I’m asking, since I remember seeing what you’re showing in one of those versions.
@maz Notice the missing default granularity, which I thought we had smashed already (#10441), but maybe it was only done for years.
I can reproduce the missing default granularity with Sample Dataset, but not the “Default” options, on latest release-0.33.x
SELECT "User"."NAME" AS "NAME", count(*) AS "count", MIN(CAST("PUBLIC"."ORDERS"."CREATED_AT" AS DATE)) AS "MinOrder", MAX(CAST("PUBLIC"."ORDERS"."CREATED_AT" AS DATE)) AS "MaxOrder", MIN(CAST("Product"."CREATED_AT" AS DATE)) AS "MinProduct"
FROM "PUBLIC"."ORDERS"
LEFT JOIN "PUBLIC"."PRODUCTS" "Product" ON "PUBLIC"."ORDERS"."PRODUCT_ID" = "Product"."ID" LEFT JOIN "PUBLIC"."PEOPLE" "User" ON "PUBLIC"."ORDERS"."USER_ID" = "User"."ID"
GROUP BY "User"."NAME"
ORDER BY "User"."NAME" ASC
Hello! I am running v.33.0.