How to save the default filter in the dashboard

[krishanthvs]

Bug description

How to save the default filter in the dashboard

Screenshots/recordings

No response

Superset version

master / latest-dev

Python version

3.11

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[krishanthvs]

@dosu Can you please help me

[dosubot[bot]]

I found a similar unsolved discussion on saving default filter values in a Superset dashboard: Saving default values filter in a dashboard ^[1].

In Superset, you can specify default filter values in the default_filters section of the dashboard's metadata. The convert_filter_scopes_to_native_filters function handles the conversion of legacy filter configurations to native filter configurations and includes logic for setting default filter values using the default_filters from the json_metadata. Here's a relevant snippet from the code:

default_filters = json.loads(json_metadata.get("default_filters") or "{}")
...
default = default_filters.get(key, {}).get(field)
...
if default:
    fltr["defaultDataMask"] = {
        "extraFormData": {"granularity_sqla": default},
        "filterState": {"value": [default]},
    }

This indicates that you can set default filter values by specifying them in the default_filters section of the dashboard's metadata ^[2].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[krishanthvs]

@dosu can you assign this to a maintainer

[dosubot[bot]]

To save a default filter in a Superset dashboard, you can configure the default_filters field in the dashboard configuration. This is typically done in a YAML configuration file, like so:

default_filters: "{}"

This field allows you to specify default filter states, although in the example provided, it is set to an empty state ^[1].

Additionally, the file superset/commands/dashboard/filter_state/create.py handles the persistence of filter states across sessions. The CreateFilterStateCommand class in this file is responsible for creating and storing filter states using a cache mechanism ^[2].

For more detailed guidance, you might want to check out the discussion thread titled "Saving default values filter in a dashboard" ^[3]. However, it appears that this discussion is still unsolved.

If you need further assistance, @rusackas might be able to help you with this issue.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[dosubot[bot]]

This is a tough nut to crack, could really use your help on this, @rusackas.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[krishanthvs]

@rusackas can you please check on this

[sadpandajoe]

When you add a native filter, there is a checkbox that you can check that sets a default value. A dropdown will then appear and you can select the defaults you want and save the filter. I believe you also need to be the dashboard owner to create a filter, so if you aren't you may need to save a copy of the dashboard first.