You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "filpano (via GitHub)" <gi...@apache.org> on 2023/06/09 09:19:59 UTC
[GitHub] [superset] filpano opened a new issue, #24340: Is it possible to create a time-range dependent filter that populates additional (multiple) other filters?
filpano opened a new issue, #24340:
URL: https://github.com/apache/superset/issues/24340
I have the situation where my dataset is partitioned in S3 based on date, in the format YYYY/MM/DD. My query backend is AWS Athena.
When querying data over Superset, I can add a time-range filter to most of my charts and dashboards. I can also, manually, add a filter for my partition columns (year, month, day).
If these columns are not explicitly given, then Athena does not submit the query using the 'expected' filtering leading to:
- higher costs
- longer runtime
It would be rather tedious for every single user to input these partitioning filters every time they wish to query a dataset, and it is error prone.
Is it possible to create derived filters from the "time-range" filter, so that whenever the time-range filter is selected, custom filters (in this case year, month, day) populated from the selected time range are also populated?
I attempted to do this for a dashboard, but I was unable to select the "Time Range" filter as a parent filter for the parent-child filter functionality described e.g. [here|https://docs.preset.io/docs/filter-types]. But ideally, I would like to be able to set this filter extension for an entire dataset (or in some other, global fashion). Is this possible?
--
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.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
Re: [I] Is it possible to create a time-range dependent filter that populates additional (multiple) other filters? [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #24340:
URL: https://github.com/apache/superset/issues/24340#issuecomment-1992542568
I'm not sure if this is still an issue in current versions of Superset (3.x). Dependent filters have come a long way, but I haven't tried this exact use case in recent memory. If it is still an issue, we can re-open this if it's a "bug" but I'd point you to GitHub Discussions (using an Ideas thread) if this is more of a feature request. Closing this for now since it's not an acute bug in 3.x or newer.
--
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] pramodAmbekar commented on issue #24340: Is it possible to create a time-range dependent filter that populates additional (multiple) other filters?
Posted by "pramodAmbekar (via GitHub)" <gi...@apache.org>.
pramodAmbekar commented on issue #24340:
URL: https://github.com/apache/superset/issues/24340#issuecomment-1718881172
Hi @filpano ,
Did you find the solution for this, I'm facing the same issue, My partition is on {text_field}/year/month.
Your help would be much appreciated.
Than you.
--
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
Re: [I] Is it possible to create a time-range dependent filter that populates additional (multiple) other filters? [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #24340: Is it possible to create a time-range dependent filter that populates additional (multiple) other filters?
URL: https://github.com/apache/superset/issues/24340
--
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] mdeshmu commented on issue #24340: Is it possible to create a time-range dependent filter that populates additional (multiple) other filters?
Posted by "mdeshmu (via GitHub)" <gi...@apache.org>.
mdeshmu commented on issue #24340:
URL: https://github.com/apache/superset/issues/24340#issuecomment-1584368439
There was a recent feature added where value filters can be dependent on time range but it is not released yet. Likely to come up with 3.0
--
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] filpano commented on issue #24340: Is it possible to create a time-range dependent filter that populates additional (multiple) other filters?
Posted by "filpano (via GitHub)" <gi...@apache.org>.
filpano commented on issue #24340:
URL: https://github.com/apache/superset/issues/24340#issuecomment-1584379344
Thanks for the quick response. I assume you are talking about https://github.com/apache/superset/pull/23319.
While this is a step in the right direction, I don't think this would allow me to be able to dynamically populate my partition filters using just this feature, so I'm probably out of luck for the foreseeable future (at least for a straightforward solution).
--
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