To GoodData homepage

Knowledge base
AnalyticsDashboards and Reports - KB articles8 Metrics and MAQL - KB articles23
Data modeling & IntegrationData models - KB articles8 Data sources - KB articles9
Development & AdministrationGoodData.UI - KB articles11 Administration - KB articles15 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData23
AnalyticsDashboards and Reports111 Metrics and MAQL87
Data modeling & IntegrationData models31 Data sources57
Development & AdministrationGoodData.UI32 Administration71 Solution architecture6 SDKs and APIs20
GoodData For FreshdeskNews & Updates3 Got a question?10 General Information1

Ask your question
Login

Community
Analytics
Metrics and MAQL

Metrics and MAQL

Metrics and MAQL

87 Topics
269 Replies

When you subscribe we will email you when there is a new topic in this category

87 Topics

Most replies

Recently active Most views Newest first

EmmanuelNew Participant

asked in Metrics and MAQL

Median query not working

Hi, I have a set of conversations logged in with DATE attribute. I’d like to measure the median count of conversation per day. However, when I enter something like SELECT MEDIAN(COUNT(conversation_id)) BY Date (Start Date)it doesn’t seem to work, and instead give me the total count, not the median count by date. Am I missing something? How could I get the median count of conversations? Thanks so much

Jay FineganNew Participant

asked in Metrics and MAQL

Single dashboard, two KPIs, use a different time frames

