You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/02/14 13:17:16 UTC
[GitHub] [superset] alvinlabiano opened a new issue #13115: 2 TIme Column Filter for Superset Apache
alvinlabiano opened a new issue #13115:
URL: https://github.com/apache/superset/issues/13115
Is there are way to create a widget with Superset Apache where the SQL Query is based on 2 time columns?
Example Query:
"SELECT
title
,pipeline_id
,alc_production_status
,campaign_start_date
,campaign_end_date
,website_name
,performance_status_name
,sum(spend) AS spend
FROM superset_native_dashboard.v_content_list_with_facebook_ads_v1
WHERE ((campaign_start_date BETWEEN date '2020-12-27' AND date '2020-12-28') OR
(campaign_end_date BETWEEN date '2020-12-27' AND date '2020-12-28'))
GROUP BY
title
,pipeline_id
,alc_production_status
,campaign_start_date
,campaign_end_date
,website_name
,performance_status_name
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] amitmiran137 commented on issue #13115: 2 TIme Column Filter for Superset Apache
Posted by GitBox <gi...@apache.org>.
amitmiran137 commented on issue #13115:
URL: https://github.com/apache/superset/issues/13115#issuecomment-1001021145
You can just write custom SQL query that wraps that logic of a single time range bring pass to different where clause parts
And saved it as a virtual dataset
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] amitmiran137 closed issue #13115: 2 TIme Column Filter for Superset Apache
Posted by GitBox <gi...@apache.org>.
amitmiran137 closed issue #13115:
URL: https://github.com/apache/superset/issues/13115
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org