Hello! I have been working on a dashboard that ste...
# gooddata-cloud
n
Hello! I have been working on a dashboard that stems from a single visualization and am running into some issues with date filtering. Within the dashboard, I want to use 3 different dates that correspond to different facts within the visualization and dynamically filter the results by all 3. What would be the best way to do this? Also, if possible, is there a way to allow the user to select the past 14 days or some other time frame and have it affect all three filters simultaneously? Or would they need to change all three filters each time they used the dashboard?
k
New message text here
n
Hi again @kapa.ai, if I apply date filters to the dashboards and it causes my data errors out, do you think that is a logical data model issue with how dates are applied to the datasets?
k
A message from kapa.ai
Yes, if applying date filters to your dashboards causes data errors, it is very likely related to how date dimensions are connected in your Logical Data Model (LDM). Several knowledge sources highlight that issues with date filters—such as errors, missing data, or ambiguous results—often stem from the relationships between date datasets and your fact tables in the LDM. For example, if a date dimension is not properly connected to the relevant datasets, or if multiple date filters are applied to the same date dimension, you may encounter errors or unexpected results. Additionally, if your LDM uses a shared date dataset across multiple tables, applying a date filter will affect all connected datasets, which may not be the intended behavior. In such cases, you might need to review your LDM connections or consider introducing additional date dimensions for more granular control [Additional Date Filters](https://www.gooddata.com/docs/cloud/create-dashboards/filters/date-filters-on-dashboards/#additional-date-filters). Community discussions also confirm that errors can occur if the date dimensions are not correctly set up or if there are changes in the LDM that break the expected relationships between tables and date fields. For example, missing or incorrectly defined primary keys, or changes in how date fields are linked, can lead to errors when filtering by date [Community Slack Example](https://gooddataconnect.slack.com/archives/C04S1MSLEAW/p1701957295346269?thread_ts=1701957295.346269&cid=C04S1MSLEAW). In summary: Yes, data errors after applying date filters are often a sign of issues in your LDM, especially with how date dimensions are connected to your datasets. Reviewing and correcting these connections is recommended.