We have several clients who would like to see two KPI/s on a single dashboard: the first shows a statistic for the last 12 months, the second shows the same statistic for the last month. I know that we can build a single KPI and show it on two dashboards (each with its own timeline), and I know how to build KPIs that include/exclude parent filters. But I have been unable to figure out how to have a KPI rely on a parent filter in one case while another KPI on the same dashboard ignores the parent filter while simultaneously substituting an independent timeframe. We have a system attribute called Timeline and our development team has defined two system metrics, _Timeline_Start and _Timeline_End. These metrics were created from Timeline (Min(Date(Timeline) and Max(Date(Timeline), respectively). To me, the latter would be seem to be of particular importance to this inquiry, presuming that the time line for the common dashboard is selected as the 12-month window. Here is an example of the t

Jean-Christophe

asked in Metrics and MAQL

Last session date

Hi all, Trying to show the last session date for each learner. I have followed this proposal to create a metric based on a date from https://help.gooddata.com/classic/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/finding-min-and-max-dates-using-date-arithmeticI use : SELECT MAX ((SELECT (100000 * MAX(Day of Month (Timestamp))) + (100 * MAX(Month (Timestamp))) + (MAX(Year (Timestamp))-2022+2022) BY Coaching Session Uuid)) WHERE (SELECT COUNT(Date (Timestamp), Coaching Session Uuid) BY Year (Timestamp), ALL OTHER) > 0and 0#/0#/#### (day/month.year format) for the format but I get crazy dates. Not sure what are these 1000000 and 100 in the metric.

kmcdavidNew Participant

asked in Metrics and MAQL

Calculating Days Open/days past due

I’m trying to build metrics for days open and days past due. I tried following a similar thread however, its not working quite right. I used the following to calculate days open and I was able to create a report but it did not filter out any completed processes and I was unable to filter the results at all.Similarly I tried to follow the thread for days past due, creating the metric below, but when trying to create a report for it, it said I couldn’t because it would create nonsensical results. Am I missing something or is this not possible to do?

FilipNew Participant

asked in Metrics and MAQL

Use Filter/Parameters to switch between metrics

Hi there,Let's say I have a table with four columns - Year, Organisation, Sales, Cost.I want to create a slicer with two values - Sales and Cost, and an option to select only one of those.If Sales value is selected from the slicer then I want my metric to display sum(Sales), if Cost is selected then I want sum(Cost).Also, I'd like to use this metric to aggregate on Year/Organisation. Is this possible?Thanks

Linda JInspiring

asked in Metrics and MAQL

Date Math

Hello -I am trying to create a metric for a date last yearfor example my selected date filter is 2/01/2021 - I want the answer to be 2/01/2020 I also would like to be able to subtract months as well so 02/01/2021 would be 01/01/2021 Thank you

Chris MacomberParticipating Frequently

asked in Metrics and MAQL

When validating project, getting errors stating "...violates COMPULSORY EDGE..."

Hello,We’ve successfully loaded data from a bigquery, but now I can’t build any insights because as soon as I drag an attribute, the UI throws an error “Connection failed, try again later…”. We went into the gray pages and ran the “validate-project” process and got a lot of “...violates COMPULSORY EDGE...” errors (see attached logs). I assume those are the reasons I can’t build insights. How do I fix those errors?

Anna MNew Participant

asked in Metrics and MAQL

Creating a metric that shows the last previous value generated irregularly

Hello, I'm having trouble creating a CostsPreviousDataset metric that shows me the last previous value for the Costs metric. I managed to set the metric to show the value from the previous day (SELECT Costs FOR PREVIOUS (Date (Datasetdate))), but unfortunately the client does not generate costs once a day every day, but the generation is irregular - it can be once every three days or, conversely, four times a day etc. and the client needs to see a comparison with the previous dataset (not with previous day). Each dataset is marked with a unique integer DatasetID, but I couldn't figure out how to build the formula correctly in MAQL. Thank you for help.

jeny.mNew Participant

asked in Metrics and MAQL

Concatenate Column and String

Hello,Can we create a custom column where we concatenate a column and a string? how do we do it?

Julia KNew Participant

asked in Metrics and MAQL

Timestamps - I need to calculate how many users were active each minute, having single intervals of their activity

Hello!The problem I’m struggling is how to create an AMR (Average Minute Rating) using MAQL. For simplicity I started with one day period when I want to observe how users activity changes over time (for example minute by minute). So I have data of a form:userID start time - atribute refering to Start time table having M, H, S values as a facts, start time label as a key HH:MM:SS and an atribute start time [min] HH:MM start day - date end time - atribute refering to table with a structure like Start time table already described end day - date activity detailsI was able to build a very inelegant vay to find out how many unique users were active during particular hour (e.g 20:45 HOUR = 20, MINUTE = 45), but with one major drowback which is that I need hour and minute as a variable to do those calculations. Here’s the MAQL form:I need solution that could be visualised - for every minute, automatically. Hoping for your help! I would appreciate any hints :)

FilipNew Participant

asked in Metrics and MAQL

Get SQL behind metrics

Hi all, Is there a way to see what the SQL querying the DB is behind a particular metric? Thanks

Andrew IlinNew Participant

asked in Metrics and MAQL

GoodData.CN Community Edition / MAQL metric calculation

HiThis article provides an example of writing a request to the system - https://www.gooddata.com/developers/cloud-native-community-edition/ like Active Users:SELECT COUNT(User) WHERE User Status = "Active"We have installed the system and cannot find a way to make such a request. Are they available there? Where could we go wrong?Thanks!

Allan TalverNew Participant

asked in Metrics and MAQL

Linking two unrelated datasets in MAQL

Hello,I am attempting and failing to write some MAQL queries.I have two datasets with the following fields (model simplified from the real world case, which has many more attributes for contracts):Contracts Vendor name Contract currency Contract value in contract currency Exchange Rates Currency Date Rate The Exchange Rates are stored as a rate between the respective currency and our company main currency. The exchange rate for the main currency being stored as 1.I need to build a report which shows list of contracts (by vendors) with several metrics, including contract value:in our company base currency in the currency selected in a dropdown selector of the dashboard (the exchange rate for the current date should be used for conversion)I have been trying to build the metrics, but I have not succeeded yet. I have started with creating a metric which would get the current day exchange rate for each contract:SELECT SUM( SELECT SUM(Rate) BY Date, Currency ALL OTHER )BY ALL OTHEREXC

romanzdkNew Participant

asked in Metrics and MAQL

Filter by date in MAQL while ignoring dashboard filter

What I would like to achieve:Select specific day (date) using dashboard filter and from this specific date take e.g. 55 days back and for this period compute e.g. sum of Sales.Is it possible to somehow achieve this? I defined currently selected date asSELECT MAX(Date (Date)) BY ALL OTHER WITHOUT PF EXCEPT Date (Date)and lagged Day asSELECT Selected day - 55 and the metric for the sum:SELECT SUM(Sales) WHERE Date (Date) > Lagged day and Date (Date) <= Selected day WITHOUT PF however this does not give any results. How to solve this, please?

GabrielGrecoNew Participant

asked in Metrics and MAQL

See MAQL codes made by "Analyze"

Hey!So, I would like to know if there is any way to see the MAQL code made up by the drag & drop analyze. I created a insight using the drag & drop tool but I need to see the Metric code (SELECT) that was generated by the tool to use at other projects. Thanks!

Thiago Vivian RibeiroNew Participant

asked in Metrics and MAQL

Help with RUNSUM

Hello! I’m heaving some problems to do a RUMSUN without an atribute Date. I’m trying to do it with an atribute of mt products:Basicaly i’m trying to an RUNSUM of that valeu for each product. The only way i could make summing all of then, but i need sum for after another.I know i can make this if the accumulate direct on the report but i need to make the metric.Does anyone knows how to code this? i tried many ways but none works. Thank you!

Douglas PaivaNew Participant

asked in Metrics and MAQL

Add column with comparative percentage of years

Hi guys!I would like to know how I can add a column that presents the percentage calculation comparing the values of a year with the previous year, as shown in the table below. I only need three columns... if possible to show in "green" the growth and in "red" the fall. Could you help me please?

LuciaDelloNew Participant

asked in Metrics and MAQL

Is it possible to create an attribute type metric?

Hi, I am trying to create price range bucket to group together products by prices ranges <£50, £50-<£100 in MAQL as a metric then to use it to display results by price ranges.I am able to do the calculation but my new metric is created as a fact not an attribute so I cannot build analysis of different price buckets.I looked at computed metrics too but these only allow me to use pre-created attributes and not fact values within them.Is this possible to do or does this need to happen before the data model enters GooddData. Thanks.

Jean-Christophe

asked in Metrics and MAQL

List Unused object

Hi All, Is there a way from the grey pages to list all unused metrics in KPIs, Insights, other metrics… ?Without having to check metric one by one using the Object/Used button. Best regardsJean-Christophe

deedeeduduNew Participant

asked in Metrics and MAQL

Sum by current year of subscription rather than calendar year

Hi team,I have a data model where we keep track of the customers accounts as well as the campaigns created by them.Customers have subscription_start_date and subscription_end_date as date dimensionsandCampaigns have created_at as date dimensionsFurther, Campaigns also have a Fact called as VolumeSubscriptions can run into multi years and the year (not the calendar year) of subscription starts from subscription_start_dateEg.A customer ABC, subscription_start_date = 04-Jul-2019, subscription_end_date= 04-Jul-2025Current year volume would be sum of volume of all the campaigns created after 04-Jul-2022 I want to create a metric that gives me the Volume for the current year of subscription There can be different customers with different subscription_start_date

AshleighNew Participant

asked in Metrics and MAQL

Difficulty creating new MAQL metric based on Customer Segment

Hi,I have a dataset containing sale orders, which includes:Order Date - Date the order was placed Customer ID - Unique ID for each customer Order ID - Unique ID for each order Customer Type - ‘New’ if it’s the first order placed by the customer, ‘Repeat’ for all subsequent orders £ Amount - Total order amount in GBPWe would like to introduce a Customer Segment, which is dependent on the reporting period (week/month/year) and is defined as:‘New’ if the customer placed their first order within the reporting period (regardless of whether they also placed repeat orders within the reporting period) ‘Existing’ if the customer placed their first order before the reporting periodI want to create a metric ‘£ New Customer Sales Monthly’ which is the SUM of the sale order amounts (£ Amount) for New customers each month.Note - if the customer places their first order in a given month and places repeat orders within that same month, then all of those sale order amounts should be included in the ‘£

JeffCParticipating Frequently

asked in Metrics and MAQL

Date Time - Date Time

In our lake we store multiple date times, specifically for our use-case a postgress database with columns utilizing timestamp with time zone, nullable. call_start_time: 2023-01-14T16:32:25+00:00call_end_time: 2023-01-14T16:35:16+00:00 We don’t have a calculated column today, nor are we calculating at insert so we’re trying to create a metric that selects the average of call end time - call start time). Since things may cross over the 24 hour mark and of we want to present data stored in UTC across different timezones, I’m looking for a way to make this work. In SQL it would be something like: SELECT AVG(TIMESTAMPDIFF(SECOND, call_start_time, call_end_time)) AS avg_time_not_answered FROM your_table_name WHERE Interaction_handled = 0; How can I replicate this in Gooddata, secondly, what is the easiest way to change visualization of our data into a selected timezone?

