I have one question where i would need to enter the dates in the dashboard and update question 1 and this would affect the results i have in question 2. So when I select the date between the 1 of June and the 10 of June for question 1 it would get all the data between these dates and would update question 2 that would count the rows after the date change.
Hi @louisc
You would need to connect the dashboard filter to both questions:
https://www.metabase.com/docs/latest/users-guide/08-dashboard-filters.html
hello, my dashboard filter(date range) needs to only be connected to the question 1 and with the results of that question my question 2 can be updated.
ok thanks and can i put the two questions together and in the middle have the input of a date range and then it will run other actions?
not even in sql?
@louisc I don't understand what you are trying to do. If you need to do more complex queries, then you can use SQL: https://www.metabase.com/docs/latest/users-guide/writing-sql.html
i have a question where in the middle of different filters i have to input dates from the dashboard and once there dates have been inputed i need to continue the commands such as a maximum. I can only do the maximum with the results filtered by the data range filter.
@louisc Okay, I still don't know what you are trying to do, so post your SQL or screenshot of your GUI question notebook, so it's possible to understand your structure.
Try using the Sample Database to describe your problem with.
And post "Diagnostic Info" from Admin > Troubleshooting.
ok i have done a screen shot but dont know where to find the admin
Here i want input the date at the top and it will modify the question "test des orders" and then it will modify "test status avec date" but the date range is only connected to "test des orders".
@louisc You need to connect the dashboard filter to both questions. Edit the dashboard, click the dashboard filter in the top and then connect it to both questions.
@louisc Go to the question "test status avec date" - I need to either see the SQL or Notebook editor.
thats the sql
SELECT count(*) AS "count"
FROM (SELECT "source"."Orders Orderstatus - Orders Orderamount → Order__order_id" AS "Orders Orderstatus - Orders Orderamount → Order__order_id", max("source"."Orders Orderstatus - Orders Orderamount → Order__id") AS "max" FROM (SELECT "source"."order_id" AS "order_id", "source"."max" AS "max", "source"."Orders Orderamount__id" AS "Orders Orderamount__id", "source"."Orders Orderamount__created_at" AS "Orders Orderamount__created_at", "source"."Orders Orderamount__updated_at" AS "Orders Orderamount__updated_at", "source"."Orders Orderamount__is_active" AS "Orders Orderamount__is_active", "source"."Orders Orderamount__stage" AS "Orders Orderamount__stage", "source"."Orders Orderamount__amount_subtotal_items_kept" AS "Orders Orderamount__amount_subtotal_items_kept", "source"."Orders Orderamount__amount_subtotal_items_returned" AS "Orders Orderamount__amount_subtotal_items_returned", "source"."Orders Orderamount__amount_delivery_shipping_fee" AS "Orders Orderamount__amount_delivery_shipping_fee", "source"."Orders Orderamount__amount_subtotal_items_discount" AS "Orders Orderamount__amount_subtotal_items_discount", "source"."Orders Orderamount__amount_return_shipping_fee" AS "Orders Orderamount__amount_return_shipping_fee", "source"."Orders Orderamount__amount_other" AS "Orders Orderamount__amount_other", "source"."Orders Orderamount__amount_total_cart" AS "Orders Orderamount__amount_total_cart", "source"."Orders Orderamount__order_id" AS "Orders Orderamount__order_id", "source"."Orders Orderamount__tenant_id" AS "Orders Orderamount__tenant_id", "source"."Orders Orderamount__amount_captured" AS "Orders Orderamount__amount_captured", "source"."Orders Orderamount__amount_payment_incident" AS "Orders Orderamount__amount_payment_incident", "source"."Orders Orderamount__return_type" AS "Orders Orderamount__return_type", "source"."Orders Orderamount__amount_previously_captured" AS "Orders Orderamount__amount_previously_captured", "source"."Orders Orderamount__amount_to_charge" AS "Orders Orderamount__amount_to_charge", "source"."Orders Orderamount__amount_delivery_shipping_fee_discount" AS "Orders Orderamount__amount_delivery_shipping_fee_discount", "source"."Orders Orderamount__amount_delivery_shipping_fee_ne_8a4977fc" AS "Orders Orderamount__amount_delivery_shipping_fee_ne_8a4977fc", "source"."Orders Orderamount__amount_subtotal_items_kept_net__1f6119c7" AS "Orders Orderamount__amount_subtotal_items_kept_net__1f6119c7", "source"."Orders Orderamount__authentication_alarm_limit_date" AS "Orders Orderamount__authentication_alarm_limit_date", "source"."Orders Orderamount__is_authentication_done" AS "Orders Orderamount__is_authentication_done", "source"."Orders Orderamount__number_items_kept" AS "Orders Orderamount__number_items_kept", "source"."Orders Orderamount__number_items_returned" AS "Orders Orderamount__number_items_returned", "source"."Orders Orderamount__amount_elyn_revenue_captured" AS "Orders Orderamount__amount_elyn_revenue_captured", "source"."Orders Orderamount__is_order_amount_in_payment_recovery" AS "Orders Orderamount__is_order_amount_in_payment_recovery", "source"."Orders Orderamount__amount_elyn_fee_to_charge" AS "Orders Orderamount__amount_elyn_fee_to_charge", "source"."Orders Orderamount__is_payout_to_merchant_done" AS "Orders Orderamount__is_payout_to_merchant_done", "source"."Orders Orderamount__pas_processing_date" AS "Orders Orderamount__pas_processing_date", "source"."Orders Orderamount__amount_tip" AS "Orders Orderamount__amount_tip", "Orders Order - Orders Orderamount → Order"."id" AS "Orders Order - Orders Orderamount → Order__id", "Orders Order - Orders Orderamount → Order"."created_at" AS "Orders Order - Orders Orderamount → Order__created_at", "Orders Order - Orders Orderamount → Order"."updated_at" AS "Orders Order - Orders Orderamount → Order__updated_at", "Orders Order - Orders Orderamount → Order"."is_active" AS "Orders Order - Orders Orderamount → Order__is_active", "Orders Order - Orders Orderamount → Order"."merchant_order_id" AS "Orders Order - Orders Orderamount → Order__mercha_2d915289", "Orders Order - Orders Orderamount → Order"."return_interface_url" AS "Orders Order - Orders Orderamount → Order__return_e591d87c", "Orders Order - Orders Orderamount → Order"."order_date" AS "Orders Order - Orders Orderamount → Order__order_date", "Orders Order - Orders Orderamount → Order"."is_blacklist" AS "Orders Order - Orders Orderamount → Order__is_blacklist", "Orders Order - Orders Orderamount → Order"."merchant_checkout_id" AS "Orders Order - Orders Orderamount → Order__mercha_6f971498", "Orders Order - Orders Orderamount → Order"."displayed_order_id" AS "Orders Order - Orders Orderamount → Order__displa_17b258ca", "Orders Order - Orders Orderamount → Order"."delivery_tracking_company" AS "Orders Order - Orders Orderamount → Order__delive_1a533fb9", "Orders Order - Orders Orderamount → Order"."delivery_tracking_numbers" AS "Orders Order - Orders Orderamount → Order__delive_2272fc0f", "Orders Order - Orders Orderamount → Order"."delivery_tracking_urls" AS "Orders Order - Orders Orderamount → Order__delive_8a00b226", "Orders Order - Orders Orderamount → Order"."delivery_alarm_limit_date" AS "Orders Order - Orders Orderamount → Order__delive_f477fe8", "Orders Order - Orders Orderamount → Order"."delivery_date" AS "Orders Order - Orders Orderamount → Order__delivery_date", "Orders Order - Orders Orderamount → Order"."trial_start_date" AS "Orders Order - Orders Orderamount → Order__trial__d5882a9a", "Orders Order - Orders Orderamount → Order"."trial_limit_end_date" AS "Orders Order - Orders Orderamount → Order__trial__d12f536f", "Orders Order - Orders Orderamount → Order"."trial_is_selection_final" AS "Orders Order - Orders Orderamount → Order__trial__16123475", "Orders Order - Orders Orderamount → Order"."trial_effective_end_date" AS "Orders Order - Orders Orderamount → Order__trial__1ed68088", "Orders Order - Orders Orderamount → Order"."trial_is_payment_incident" AS "Orders Order - Orders Orderamount → Order__trial__ef2e7281", "Orders Order - Orders Orderamount → Order"."dropoff_effective_end_date" AS "Orders Order - Orders Orderamount → Order__dropof_74175353", "Orders Order - Orders Orderamount → Order"."dropoff_limit_end_date" AS "Orders Order - Orders Orderamount → Order__dropof_d0f512fd", "Orders Order - Orders Orderamount → Order"."return_tracking_company" AS "Orders Order - Orders Orderamount → Order__return_d4ad2d20", "Orders Order - Orders Orderamount → Order"."return_tracking_numbers" AS "Orders Order - Orders Orderamount → Order__return_ec8cee96", "Orders Order - Orders Orderamount → Order"."return_tracking_urls" AS "Orders Order - Orders Orderamount → Order__return_195b9c0", "Orders Order - Orders Orderamount → Order"."return_alarm_limit_date" AS "Orders Order - Orders Orderamount → Order__return_c1b96d71", "Orders Order - Orders Orderamount → Order"."return_control_date" AS "Orders Order - Orders Orderamount → Order__return_aad469c6", "Orders Order - Orders Orderamount → Order"."return_is_control_result_confirmed" AS "Orders Order - Orders Orderamount → Order__return_b2b11ee4", "Orders Order - Orders Orderamount → Order"."dropoff_is_payment_incident" AS "Orders Order - Orders Orderamount → Order__dropof_fe45b80e", "Orders Order - Orders Orderamount → Order"."is_customer_total_refund" AS "Orders Order - Orders Orderamount → Order__is_cus_ccc60763", "Orders Order - Orders Orderamount → Order"."amount_total_captured" AS "Orders Order - Orders Orderamount → Order__amount_a34274c4", "Orders Order - Orders Orderamount → Order"."amount_total_elyn_recovered" AS "Orders Order - Orders Orderamount → Order__amount_a8e4c14c", "Orders Order - Orders Orderamount → Order"."stripe_customer_id" AS "Orders Order - Orders Orderamount → Order__stripe_7e91443e", "Orders Order - Orders Orderamount → Order"."is_initial_authorization_page_active" AS "Orders Order - Orders Orderamount → Order__is_ini_806ba006", "Orders Order - Orders Orderamount → Order"."payment_incident_status" AS "Orders Order - Orders Orderamount → Order__paymen_e999becf", "Orders Order - Orders Orderamount → Order"."customer_id" AS "Orders Order - Orders Orderamount → Order__customer_id", "Orders Order - Orders Orderamount → Order"."customer_info_id" AS "Orders Order - Orders Orderamount → Order__custom_9cb5d93d", "Orders Order - Orders Orderamount → Order"."tenant_id" AS "Orders Order - Orders Orderamount → Order__tenant_id", "Orders Order - Orders Orderamount → Order"."return_is_payment_incident" AS "Orders Order - Orders Orderamount → Order__return_6d924276", "Orders Order - Orders Orderamount → Order"."is_payment_incident_fee_enabled" AS "Orders Order - Orders Orderamount → Order__is_pay_f634b219", "Orders Order - Orders Orderamount → Order"."delivery_tracking_transporter_numbers" AS "Orders Order - Orders Orderamount → Order__delive_c9cebc17", "Orders Order - Orders Orderamount → Order"."delivery_tracking_transporter_urls" AS "Orders Order - Orders Orderamount → Order__delive_c75e8796", "Orders Order - Orders Orderamount → Order"."delivery_tracking_transporter_company" AS "Orders Order - Orders Orderamount → Order__delive_f1ef7fa1", "Orders Order - Orders Orderamount → Order"."return_tracking_transporter_company" AS "Orders Order - Orders Orderamount → Order__return_8883ded6", "Orders Order - Orders Orderamount → Order"."return_tracking_transporter_numbers" AS "Orders Order - Orders Orderamount → Order__return_b0a21d60", "Orders Order - Orders Orderamount → Order"."return_tracking_transporter_urls" AS "Orders Order - Orders Orderamount → Order__return_80557be5", "Orders Order - Orders Orderamount → Order"."dropoff_start_date" AS "Orders Order - Orders Orderamount → Order__dropof_aac0d05f", "Orders Order - Orders Orderamount → Order"."order_current_status" AS "Orders Order - Orders Orderamount → Order__order__e9f2416d", "Orders Order - Orders Orderamount → Order"."authorization_limit_date" AS "Orders Order - Orders Orderamount → Order__author_82fe3c12", "Orders Order - Orders Orderamount → Order"."authorization_email_wait_limit_date" AS "Orders Order - Orders Orderamount → Order__author_508bb8df", "Orders Order - Orders Orderamount → Order"."merchant_confirmation_url" AS "Orders Order - Orders Orderamount → Order__mercha_f7102b", "Orders Order - Orders Orderamount → Order"."return_delivery_date" AS "Orders Order - Orders Orderamount → Order__return_22ce344", "Orders Order - Orders Orderamount → Order"."payment_gateway_names" AS "Orders Order - Orders Orderamount → Order__paymen_351c3782", "Orders Order - Orders Orderamount → Order"."return_colissimo_pdf_generation_date" AS "Orders Order - Orders Orderamount → Order__return_99b5d680", "Orders Order - Orders Orderamount → Order"."is_initial_order_loaded_correctly" AS "Orders Order - Orders Orderamount → Order__is_ini_c8f43c9e", "Orders Order - Orders Orderamount → Order"."return_label_pdf_url" AS "Orders Order - Orders Orderamount → Order__return_a9e5f631", "Orders Order - Orders Orderamount → Order"."initial_authorization_url" AS "Orders Order - Orders Orderamount → Order__initia_9c28e549", "Orders Order - Orders Orderamount → Order"."amount_total_customer_refund" AS "Orders Order - Orders Orderamount → Order__amount_95ef1b69", "Orders Order - Orders Orderamount → Order"."amount_total_payment_incident" AS "Orders Order - Orders Orderamount → Order__amount_300884f9", "Orders Order - Orders Orderamount → Order"."trial_email_reminder_limit_end_date" AS "Orders Order - Orders Orderamount → Order__trial__2fc019db", "Orders Order - Orders Orderamount → Order"."trial_sms_reminder_limit_end_date" AS "Orders Order - Orders Orderamount → Order__trial__f96e62c3", "Orders Order - Orders Orderamount → Order"."dropoff_email_reminder_limit_end_date" AS "Orders Order - Orders Orderamount → Order__dropof_590fe916", "Orders Order - Orders Orderamount → Order"."dropoff_sms_reminder_limit_end_date" AS "Orders Order - Orders Orderamount → Order__dropof_24ab74db", "Orders Order - Orders Orderamount → Order"."delivery_is_tracking_details_created" AS "Orders Order - Orders Orderamount → Order__delive_af610562", "Orders Order - Orders Orderamount → Order"."return_is_tracking_details_created" AS "Orders Order - Orders Orderamount → Order__return_1f78d66b", "Orders Order - Orders Orderamount → Order"."delivery_tracking_details_alarm_limit_date" AS "Orders Order - Orders Orderamount → Order__delive_ce8c38c2", "Orders Order - Orders Orderamount → Order"."return_tracking_details_alarm_limit_date" AS "Orders Order - Orders Orderamount → Order__return_cf998a86", "Orders Order - Orders Orderamount → Order"."return_control_alarm_limit_date" AS "Orders Order - Orders Orderamount → Order__return_f7ddbd08", "Orders Order - Orders Orderamount → Order"."delivery_initial_error_alarm_limit_date" AS "Orders Order - Orders Orderamount → Order__delive_75ffbe3c", "Orders Order - Orders Orderamount → Order"."amount_total_computed_equal_total_pulled_from_cms" AS "Orders Order - Orders Orderamount → Order__amount_1a3bcef7", "Orders Order - Orders Orderamount → Order"."initial_amount_total_pulled_from_cms" AS "Orders Order - Orders Orderamount → Order__initia_f05ed419", "Orders Order - Orders Orderamount → Order"."token" AS "Orders Order - Orders Orderamount → Order__token", "Orders Order - Orders Orderamount → Order"."is_initial_authorization_page_celery_tasks_scheduled" AS "Orders Order - Orders Orderamount → Order__is_ini_283ef889", "Orders Order - Orders Orderamount → Order"."return_initial_error_alarm_limit_date" AS "Orders Order - Orders Orderamount → Order__return_b450bb1f", "Orders Order - Orders Orderamount → Order"."is_order_using_elyn" AS "Orders Order - Orders Orderamount → Order__is_ord_2e93a21d", "Orders Order - Orders Orderamount → Order"."is_order_eligible" AS "Orders Order - Orders Orderamount → Order__is_ord_4c716607", "Orders Order - Orders Orderamount → Order"."amount_total_elyn_revenue" AS "Orders Order - Orders Orderamount → Order__amount_b4e6f1d5", "Orders Order - Orders Orderamount → Order"."is_order_authorized" AS "Orders Order - Orders Orderamount → Order__is_ord_767f5624", "Orders Order - Orders Orderamount → Order"."delivery_is_still_initial_error" AS "Orders Order - Orders Orderamount → Order__delive_fb61a930", "Orders Order - Orders Orderamount → Order"."return_is_still_initial_error" AS "Orders Order - Orders Orderamount → Order__return_26a0f087", "Orders Order - Orders Orderamount → Order"."trial_is_period_expired_without_customer_action" AS "Orders Order - Orders Orderamount → Order__trial__aa072c24", "Orders Order - Orders Orderamount → Order"."elyn_commission_fee" AS "Orders Order - Orders Orderamount → Order__elyn_c_925226db", "Orders Order - Orders Orderamount → Order"."has_charge_failed_before" AS "Orders Order - Orders Orderamount → Order__has_ch_7e137c09", "Orders Order - Orders Orderamount → Order"."is_old_payment_system" AS "Orders Order - Orders Orderamount → Order__is_old_5ec9c311", "Orders Order - Orders Orderamount → Order"."is_refund_fee_enabled" AS "Orders Order - Orders Orderamount → Order__is_ref_a8f83c26", "Orders Order - Orders Orderamount → Order"."is_fulfillment_held" AS "Orders Order - Orders Orderamount → Order__is_ful_6df70f2d", "Orders Order - Orders Orderamount → Order"."date_of_first_payment_incident" AS "Orders Order - Orders Orderamount → Order__date_o_712e39b", "Orders Order - Orders Orderamount → Order"."authorization_sms_wait_limit_date" AS "Orders Order - Orders Orderamount → Order__author_81c82d9c", "Tenants Tenant - Tenant"."id" AS "Tenants Tenant - Tenant__id", "Tenants Tenant - Tenant"."created_at" AS "Tenants Tenant - Tenant__created_at", "Tenants Tenant - Tenant"."updated_at" AS "Tenants Tenant - Tenant__updated_at", "Tenants Tenant - Tenant"."is_active" AS "Tenants Tenant - Tenant__is_active", "Tenants Tenant - Tenant"."merchant_name" AS "Tenants Tenant - Tenant__merchant_name", "Tenants Tenant - Tenant"."contact_email" AS "Tenants Tenant - Tenant__contact_email", "Tenants Tenant - Tenant"."contact_phone_number" AS "Tenants Tenant - Tenant__contact_phone_number", "Tenants Tenant - Tenant"."siren_number" AS "Tenants Tenant - Tenant__siren_number", "Tenants Tenant - Tenant"."joining_date" AS "Tenants Tenant - Tenant__joining_date", "Tenants Tenant - Tenant"."sector" AS "Tenants Tenant - Tenant__sector", "Tenants Tenant - Tenant"."return_address_0_etage_couloir_escalier_appart" AS "Tenants Tenant - Tenant__return_address_0_etage_cou_b4a84551", "Tenants Tenant - Tenant"."cms_shop_url" AS "Tenants Tenant - Tenant__cms_shop_url", "Tenants Tenant - Tenant"."cms_api_password" AS "Tenants Tenant - Tenant__cms_api_password", "Tenants Tenant - Tenant"."cms_webhook_security_key" AS "Tenants Tenant - Tenant__cms_webhook_security_key", "Tenants Tenant - Tenant"."stripe_merchant_id" AS "Tenants Tenant - Tenant__stripe_merchant_id", "Tenants Tenant - Tenant"."stripe_kyc_url" AS "Tenants Tenant - Tenant__stripe_kyc_url", "Tenants Tenant - Tenant"."return_province" AS "Tenants Tenant - Tenant__return_province", "Tenants Tenant - Tenant"."colissimo_password" AS "Tenants Tenant - Tenant__colissimo_password", "Tenants Tenant - Tenant"."elyn_commission_fee" AS "Tenants Tenant - Tenant__elyn_commission_fee", "Tenants Tenant - Tenant"."merchant_min_order" AS "Tenants Tenant - Tenant__merchant_min_order", "Tenants Tenant - Tenant"."merchant_max_order" AS "Tenants Tenant - Tenant__merchant_max_order", "Tenants Tenant - Tenant"."return_shipping_fee" AS "Tenants Tenant - Tenant__return_shipping_fee", "Tenants Tenant - Tenant"."shipping_fee" AS "Tenants Tenant - Tenant__shipping_fee", "Tenants Tenant - Tenant"."initial_payment_expiry_wait_minutes" AS "Tenants Tenant - Tenant__initial_payment_expiry_wait_minutes", "Tenants Tenant - Tenant"."trial_length_days" AS "Tenants Tenant - Tenant__trial_length_days", "Tenants Tenant - Tenant"."dropoff_length_working_days" AS "Tenants Tenant - Tenant__dropoff_length_working_days", "Tenants Tenant - Tenant"."initial_authorization_reminder_email_wait_minutes" AS "Tenants Tenant - Tenant__initial_authorization_remi_db3f670e", "Tenants Tenant - Tenant"."return_address_1_entree_batiment_immeuble_residence" AS "Tenants Tenant - Tenant__return_address_1_entree_ba_594beda6", "Tenants Tenant - Tenant"."return_city" AS "Tenants Tenant - Tenant__return_city", "Tenants Tenant - Tenant"."return_country_code" AS "Tenants Tenant - Tenant__return_country_code", "Tenants Tenant - Tenant"."return_zip" AS "Tenants Tenant - Tenant__return_zip", "Tenants Tenant - Tenant"."contact_first_name" AS "Tenants Tenant - Tenant__contact_first_name", "Tenants Tenant - Tenant"."contact_last_name" AS "Tenants Tenant - Tenant__contact_last_name", "Tenants Tenant - Tenant"."is_min_final_cart_enabled" AS "Tenants Tenant - Tenant__is_min_final_cart_enabled", "Tenants Tenant - Tenant"."is_return_shipping_fee_enabled" AS "Tenants Tenant - Tenant__is_return_shipping_fee_enabled", "Tenants Tenant - Tenant"."support_email" AS "Tenants Tenant - Tenant__support_email", "Tenants Tenant - Tenant"."background_url" AS "Tenants Tenant - Tenant__background_url", "Tenants Tenant - Tenant"."colissimo_username" AS "Tenants Tenant - Tenant__colissimo_username", "Tenants Tenant - Tenant"."faq_url" AS "Tenants Tenant - Tenant__faq_url", "Tenants Tenant - Tenant"."logo_email_png_url" AS "Tenants Tenant - Tenant__logo_email_png_url", "Tenants Tenant - Tenant"."return_country" AS "Tenants Tenant - Tenant__return_country", "Tenants Tenant - Tenant"."return_province_code" AS "Tenants Tenant - Tenant__return_province_code", "Tenants Tenant - Tenant"."threshold_final_cart_free_shipping" AS "Tenants Tenant - Tenant__threshold_final_cart_free_shipping", "Tenants Tenant - Tenant"."automatic_email_payment_wait_days" AS "Tenants Tenant - Tenant__automatic_email_payment_wait_days", "Tenants Tenant - Tenant"."trial_email_reminder_before_end_days" AS "Tenants Tenant - Tenant__trial_email_reminder_befor_1c2b83d1", "Tenants Tenant - Tenant"."dropoff_email_reminder_before_end_days" AS "Tenants Tenant - Tenant__dropoff_email_reminder_bef_aa9c69a4", "Tenants Tenant - Tenant"."dropoff_sms_reminder_before_end_days" AS "Tenants Tenant - Tenant__dropoff_sms_reminder_befor_1c20e8bc", "Tenants Tenant - Tenant"."trial_sms_reminder_before_end_days" AS "Tenants Tenant - Tenant__trial_sms_reminder_before_end_days", "Tenants Tenant - Tenant"."return_restock_responsible" AS "Tenants Tenant - Tenant__return_restock_responsible", "Tenants Tenant - Tenant"."logo_web_png_url" AS "Tenants Tenant - Tenant__logo_web_png_url", "Tenants Tenant - Tenant"."return_control_alarm_limit_days" AS "Tenants Tenant - Tenant__return_control_alarm_limit_days", "Tenants Tenant - Tenant"."sendgrid_email_1" AS "Tenants Tenant - Tenant__sendgrid_email_1", "Tenants Tenant - Tenant"."sendgrid_email_10" AS "Tenants Tenant - Tenant__sendgrid_email_10", "Tenants Tenant - Tenant"."sendgrid_email_2" AS "Tenants Tenant - Tenant__sendgrid_email_2", "Tenants Tenant - Tenant"."sendgrid_email_3" AS "Tenants Tenant - Tenant__sendgrid_email_3", "Tenants Tenant - Tenant"."sendgrid_email_4" AS "Tenants Tenant - Tenant__sendgrid_email_4", "Tenants Tenant - Tenant"."sendgrid_email_5" AS "Tenants Tenant - Tenant__sendgrid_email_5", "Tenants Tenant - Tenant"."sendgrid_email_6" AS "Tenants Tenant - Tenant__sendgrid_email_6", "Tenants Tenant - Tenant"."sendgrid_email_7" AS "Tenants Tenant - Tenant__sendgrid_email_7", "Tenants Tenant - Tenant"."sendgrid_email_8" AS "Tenants Tenant - Tenant__sendgrid_email_8", "Tenants Tenant - Tenant"."sendgrid_email_9" AS "Tenants Tenant - Tenant__sendgrid_email_9", "Tenants Tenant - Tenant"."dropoff_email_reminder_before_end_hour" AS "Tenants Tenant - Tenant__dropoff_email_reminder_bef_3166848c", "Tenants Tenant - Tenant"."dropoff_limit_end_hour" AS "Tenants Tenant - Tenant__dropoff_limit_end_hour", "Tenants Tenant - Tenant"."dropoff_sms_reminder_before_end_hour" AS "Tenants Tenant - Tenant__dropoff_sms_reminder_befor_87da0594", "Tenants Tenant - Tenant"."trial_email_reminder_before_end_hour" AS "Tenants Tenant - Tenant__trial_email_reminder_befor_87d16ef9", "Tenants Tenant - Tenant"."trial_limit_end_hour" AS "Tenants Tenant - Tenant__trial_limit_end_hour", "Tenants Tenant - Tenant"."trial_sms_reminder_before_end_hour" AS "Tenants Tenant - Tenant__trial_sms_reminder_before_end_hour", "Tenants Tenant - Tenant"."sendgrid_email_11" AS "Tenants Tenant - Tenant__sendgrid_email_11", "Tenants Tenant - Tenant"."gateway_name" AS "Tenants Tenant - Tenant__gateway_name", "Tenants Tenant - Tenant"."notification_email" AS "Tenants Tenant - Tenant__notification_email", "Tenants Tenant - Tenant"."sendgrid_email_12" AS "Tenants Tenant - Tenant__sendgrid_email_12", "Tenants Tenant - Tenant"."shop_official_url" AS "Tenants Tenant - Tenant__shop_official_url", "Tenants Tenant - Tenant"."email_10_disabled" AS "Tenants Tenant - Tenant__email_10_disabled", "Tenants Tenant - Tenant"."email_11_disabled" AS "Tenants Tenant - Tenant__email_11_disabled", "Tenants Tenant - Tenant"."email_12_disabled" AS "Tenants Tenant - Tenant__email_12_disabled", "Tenants Tenant - Tenant"."email_1_disabled" AS "Tenants Tenant - Tenant__email_1_disabled", "Tenants Tenant - Tenant"."email_2_disabled" AS "Tenants Tenant - Tenant__email_2_disabled", "Tenants Tenant - Tenant"."email_3_disabled" AS "Tenants Tenant - Tenant__email_3_disabled", "Tenants Tenant - Tenant"."email_4_disabled" AS "Tenants Tenant - Tenant__email_4_disabled", "Tenants Tenant - Tenant"."email_5_disabled" AS "Tenants Tenant - Tenant__email_5_disabled", "Tenants Tenant - Tenant"."email_6_disabled" AS "Tenants Tenant - Tenant__email_6_disabled", "Tenants Tenant - Tenant"."email_7_disabled" AS "Tenants Tenant - Tenant__email_7_disabled", "Tenants Tenant - Tenant"."email_8_disabled" AS "Tenants Tenant - Tenant__email_8_disabled", "Tenants Tenant - Tenant"."email_9_disabled" AS "Tenants Tenant - Tenant__email_9_disabled", "Tenants Tenant - Tenant"."email_13_disabled" AS "Tenants Tenant - Tenant__email_13_disabled", "Tenants Tenant - Tenant"."sendgrid_email_13" AS "Tenants Tenant - Tenant__sendgrid_email_13", "Tenants Tenant - Tenant"."merchant_name_to_appear_on_email" AS "Tenants Tenant - Tenant__merchant_name_to_appear_on_email", "Tenants Tenant - Tenant"."return_address_2_numero_et_libelle_voie" AS "Tenants Tenant - Tenant__return_address_2_numero_et_c4233b8a", "Tenants Tenant - Tenant"."return_address_3_lieu_dit_ou_autre_mention" AS "Tenants Tenant - Tenant__return_address_3_lieu_dit__7c69918c", "Tenants Tenant - Tenant"."default_location_id" AS "Tenants Tenant - Tenant__default_location_id", "Tenants Tenant - Tenant"."email_14_disabled" AS "Tenants Tenant - Tenant__email_14_disabled", "Tenants Tenant - Tenant"."sendgrid_email_14" AS "Tenants Tenant - Tenant__sendgrid_email_14", "Tenants Tenant - Tenant"."return_address_name_of_recipient" AS "Tenants Tenant - Tenant__return_address_name_of_recipient", "Tenants Tenant - Tenant"."delete_order_if_cancelled_at_checkout" AS "Tenants Tenant - Tenant__delete_order_if_cancelled__7c085852", "Tenants Tenant - Tenant"."sms_dropoff_reminder_disabled" AS "Tenants Tenant - Tenant__sms_dropoff_reminder_disabled", "Tenants Tenant - Tenant"."sms_trial_reminder_disabled" AS "Tenants Tenant - Tenant__sms_trial_reminder_disabled", "Tenants Tenant - Tenant"."return_label_generator" AS "Tenants Tenant - Tenant__return_label_generator", "Tenants Tenant - Tenant"."myflyingbox_api_id" AS "Tenants Tenant - Tenant__myflyingbox_api_id", "Tenants Tenant - Tenant"."myflyingbox_api_password" AS "Tenants Tenant - Tenant__myflyingbox_api_password", "Tenants Tenant - Tenant"."non_eligibility_tag" AS "Tenants Tenant - Tenant__non_eligibility_tag", "Tenants Tenant - Tenant"."elyn_order_tag" AS "Tenants Tenant - Tenant__elyn_order_tag", "Tenants Tenant - Tenant"."mark_orders_with_elyn_order_tag" AS "Tenants Tenant - Tenant__mark_orders_with_elyn_order_tag", "Tenants Tenant - Tenant"."non_elyn_return_interface_url" AS "Tenants Tenant - Tenant__non_elyn_return_interface_url", "Tenants Tenant - Tenant"."myflyingbox_transporter" AS "Tenants Tenant - Tenant__myflyingbox_transporter", "Tenants Tenant - Tenant"."is_elyn_application_fee_refund_enabled" AS "Tenants Tenant - Tenant__is_elyn_application_fee_re_d56d84dc", "Tenants Tenant - Tenant"."transfer_delay_in_calendar_days" AS "Tenants Tenant - Tenant__transfer_delay_in_calendar_days", "Tenants Tenant - Tenant"."PAS_processing_dropoff_grace_period_in_calendar_days" AS "Tenants Tenant - Tenant__PAS_processing_dropoff_gra_2018e764", "Tenants Tenant - Tenant"."PAS_processing_trial_grace_period_in_calendar_days" AS "Tenants Tenant - Tenant__PAS_processing_trial_grace_8e29e058", "Tenants Tenant - Tenant"."is_light_payment_page_enabled" AS "Tenants Tenant - Tenant__is_light_payment_page_enabled", "Tenants Tenant - Tenant"."is_merchant_risky" AS "Tenants Tenant - Tenant__is_merchant_risky", "Tenants Tenant - Tenant"."sympl_api_key" AS "Tenants Tenant - Tenant__sympl_api_key", "Tenants Tenant - Tenant"."initial_authorization_reminder_sms_wait_minutes" AS "Tenants Tenant - Tenant__initial_authorization_remi_c395b329", "Tenants Tenant - Tenant"."sms_authorization_reminder_disabled" AS "Tenants Tenant - Tenant__sms_authorization_reminder_disabled", "Tenants Tenant - Tenant"."fois_percentage_of_merchant_max_order" AS "Tenants Tenant - Tenant__fois_percentage_of_merchan_7e193c58", "Tenants Tenant - Tenant"."cancellation_restock_responsible" AS "Tenants Tenant - Tenant__cancellation_restock_responsible", "Orders Orderstatus - Orders Orderamount → Order"."id" AS "Orders Orderstatus - Orders Orderamount → Order__id", "Orders Orderstatus - Orders Orderamount → Order"."created_at" AS "Orders Orderstatus - Orders Orderamount → Order___ac5bdf10", "Orders Orderstatus - Orders Orderamount → Order"."updated_at" AS "Orders Orderstatus - Orders Orderamount → Order___64b706a7", "Orders Orderstatus - Orders Orderamount → Order"."is_active" AS "Orders Orderstatus - Orders Orderamount → Order__is_active", "Orders Orderstatus - Orders Orderamount → Order"."status" AS "Orders Orderstatus - Orders Orderamount → Order__status", "Orders Orderstatus - Orders Orderamount → Order"."order_id" AS "Orders Orderstatus - Orders Orderamount → Order__order_id", "Orders Orderstatus - Orders Orderamount → Order"."tenant_id" AS "Orders Orderstatus - Orders Orderamount → Order__tenant_id" FROM (SELECT "source"."order_id" AS "order_id", "source"."max" AS "max", "Orders Orderamount"."id" AS "Orders Orderamount__id", "Orders Orderamount"."created_at" AS "Orders Orderamount__created_at", "Orders Orderamount"."updated_at" AS "Orders Orderamount__updated_at", "Orders Orderamount"."is_active" AS "Orders Orderamount__is_active", "Orders Orderamount"."stage" AS "Orders Orderamount__stage", "Orders Orderamount"."amount_subtotal_items_kept" AS "Orders Orderamount__amount_subtotal_items_kept", "Orders Orderamount"."amount_subtotal_items_returned" AS "Orders Orderamount__amount_subtotal_items_returned", "Orders Orderamount"."amount_delivery_shipping_fee" AS "Orders Orderamount__amount_delivery_shipping_fee", "Orders Orderamount"."amount_subtotal_items_discount" AS "Orders Orderamount__amount_subtotal_items_discount", "Orders Orderamount"."amount_return_shipping_fee" AS "Orders Orderamount__amount_return_shipping_fee", "Orders Orderamount"."amount_other" AS "Orders Orderamount__amount_other", "Orders Orderamount"."amount_total_cart" AS "Orders Orderamount__amount_total_cart", "Orders Orderamount"."order_id" AS "Orders Orderamount__order_id", "Orders Orderamount"."tenant_id" AS "Orders Orderamount__tenant_id", "Orders Orderamount"."amount_captured" AS "Orders Orderamount__amount_captured", "Orders Orderamount"."amount_payment_incident" AS "Orders Orderamount__amount_payment_incident", "Orders Orderamount"."return_type" AS "Orders Orderamount__return_type", "Orders Orderamount"."amount_previously_captured" AS "Orders Orderamount__amount_previously_captured", "Orders Orderamount"."amount_to_charge" AS "Orders Orderamount__amount_to_charge", "Orders Orderamount"."amount_delivery_shipping_fee_discount" AS "Orders Orderamount__amount_delivery_shipping_fee_discount", "Orders Orderamount"."amount_delivery_shipping_fee_net_of_discount" AS "Orders Orderamount__amount_delivery_shipping_fee_ne_8a4977fc", "Orders Orderamount"."amount_subtotal_items_kept_net_of_discount" AS "Orders Orderamount__amount_subtotal_items_kept_net__1f6119c7", "Orders Orderamount"."authentication_alarm_limit_date" AS "Orders Orderamount__authentication_alarm_limit_date", "Orders Orderamount"."is_authentication_done" AS "Orders Orderamount__is_authentication_done", "Orders Orderamount"."number_items_kept" AS "Orders Orderamount__number_items_kept", "Orders Orderamount"."number_items_returned" AS "Orders Orderamount__number_items_returned", "Orders Orderamount"."amount_elyn_revenue_captured" AS "Orders Orderamount__amount_elyn_revenue_captured", "Orders Orderamount"."is_order_amount_in_payment_recovery" AS "Orders Orderamount__is_order_amount_in_payment_recovery", "Orders Orderamount"."amount_elyn_fee_to_charge" AS "Orders Orderamount__amount_elyn_fee_to_charge", "Orders Orderamount"."is_payout_to_merchant_done" AS "Orders Orderamount__is_payout_to_merchant_done", "Orders Orderamount"."pas_processing_date" AS "Orders Orderamount__pas_processing_date", "Orders Orderamount"."amount_tip" AS "Orders Orderamount__amount_tip" FROM (SELECT "public"."orders_orderamount"."order_id" AS "order_id", max("public"."orders_orderamount"."id") AS "max" FROM "public"."orders_orderamount"
GROUP BY "public"."orders_orderamount"."order_id"
ORDER BY "public"."orders_orderamount"."order_id" ASC) "source"
LEFT JOIN "public"."orders_orderamount" "Orders Orderamount" ON "source"."max" = "Orders Orderamount"."id") "source" LEFT JOIN "public"."orders_order" "Orders Order - Orders Orderamount → Order" ON "source"."order_id" = "Orders Order - Orders Orderamount → Order"."id" LEFT JOIN "public"."tenants_tenant" "Tenants Tenant - Tenant" ON "Orders Order - Orders Orderamount → Order"."tenant_id" = "Tenants Tenant - Tenant"."id" LEFT JOIN "public"."orders_orderstatus" "Orders Orderstatus - Orders Orderamount → Order" ON "source"."order_id" = "Orders Orderstatus - Orders Orderamount → Order"."order_id"
WHERE ("Orders Order - Orders Orderamount → Order"."is_order_using_elyn" = TRUE
AND "Orders Order - Orders Orderamount → Order"."is_order_authorized" = TRUE)) "source" WHERE ("source"."Orders Orderstatus - Orders Orderamount → Order__status" = 'in_trial'
OR "source"."Orders Orderstatus - Orders Orderamount → Order__status" = 'pending_dropoff' OR "source"."Orders Orderstatus - Orders Orderamount → Order__status" = 'dropoff_pending_charge_attempt' OR "source"."Orders Orderstatus - Orders Orderamount → Order__status" = 'trial_pending_charge_attempt') GROUP BY "source"."Orders Orderstatus - Orders Orderamount → Order__order_id" ORDER BY "source"."Orders Orderstatus - Orders Orderamount → Order__order_id" ASC) "source"
@louisc So you are doing a double-aggregation. You would need to do it in SQL with a variable for the date.
Hi Flamber, it's Louis, I'm using a coworker account as I reached the limit of messages I can send as a new user on my first day. Doing a double aggregation with SQL is exactly what we've done
It's working well, the only question we have is: how can we have the date range filter directly on the dashboard page (the date ranges are only at the query page level).
Thank you very much!