Hi Team, I’m trying to make the venue filter only ...
# gooddata-cloud
c
Hi Team, I’m trying to make the venue filter only show venues with
carded_turnover > 0
. I’ve added three metric filters, but none of them seem to be working. Do you know how to do this? The link is: 30. Carded Play Summary - GoodData Cloud
k
Thinking completed Based on the screenshot and GoodData's filter behavior, here is how the Filter Values By feature functions and what might be happening: How "Filter Values By" Metric Dependency Works When you add a metric under Filter Values By (such as
Sum of CARDED TURNOVER
), GoodData restricts the dropdown values to only attribute elements that have data (non-null / non-empty values) associated with that metric [Add Attribute Filters on Dashboards]. Key reasons why venues might still show up or appear unaffected: 1. "Show all" toggle in the filter dropdown: When Filter Values By is active, the filter dropdown defaults to showing only relevant values, but it provides a Show all / toggle option that displays irrelevant values as well [Add Attribute Filters on Dashboards; Playwright test]. Make sure the dropdown is currently viewing only relevant values. 2. Evaluation of
> 0
vs. Existing Records
: Filter Values By checks whether data exists for that metric in relation to the attribute element. If a venue has records where the turnover exists (even if it sums to
0
), it may still be considered an available element unless the metric definition itself explicitly excludes
0
(e.g., in MAQL:
WHERE {fact/carded_turnover} > 0
). 3. Date and Parent Filter Context: By default, metric limiting within an attribute filter does not automatically respect dashboard date filters unless the date filter is also explicitly added as a dependency under Filter Values By [Add Attribute Filters on Dashboards]. If the venue had positive turnover at any time historically, it will appear unless limited by the date filter as well. 4. Multiple Metrics: In your configuration, you have multiple metrics added (
CARDED TO %
,
Turnover (Player Session)
, and
Sum of CARDED TURNOVER
). When multiple limiting metrics or filters are configured, they combine—if any metric satisfies the condition or generates relevant records, the venue may still qualify to be shown [Add Attribute Filters on Dashboards]. Alternative: Dashboard Numeric Filter If your goal is to filter the entire dashboard content so visualizations only display venues where turnover is strictly greater than 0 (rather than just limiting the filter dropdown values), you can add a Numeric Filter to the dashboard filter bar: 1. Open the dashboard in Edit mode. 2. Add a new filter to the filter bar and select the metric (e.g.,
Sum of CARDED TURNOVER
). 3. Set the condition to greater than
0
[Numeric Filters on Dashboards]. Need Human Support? Because resolving the exact behavior may require inspecting your metric definitions, data model, and workspace setup, a GoodData Support team member will need to review it. To help the Support team investigate, please add the following details to this thread: • The exact MAQL definition of
Sum of CARDED TURNOVER
(and any other limiting metrics used). • Whether the venues appearing should be filtered out across all time or only for the selected date range (
From 56 to 1 day ago
). • Confirm whether the affected venues have records with
0
turnover or
NULL
values in your dataset. Support Options • Community support (Startup & Professional): You are already in the right place. The GoodData Support team monitors this Slack and a team member will join the conversation when human review is needed, so please keep the discussion and post the requested details directly in this thread. You can also consult the Community Forums. • 24/7 Support (Enterprise plans): If your account tier includes 24/7 Support, or if you are experiencing a Severity 1 (L1) critical issue, these direct options are available in addition to this thread: ◦ Submit a ticket: GoodData Support Portal ◦ Email: support@gooddata.com ◦ Phone: +1 (415) 200-0194 👍 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.
c
@kapa.ai Added sum carded turnover > 0 filter in the dashboard, nothing changed.'
k
Thinking completed Here is a summary of the guidance for troubleshooting why a dashboard numeric filter might not affect your visualizations: 1. Check if the visualization is connected to the filter: By default, numeric filters are only applied automatically if the visualization already uses the exact same metric or has an existing metric filter for it. Otherwise, it must be manually enabled [Numeric Filters on Dashboards]: ◦ Open the dashboard in Edit mode. ◦ Click the visualization widget and open its configuration panel on the right. ◦ Look at the Filter by section. ◦ Ensure the
Sum Carded Turnover
numeric filter checkbox is selected for that widget. If it is greyed out, a tooltip will indicate if the metric is incompatible with the visualization (e.g., if the insight contains a ranking filter, which prevents applying numeric filters) [Numeric Filters on Dashboards]. 1. Check Granularity: A numeric filter evaluates conditions at the level of detail displayed in each visualization (e.g., if a chart is broken down by date, it checks if turnover on that date is > 0; if broken down by venue, it checks per venue) [Numeric Filters on Dashboards]. If you need the filter to specifically evaluate at the Venue level regardless of how the chart is broken down, open the numeric filter’s configuration (gear icon) and set Custom Granularity to the
VENUE NAME
attribute [Numeric Filters on Dashboards]. 2. Note on Attribute Filter Dropdowns: Dashboard numeric filters filter the insights and KPI widgets on the dashboard; they cannot be used as parent filters to restrict what shows up inside other attribute filter dropdowns [Numeric Filters on Dashboards]. Resolving the specifics of your workspace and visualization settings requires human review by a GoodData Support team member. The Support team monitors this Slack community and will step into the thread as needed. To help the Support team investigate, please add the following details to this thread: • The title/name of the specific visualization widget on the dashboard that is not updating. • The attributes and metrics configured inside that visualization. • Confirmation of whether the numeric filter is checked under the visualization’s Filter by configuration. • The workspace ID and dashboard URL (or confirm the URL from your earlier message). Support Options • Community support (Startup & Professional): You are already in the right place. The GoodData Support team monitors this Slack and a team member will join the conversation when human review is needed, so please keep the discussion and post the requested details directly in this thread. You can also consult the Community Forums. • 24/7 Support (Enterprise plans): If your account tier includes 24/7 Support, or if you are experiencing a Severity 1 (L1) critical issue, these direct options are available in addition to this thread: ◦ Submit a ticket: GoodData Support Portal ◦ Email: support@gooddata.com ◦ Phone: +1 (415) 200-0194 👍 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.
c
@kapa.ai Applied the metric filter to top widgets, didn't work
k
Thinking completed As previously summarized, when a dashboard numeric filter does not produce the expected results even after being applied to widgets, the cause typically relates to: 1. Granularity mismatch: Without custom granularity, the filter evaluates
> 0
at the widget's own level of detail (such as per date or per overall total) rather than per venue [Granularity]. If the widget needs to be scoped strictly by venue, custom granularity must be set to
VENUE NAME
on the numeric filter [Granularity]. 2. Filter limitation scope: Dashboard numeric filters only filter the data displayed inside visualizations; they cannot filter or remove options from the
VENUE NAME
attribute filter dropdown itself [Current Limitations]. 3. Metric / LDM definitions: If the metric evaluates to values greater than 0 across the aggregated data points of those widgets, the filter will naturally not exclude anything. Resolving the specifics of why this is not behaving as expected in your dashboard requires human inspection from a GoodData Support team member. The Support team monitors this Slack community and will step into the thread as needed. To help the Support team investigate, please add the following details to this thread: • The exact widget(s) you applied the filter to (e.g., the title of the widget or chart type). • What you expected to change vs. what is currently displayed (e.g., specific venue data points that should be excluded). • The MAQL definition of
Sum Carded Turnover
. • Whether you have set a Custom Granularity on the numeric filter. Support Options • Community support (Startup & Professional): You are already in the right place. The GoodData Support team monitors this Slack and a team member will join the conversation when human review is needed, so please keep the discussion and post the requested details directly in this thread. You can also consult the Community Forums. • 24/7 Support (Enterprise plans): If your account tier includes 24/7 Support, or if you are experiencing a Severity 1 (L1) critical issue, these direct options are available in addition to this thread: ◦ Submit a ticket: GoodData Support Portal ◦ Email: support@gooddata.com ◦ Phone: +1 (415) 200-0194 👍 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.
m
Hi Cathy, I have reviewed our AI Assistant’s responses, and it seems you’re all set. But please let us know if you need any further assistance with this one 🙂