Keith FinnNew Participant

asked in Metrics and MAQL

Grouping measures into folders in Analytical Designer

Is it possible to group existing metrics and calculated measures into folders in Analytical Designer?

Leilani GreerGoodData Employee

asked in Metrics and MAQL

Metric vs Measure and Best Practices

What is the difference between Metric and Measures .... Are there best practices around when to use which one ?

JamesParticipating Frequently

asked in Metrics and MAQL

How To Ensure A Metric Available In Analytics Designer

Hi I created a metric based on two values that I’m using in an insight. However, when I use the metric ( a measure that simply chooses which of the other two measures should be shown) I get a message saying “Sorry, We Can’t Display This Insight”. And then when I use other data values, it moves into “unrelated data measures” Do the metrics need to be applied to the LDM? Or do I need to somehow associate the metric with a given dataset? Thanks James

1
2
3
4

Page 2 / 4

Powered by inSided

Welcome to the GoodData Community!Cookie settings

Sign up

Already have an account? Login

Social Login

or

Username (also your display name - please use John Doe rather than john.doe) *

E-mail address (if you already use GoodData, we encourage you to use the same e-mail address you use for the GoodData platform) *

Full Name

(Private)

Only you and moderators can see this information

*

Company

(Private)

Only you and moderators can see this information

*

I use the following GoodData products

(Private)

Only you and moderators can see this information

GoodData Platform GoodData Cloud GoodData.CN GoodData for Freshdesk

Password *

I have read and agree to the GoodData Community and University Terms of Use and Privacy Policy.

loginBox.register.email_repeat

Login to the community

Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account

Social Login

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK