Hi Team, I created two metrics and I can see them ...
# gooddata-cloud
c
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?
k
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.
y
Hello Cathy, Our AI assistant provided an accurate response. Please let us know if you have any further questions.
c
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?
m
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:
Copy code
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.
c
Thanks Mauricio!
@kapa.ai I have calender_year like 2026 and quarter like 1. How can I create year_quater metrics in GoodData like "2026 Q1" and let it work as a filter
k
Thinking completed The knowledge sources do not contain enough information to give you a fully confident step-by-step answer for this specific use case, but I can point you in the right direction based on what is documented. Creating a year_quarter Combined Field Since you want to combine
calendar_year
and
quarter
into a single label like "2026 Q1", the best approach in GoodData is to use a SQL Dataset with a computed column using
CONCAT
. Step 1: Convert your dataset to a SQL Dataset 1. In the Logical Data Model (LDM) editor, select your dataset, click … (ellipsis) and choose Map dataset to. 2. Select SQL query and click Save. 3. A pre-generated SQL query will appear. [SQL Datasets] Step 2: Add a computed year_quarter column Edit the SQL query to add a concatenated field, for example:
Copy code
SELECT
  "calendar_year",
  "quarter",
  CONCAT(CAST("calendar_year" AS VARCHAR), ' Q', CAST("quarter" AS VARCHAR)) AS "year_quarter"
FROM "your_table"
This will produce values like
2026 Q1
. [SQL Datasets] Step 3: Map year_quarter as an Attribute After saving the SQL dataset, map the new
year_quarter
column as an attribute (not a metric) in the LDM. This allows it to be used as a filter on dashboards and in visualizations. Step 4: Use it as a filter Once mapped as an attribute,
year_quarter
will be available as an attribute filter on dashboards and in the Analyze tab, where you can select values like
2026 Q1
. > Note: If your source data already has a native
Quarter/Year
date granularity connected via a Date Dataset, GoodData natively supports
Quarter/Year
granularity (e.g.,
Q1/2026
) without needing a computed column. You may want to check if your date dimension already exposes this. [Date Datasets] The exact
CONCAT
syntax may vary depending on your underlying database (e.g., Snowflake, BigQuery, PostgreSQL). If you run into issues with the SQL query or LDM mapping, please share the details in this thread and the Support team can assist further. 👍 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.