Hi Team, I created two metrics and I can see them in "Metrics" tab, but I can't find them when I create the dashboard. Please see below snapshot. All the metrics or attributes are from the same table. The link is: 65. NSW LGA Report - GoodData Cloud. Can someone help with it?

Thinking completed Hi! This is a known issue that has come up before. Here are the most common reasons why metrics created in the Metrics tab may not appear when building a dashboard or visualization: Things to check: 1. Browser cache — Try clearing your browser's cache and cookies, or open the dashboard in a different browser/incognito window. This has resolved the issue in similar cases. [Community Slack] 2. Logical Data Model (LDM) relationships — Even if all attributes and facts come from the same table, the metrics need to be properly connected within the LDM. Ensure that all elements (attributes, labels, facts, primary keys) are correctly defined and mapped. [Community Slack] 3. Data source connectivity — Verify that the data source for the metrics is correctly defined and accessible. 4. Metric visibility in Analyze — Try switching to the Analyze tab and searching for the metrics there. If they appear in Analyze but not in the dashboard builder, it may be a UI/cache issue. Since this involves inspecting your specific workspace configuration and metrics, the Support team will need to take a closer look. To help the Support team investigate, please add the following details to this thread: • The names of the two metrics that are not appearing (e.g., NSW LGA EGM Days and NSW LGA NMR as shown in your screenshot) • How the metrics were created (UI or API) • Whether the metrics are visible in the Analyze tab • Any error messages you may be seeing • Your workspace/organization details Community support (Startup & Professional) You're 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. You can also visit the Community Forums for additional help. 24/7 Support (Enterprise plans) If your account includes 24/7 Support or this is a Severity 1 (L1) critical issue, you can also: • Submit a ticket: support.gooddata.com • Email: support@gooddata.com • Call: +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.

Hello Cathy, Our AI assistant provided an accurate response. Please let us know if you have any further questions.

Thanks Yvonne, I can see it in Analyse now, but when I drag it into Metrics in Canvas, I get an error. Could you help me work out how to get it working?

Hi Cathy, Thanks for the trace ID, it helped. The error happens because NSW LGA NMR new divides two facts directly. GoodData needs each fact wrapped in an aggregation function such as SUM before it can calculate the metric. Please edit the metric to:

SELECT SUM({fact/DTM_NSW_QUARTERLY_LGA.LGA_REVENUE}) / SUM({fact/nsw_lga_egm_days})

That gives total revenue divided by total EGM days. More detail is in our Aggregation Functions docs. Could you let us know if this fixes it? If it doesn’t, please tell us how urgent this is and whether other users or dashboards are affected.