Filter Relative Date

I have a dashboard with 2 time filters pointing to the same date field.

This is because it is a lot of data and when you start the board, it has by default the relative date according to the current week.

The user has the option to disable the relative date filter and use by date range (so you can check the time period you need).

The problem is that although the relative date filter is disabled, it generates problems in the result.

Dashboard filter, without relative date

But if I enter the question, it shows the correct number.

I don't understand what problem it causes to have the relative date filter associated. Disabled totally changes the result.

I will continue investigating...

Hi @jlcornejo
Post "Diagnostic Info" from Admin > Troubleshooting.
I don't understand why you have two filters instead of just giving the user "All options" in a single Time filter.

If I leave the dashboard unfiltered, it takes a long time to load.

@jlcornejo Yes, I understood that. Why don't you just create a single filter with a default value?

Post "Diagnostic Info" from Admin > Troubleshooting.

1 Like

you should leave a specific date and it is not what is needed.

I need to show, for example, the current week (what I can achieve with a relative date).

But that filter doesn't allow to select a time range.

image

If there is another way, I would appreciate the information as this is the only solution I found.
*When opening the board that shows the current day or week and that it can be modified for a range of time, depending on what the user requires.

@jlcornejo
Select "All Options", when creating the filter, then you get all options available

1 Like

It looks great, I have many dashboards with double time filter...

I don't know how I didn't see this option....

Thank you... :slight_smile:

PS: It will be a lot of work to update everything, but it will look great.

@jlcornejo We are trying to implement a way to modify an existing filter, but it's a lot more complicated than it sounds, since there's references which might be invalid.
https://github.com/metabase/metabase/issues/14296 - upvote by clicking :+1: on the first post