Date filters on dashboard are not dynamic

[ozlembikeleasing]

Hi All,
Thanks in advance for your help.
I have multiple date related filters on my dashboard and using KPIs and line charts to present percentage change relative to previuos year and metrics in time. When any date related filter chosen (say Month), the dashboard presents only that period's calculation. We're in 10th month, what I want for the users is to be able go and choose prefered, year and month and see annual change from that period. I tried configuring "defaultDataMask" as (e.g)

"defaultDataMask": { "extraFormData": { "time_range": "Last 52 weeks" }, "filterState": {}, "ownState": {} },
but did not work.
Any suggestion?

Many thanks

[dosubot[bot]]

To allow users to select a specific year and month and see annual changes from that period in Apache Superset, you need to ensure that your date filters are configured to handle custom time ranges effectively. The defaultDataMask configuration you mentioned is used to set default values for time-related filters, but it might not be sufficient for dynamic user input.

Here are some steps you can consider:

1. Use Custom Range Keys: Ensure that your date filters are set up to allow users to select specific dates. You can use custom range keys like sinceDatetime and untilDatetime to define the start and end of the period users are interested in.

2. Dynamic Date Filters: Make sure your date filters are configured to be dynamic. This means they should be able to respond to user input and update the dashboard accordingly. You might need to adjust the filter settings to allow for more flexible date selection.

3. Check Filter Configuration: Verify that the filters are correctly linked to your KPIs and line charts. The filters should be able to modify the data queries to reflect the selected time range.

4. Test Different Configurations: Experiment with different configurations of the defaultDataMask and other filter settings to see if they meet your requirements. You might need to adjust the extraFormData to better suit your needs.

If these steps do not resolve the issue, you may need to explore more advanced configurations or custom solutions within Superset to achieve the desired functionality.

To continue talking to Dosu, mention @dosu.