Having an odd issue where When I set up a chart I am able to separate the metrics by an attribute but if I was to filter by the attribute the chart says there is no data available

This is a known issue that others have encountered in GoodData. There are several potential causes when an attribute works fine as a row/dimension in a visualization but fails to load values or filter correctly: Possible Causes & Solutions 1. Stale or Corrupted Cache The most common cause is a caching issue. The cache can fail specifically during the step where GoodData lists available label values for filtering (via the

computeLabelElementsPost

API call), while still working fine when loading rows in a visualization. [attribute filter issue] Fix: Try reloading your cached data. This resolved the issue for at least one community member who experienced the exact same symptom. [attribute filter issue] 2. LDM Relationship / Inner Join Issue If your attribute is connected to other datasets via a many-to-many relationship (through an intermediate table), GoodData may apply inner joins when listing filter values. If the intermediate table is empty or has missing rows, the filter returns no results — even though the visualization can still display data. [LDM join issue] Fix: Ensure the intermediate/junction table is populated. You may also want to review your LDM connections to confirm the relationships are set up correctly. 3. Workspace Data Filters If your workspace is part of a workspace hierarchy, a workspace data filter or user data filter may be restricting the data, causing the filter to show a "None" state with no data displayed. [workspace filter issue] 4. CASE Statement / Metric Logic If your visualization involves metrics with

CASE

statements that return constants, filters may not be pushed down correctly in the generated SQL. In such cases, enabling "Show missing values" on the attribute may help, or you may need to revisit the metric definition. [CASE filter issue] Recommended first step: Reload your datasource cache, as this is the quickest fix and has resolved this exact symptom for other users. If the issue persists, check your LDM for many-to-many relationships with empty intermediate tables, and review any workspace data filters that may be active. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.

Hi Chris. Try to follow the recommendations of our AI, and if the issue persists, please provide us with a direct link to the insight/visualization in Analytical Designer, a screenshot of the issue you are facing, and additional information such as: 1. What metric(s) are being used in the chart? 2. What attribute is being used to separate the metrics (e.g., in "View by")? 3. Is the same attribute being used both to split the chart and as the filter? 4. Are the metric(s) and the filtering attribute from the same dataset, or from different datasets connected via references? 5. Does the metric use any CASE statements or constants, as these can prevent filters from being pushed down in the SQL query? Thank you in advance.

IT seems to be some issue with the metric as when I use the display missing values option they show up but with 0 in the value

Hi Chris, I will write you via DM to share my findings.

apologies I haven't, I will contact back if needed I have had other priorities come up