![]() (the second question can't be linked to the filter. Then add an ID filter to the dashboard and try to link the filter to the cards. (the only difference is that the second question has an extra filter at the end) To reproduceĬreate two custom questions as presented below: When creating a Custom question and doing another filter or aggregation on returned data (generating a sub-select or aggregate), then dashboard filters cannot be connected to the card. I can formulate the issue as follows: Background I have a similar issue when trying to link filters to Custom questions. ⬇️ Please click the □ reaction instead of leaving a +1 or update? comment See forum thread for real database queries: ![]() Information about your Metabase Installation: ORDER BY CAST("PUBLIC"."ORDERS"."CREATED_AT" AS date) ASC, "PUBLIC"."ORDERS"."PRODUCT_ID" ASC, "PRODUCTS_via_PRODUCT_ID"."CATEGORY" ASC) "source" WHERE "source"."sum" > 100 GROUP BY CAST("PUBLIC"."ORDERS"."CREATED_AT" AS date), "PUBLIC"."ORDERS"."PRODUCT_ID", "PRODUCTS_via_PRODUCT_ID"."CATEGORY" LEFT JOIN "PUBLIC"."PRODUCTS" "PRODUCTS_via_PRODUCT_ID" ON "PUBLIC"."ORDERS"."PRODUCT_ID" = "PRODUCTS_via_PRODUCT_ID"."ID" SELECT "source"."CREATED_AT" AS "CREATED_AT", "source"."PRODUCT_ID" AS "PRODUCT_ID", "source"."CATEGORY" AS "CATEGORY", "source"."sum" AS "sum"įROM (SELECT CAST("PUBLIC"."ORDERS"."CREATED_AT" AS date) AS "CREATED_AT", "PUBLIC"."ORDERS"."PRODUCT_ID" AS "PRODUCT_ID", "PRODUCTS_via_PRODUCT_ID"."CATEGORY" AS "CATEGORY", sum("PUBLIC"."ORDERS"."TOTAL") AS "sum" FROM "PUBLIC"."ORDERS" Add filters Time: All options and ID and Other Categories and try to connect to question.Aggregation filter sum is greater than 100.Filter User ID = 1, Summarize Sum of Total grouped by Created At: Day and Product ID and Product -> Category.Create Custom question from Sample Data > Orders. ![]() That will make the dashboard filters show correctly. Include another question with the same columns, which isn't aggregated, and also connect the filters to that question. When creating a Custom question and doing filter aggregation on returned data (generating a sub-select), then dashboard filters cannot be connected to card.
0 Comments
Leave a Reply. |