Redash: Dashboard filters

[arikfr]

User should be able to add a filter to the dashboard that will be applied to all the queries of the widgets displayed.

Such filters can be:

• date selection
• values selection

TBD: explain about the two possible implementation strategies.

[arikfr]

An example of where the strategy of filtering on the "client side" won't work: when doing a query with limit on the results. For each filter the top results will be different.

[arikfr]

Related: #140 .

[arikfr]

One comment though - the values for the filter are the union of all relevant filter values in the dashboard.
The problem with that is that in case one visualization/query has no data points for this filter, then the dashboard-wide filter will not affect it when setting the missing value, which can be quite confusing for a user (as all widgets on the dashboard will be for filter value A, while some other widget will be for value B)
I think a better behavior would be to clearly mark in the visualization/table that there are no relevant data points.

[indupulikkot]

HI arik,
As you said these filters are not working as expected.
'the values for the filter are the union of all relevant filter values in the dashboard.'

I our case, the global filter is taking first chart's filter value even if there are more values in the filter for second chart. So basically it is not doing union.

Please suggest

[RichardLitt]

Thanks for logging that, @indupulikkot. Can you provide a minimal example that we can look at to fix this?

[indupulikkot]

Iam attaching a screenshot with the issue description. Please review and suggest a fix for this. Our project is already live and this persists as an issue for us.
redash global filter issue.docx

[RichardLitt]

@indupulikkot Thanks for attaching a screenshot, and for letting us know that this is potentially urgent for you.

The open source version of Redash is a community project and comes with no warranties or support. We'll fix this issue when we can or when it becomes relevant to our customers, but other issues have a higher priority right now. The fastest way for this to be fixed would most likely be for you to suggest a pull request, which would really be great. Let us know if it's something you need help with, and will review the PR and try and help you land it.

If you need commercial support for your Redash deployment, you should use the SaaS version. In some cases we might consider engaging in a support contract for an on-premises deployment, but this is discussed on a case-by-case basis.

[arikfr]

@RichardLitt I updated your comment to better reflect the actual situation (saying Redash is mostly volunteer run is not accurate).

@indupulikkot FYI.

[arikfr]

I'm closing this, as most of what described here can be achieved with parameters.

If there are specific issues with filters or parameters on dashboards, we should open more granular issues.

[RichardLitt]

Thanks @arikfr!

[indupulikkot]

May I know why this issue is closed? C ould you please help us to fix this as we do not require parameters.