Hi
I'm using metabase 0.47.6 and I found that that in the scatter chart, there is missing some line style options that it was exist in my previous 0.46 version.
The menu is in the setting in the Y axis option --> formatting / style
Some menu dissapeared :
Hi @Luiggi@alexyar
I have try to create same condition with sample database .
this is SQL autoproduce by metabase :
SELECT
"source"."Products__CATEGORY" AS "Products__CATEGORY",
CAST(AVG("source"."sum") AS float) / NULLIF(
SUM(SUM("source"."sum")) OVER (
ORDER BY
"source"."Products__CATEGORY" ASC ROWS UNBOUNDED PRECEDING
),
0
) AS "% subtotal",
CAST(AVG("source"."sum_2") AS float) / NULLIF(
SUM(SUM("source"."sum_2")) OVER (
ORDER BY
"source"."Products__CATEGORY" ASC ROWS UNBOUNDED PRECEDING
),
0
) AS "% tax"
FROM
(
SELECT
"source"."Products__CATEGORY" AS "Products__CATEGORY",
"source"."sum" AS "sum",
"source"."sum_2" AS "sum_2"
FROM
(
SELECT
"Products"."CATEGORY" AS "Products__CATEGORY",
SUM("PUBLIC"."ORDERS"."SUBTOTAL") AS "sum",
SUM("PUBLIC"."ORDERS"."TAX") AS "sum_2"
FROM
"PUBLIC"."ORDERS"
LEFT JOIN "PUBLIC"."PRODUCTS" AS "Products" ON "PUBLIC"."ORDERS"."PRODUCT_ID" = "Products"."ID"
GROUP BY
"Products"."CATEGORY"
ORDER BY
"Products"."CATEGORY" ASC
) AS "source"
) AS "source"
GROUP BY
"source"."Products__CATEGORY"
ORDER BY
"source"."Products__CATEGORY" ASC