Thank you again for such a wonderful initiative as Metabase.
I have shown this tool to our business customers, and received numerous requests for the following features:
Custom send condition for Pulses
For example, there is a report on the call center queue size split by topics. Business customers would like to receive a barchart with each queue size if any of them exceeds X calls. Currently, the only option is to use the “Skip if no results” functionality in Pulses, and this way you only see those queues where the queue size exceeds X - not all of them.
Honor Question formatting. Currently almost all question configuration such as selected columns and column formatting is not taken into account when sending a Pulse: all columns are sent, “link”-formatted columns are send as raw text.
Include only a subset of Question columns in a Pulse. This way, Users would be able to see only certain most important metric in a Slack pulse, and click on the Question link to dive deeper if necessary.
From the looks of the image, it looks like you’re using 0.33.0, which supports joins. This should give you the option to create a more advanced query - I know it would be possible with some SQL joggling of sub-queries, but I’m hesitant to say if you can do it with the query browser.
I’m not sure if the alert interface would become too complicated if it separated conditions from contents, but I cannot find a feature request, which matches anything you’re describing, so I would recommend that you create one (be as descriptive as possible) https://github.com/metabase/metabase/issues/new/choose
And please post a link here for reference
with res as (
SELECT "PRODUCTS__via__PRODUCT_ID"."CATEGORY" AS "CATEGORY", count(*) AS "count"
LEFT JOIN "PUBLIC"."PRODUCTS" "PRODUCTS__via__PRODUCT_ID" ON "PUBLIC"."ORDERS"."PRODUCT_ID" = "PRODUCTS__via__PRODUCT_ID"."ID"
WHERE CAST("PUBLIC"."ORDERS"."CREATED_AT" AS date) BETWEEN CAST(dateadd('day', -30, now()) AS date)
AND CAST(dateadd('day', -1, now()) AS date)
GROUP BY "PRODUCTS__via__PRODUCT_ID"."CATEGORY"
SELECT "CATEGORY", "count"
where exists (
where "count" >= 160
ORDER BY "CATEGORY" ASC
Anyway, I will post the feature request and we will see how it works out.