Cathy Liu
10/23/2026, 12:04 AMkapa.ai
10/23/2026, 12:04 AMYvonne Changamuka
10/23/2026, 12:48 AMCathy Liu
10/23/2026, 1:22 AMMauricio Cabezas
10/23/2026, 10:34 AMSELECT 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.Cathy Liu
10/26/2026, 12:11 AMCathy Liu
10/26/2026, 12:28 AMkapa.ai
10/26/2026, 12:28 AMcalendar_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:
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.