I have a GUI question with custom columns. I try to drill down into the related data for a specific dimension but I have an error ERROR: column source: column name does not exist
my instance is running on v1.56.8.3
Can you paste the SQL for the query?
this is the sql behind the question
SELECT
"source"."shipment_status" AS "shipment_status",
"source"."Duration Count" AS "Duration Count",
"source"."Shipment status - order" AS "Shipment status - order",
COUNT(*) AS "count"
FROM
(
SELECT
"fct_order"."created_at" AS "created_at",
"fct_order"."order_status" AS "order_status",
"fct_order"."shipment_status" AS "shipment_status",
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) AS "Duration between order modifications",
CASE
WHEN (
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) < 1 THEN '0 day'
WHEN (
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) = 1 THEN '1 day'
WHEN (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) > 1
)
AND (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) <= 2
) THEN '2 days'
WHEN (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) > 2
)
AND (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) <= 3
) THEN '3 days'
WHEN (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) > 3
)
AND (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) <= 4
) THEN '4 days'
WHEN (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) > 4
)
AND (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) <= 5
) THEN '5 days'
WHEN (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) > 5
)
AND (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) <= 6
) THEN '6 days'
WHEN (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) > 6
)
AND (
(
CAST(NOW() AS DATE) - CAST("fct_order"."created_at" AS DATE)
) <= 7
) THEN '7 days'
ELSE '7+ days'
END AS "Duration Count",
CASE
WHEN "fct_order"."shipment_status" = 'Pending' THEN 1
WHEN "fct_order"."shipment_status" = 'Ready' THEN 2
WHEN "fct_order"."shipment_status" = 'Partial' THEN 3
WHEN "fct_order"."shipment_status" = 'Shipped' THEN 4
WHEN "fct_order"."shipment_status" = 'Delivered' THEN 5
END AS "Shipment status - order"
FROM
"data_mart_analytics"."fct_order"
WHERE
(
("fct_order"."shipment_status" <> 'Delivered')
OR ("fct_order"."shipment_status" IS NULL)
)
AND (
("fct_order"."order_status" <> 'Cancelled')
OR ("fct_order"."order_status" IS NULL)
)
AND (
("fct_order"."order_status" <> 'Complete')
OR ("fct_order"."order_status" IS NULL)
)
) AS "source"
GROUP BY
"source"."shipment_status",
"source"."Duration Count",
"source"."Shipment status - order"
ORDER BY
"source"."shipment_status" ASC,
"source"."Duration Count" ASC,
"source"."Shipment status - order" ASC