Hello GD team, I have a use case now where I have ...
# gooddata-cloud
j
Hello GD team, I have a use case now where I have a field (int) that the user should be able to interact with as a filter on the dashboard and whatever value they select in the filter will be used to in a metric to calculate some numbers to show corresponding on the visualisations. However, I'm having issues trying to figure out how this can be configured, could you advise if this can be done and how? cc @Alson Yap
k
Hello! This is an interesting use case. Let me clarify what's possible in GoodData based on the available documentation. Filtering by Metric Values on Dashboards GoodData supports metric value filters (also called measure value filters), which allow users to filter visualizations based on the value of a metric. However, this works by filtering out rows where the metric value doesn't meet a condition (e.g., greater than X, between X and Y) — it doesn't dynamically pass a selected value into a metric formula to recalculate results. What you can do: 1. Metric Value Filter on a Visualization (Analytical Designer): You can add a metric value filter to a visualization so users can filter data based on a metric's value (e.g., show only rows where
Sum of Orders > 100
). [Filter by Metric Values] 2. Attribute Filters on Dashboards: If your integer field is modeled as an attribute (rather than a fact/measure), you can add it as an attribute filter on the dashboard, and it will filter the data shown in all linked visualizations. [Attribute Filters on Dashboards] 3. Measure Value Filter Component (SDK/Embedded): If you're building an embedded analytics solution using the GoodData UI SDK, you can use the
MeasureValueFilter
React component to let users interactively set filter conditions, which are then applied to visualizations. [Measure Value Filter]
Copy code
<MeasureValueFilter
       onApply={this.onApply}
       filter={filters[0]}
       buttonTitle={measureTitle}
   />
   <BarChart
       measures={[Md.$TotalSales]}
       viewBy={[Md.LocationResort]}
       filters={filters}
   />
What is not currently supported: The use case where a user selects a value from a dropdown and that value is injected into a metric formula to dynamically recalculate results is not natively supported. As confirmed in the GoodData community, making metric names or metric computation dynamically driven by a filter selection is not currently possible due to compatibility complexities. [Community Slack] Recommendation: • If your integer field acts as a dimension/attribute (e.g., a category or segment ID), model it as an attribute and use it as a dashboard attribute filter. • If you need to filter results based on a metric threshold, use the metric value filter feature. • If you need truly dynamic metric parameterization, this would likely require a custom embedded solution using the GoodData UI SDK. I'd recommend reaching out to your GoodData account team to discuss your specific use case in more detail, as there may be workarounds depending on your data model. šŸ‘ 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.