Replies: 7 comments 16 replies
-
|
Any updates on this? We would really like it and i'm considering building it myself |
Beta Was this translation helpful? Give feedback.
-
|
I don't believe this has moved. @dijkstra2003 would you be interested in contributing it as a feature back to the main Superset project? |
Beta Was this translation helpful? Give feedback.
-
|
If i'm building this i will definitely contribute and give the code to the main superset ;) |
Beta Was this translation helpful? Give feedback.
-
|
This would be a very useful feature. Another use case for it is a side-by-side comparison: having the same chart twice in one dashboard and applying a different time range to each. |
Beta Was this translation helpful? Give feedback.
-
|
you can do this now by just applying each time filter to specific charts/panels using the "scoping" on the filter :-) |
Beta Was this translation helpful? Give feedback.
-
|
+1. Right now, if you add two time range filters, the second one seems to overwrites the first, which makes it impossible to recover its value even when using the filter variable with Jinja. |
Beta Was this translation helpful? Give feedback.
-
|
Don't suppose anyone found some clever workaround to inject 2 different "Time Ranges" using jinja into queries? |
Beta Was this translation helpful? Give feedback.
-
|
Has anyone found / know any workaround on ways to have atleast two time-range filters in a dashboard? One of our use case is getting blocked since we need to filter on two date ranges ... |
Beta Was this translation helpful? Give feedback.
-
|
Yeh, essentially I've got a "date dimension" dataset and I've added 4 new columns to it (which are essentially replicas) that the filters get their values from so people can select them from a drop down. Not the most elegant thing but does what it says on the tin for the end users! |
Beta Was this translation helpful? Give feedback.
-
|
So are you limited to some predefined dates or did you come up with a workaround to let the user choose any date? |
Beta Was this translation helpful? Give feedback.
-
|
User can choose any dates they want as essentially they get presented with a list of all dates in the 5 years prior to "today" in all 4 I've created and can select any date they want in each. They need to know that Start needs to be before End or else the query will be a bit strange however or may not work properly. With 2 proper time range filters they don't have to search for dates they could use the inbuilt functions on dates (last week, current month) so would just be a much easier user experience and better for them. |
Beta Was this translation helpful? Give feedback.
-
|
Aha, I see! That's a neat solution if the user doesn't mind scrolling to find their date. Thanks for sharing! |
Beta Was this translation helpful? Give feedback.
-
|
Yeh lots of our use cases are looking at comparing any user defined "time range A" vs "time range B" in the same chart table and showing a variance. They can also apply more filters etc. Having to search though a massive list of dates is not ideal but gets to some sort of solution. If I were an awesome coder I'd have a go at being able to properly pull 2 time range filters into Jinja (currently you just get the one of them) but fear I'd bring down the entire project!! |
Beta Was this translation helpful? Give feedback.
-
|
Hi folks. I'm working on a SIP with @john-bodley and @kasiazjc to improve time filters that will resolve this problem. Just to set expectations, we are currently focused on delivering 4.0, but we should continue the SIP work after the release. |
Beta Was this translation helpful? Give feedback.
-
|
Hi Michael. Just checking in on this to see if anything has been done on this? |
Beta Was this translation helpful? Give feedback.
-
|
Hi @phyndman. Unfortunately, priorities changed and we postponed this work for the 2025 roadmap. |
Beta Was this translation helpful? Give feedback.
-
|
no worries thank you for the update. keep up the good work :-) |
Beta Was this translation helpful? Give feedback.
-
|
We also have these types of cases. We have two workarounds:
When we need “flexible” dates, we let the user input the date as a string in a defined format. Pe 2024-01-01
When we have few options, we have a table with the list of possible dates to be selected.
From: phyndman ***@***.***>
Sent: Friday, February 16, 2024 12:05 PM
To: apache/superset ***@***.***>
Cc: Itziar Martínez ***@***.***>; Author ***@***.***>
Subject: Re: [apache/superset] Multiple time range filters (Discussion #24165)
Yeh lots of our use cases are looking at comparing any user defined "time range A" vs "time range B" in the same chart table and showing a variance. They can also apply more filters etc. Having to search though a massive list of dates is not ideal but gets to some sort of solution. If I were an awesome coder I'd have a go at being able to properly pull 2 time range filters into Jinja (currently you just get the one of them) but fear I'd bring down the entire project!!
—
Reply to this email directly, view it on GitHub<#24165 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AYFVXNYILOZJ5IFQY7Y5PQ3YT44OBAVCNFSM6AAAAAAYJ6ZUKGVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4DIOJRGEZDE>.
You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>
|
Beta Was this translation helpful? Give feedback.
-
In Superset 2.1.0 is possible to have multiple time-based filters but, as noted in https://preset.io/blog/exploring-trends-over-non-temporal-dimensions-in-superset-and-preset/#3-exploring-charts-in-dashboards, in the Dashboard there is only one time range for all of them.
Is it foreseen to have different time ranges for each of the time-based filters?
In our dashboards we have several time ranges to filter, like manufacturing date, delivery date... and it makes more sense to be able to filter them with different time ranges.
This was proposed also in #23842
Beta Was this translation helpful? Give feedback.
All reactions