To GoodData homepage

Metrics and MAQL

Metrics and MAQL

  • 108 Topics
  • 342 Replies

108 Topics

K
kaviKnown Participant
asked in Metrics and MAQL

Existing Metrics are not working

Hi, My current project is to create a unified workspace—a single workspace used by several clients. I had the opportunity to upgrade the current data model to include a new primary key in gooddata during that procedure. I noticed that some of the current metrics are not functioning and are displaying an error as I have given below after updating the data model.It would be more helpful if I get the quick and valuable response.  Thanks,Kavi

1
Michael Ullock
GoodData Employee
5 months ago
A
apalliniNew Participant
asked in Metrics and MAQL

Sum all table values in the row

Hi all, I am trying to get the Budget Sum in my row, but until now withour success. Essentially, based on the picture, I would like to see the SUM of the column Budget on each row. I tried SELECT SUM(Budget) and SELECT RUNSUM(Budget) but I only receive the row value and not the total of all rows.. Any suggestion? Thank you,Andrea

1
Michael Ullock
GoodData Employee
4 months ago
secutech
secutechNew Participant
asked in Metrics and MAQL

metric

HelloI want to revise my MAQL query so that it counts only 75% of the allocations and then multiplies that number by $177. For example I want the 75% of the 2088 hrs (2088hrs is 261 days) but it want to count only 75% which is 1566hrs * $ 177.How the query should look like  

1
Moises Morales
GoodData Employee
4 months ago
K
Kyle LNew Participant
asked in Metrics and MAQL

SUM producing error in metric, but not table

Hiya, I’m a novice and have been working through getting some metrics created for my company. I’m attempting to sum Metric A. I can do this in a table without any issue, but as soon as I create Metric B that is SUM(Metric A), it produces an error. I’ve tried incorporating ifnull and swapping attributes I’m locking it on, but that has seemingly had no impact whatsoever. If you could sum a metric in a table, but couldn’t directly in the metric, how would you approach troubleshooting? Appreciate any steering or help that can be provided!

1
Moises Morales
GoodData Employee
2 months ago
WaseemDev
WaseemDevNew Participant
asked in Metrics and MAQL

Move Metrics from one workplace to another

i have created a new workspace and I want to use metrics of my previous workspace in my new workspace but I am unable to find metrics. it shows i need to create the metrics again.

1
Julius Kos
GoodData Employee
1 month ago
K
GoodData Employee
Kyle ShimekGoodData Employee
published in Metrics and MAQL

Creating Measures that Override Filters in GoodData.CN

When creating measures and designing dashboards in GoodData.CN, there may be times where you want a calculated value to remain the same after applying a dashboard filter. This is possible by creating measures with the WITHOUT PARENT FILTER keyword in MAQL.  This keyword prevents any so-called Parent Filters from applying towards the measure. A Parent Filter is a filter that is applied to an object that uses the measure, such as an insight or dashboard.  The keyword can take the following forms: SELECT … WITHOUT PARENT FILTERSELECT … WITHOUT PARENT FILTER EXCEPT …SELECT … WITH PARENT FILTERSELECT … WITH PARENT FILTER EXCEPT … In the MAQL syntax, “PARENT FILTER” can also be abbreviated as “PF”. So, “WITHOUT PARENT FILTER” can also be written as “WITHOUT PF”.  In this article, I will lay out a few common examples of when you might use this feature. You can read more in our documentation. Common use casesOne use case is to have a dashboard with filterable insights where one or more insight

1170
K
GoodData Employee
2 years ago
K
GoodData Employee
Kyle ShimekGoodData Employee
published in Metrics and MAQL

Creating measures with conditional expressions using the IF keyword

With MAQL, you have the ability to create measures that use conditional expressions, allowing you to compute your more complex business requirements. One way to do so is to use the IF keyword. It looks like this:SELECT IF condition THEN expression ELSE expression END The IF keyword works just like it sounds: you will set a condition after “IF”, the value to use if that condition is met after “THEN”, and the value to use if the condition is not met after “ELSE”. Finally, you end the expression with “END”. The IF keyword can be used in both GoodData Platform and GoodData.CN.  Here are a few examples of measures we can create in the metric editor: SELECT IF AVG(Duration) > 60 THEN 1 ELSE 0 ENDSELECT IF Category = “Email” THEN SUM(Budget - Spend) ELSE SUM(Spend) ENDSELECT SUM(SELECT IF Cost > 200 AND Supplier = “Acme Products” THEN Price * 2 ELSE Price END) And those same examples as created in GoodData.CN using the API:SELECT IF AVG({fact/call_center.duration}) > 60 THEN 1 ELSE 0

1000
K
GoodData Employee
2 years ago
RenaudD
RenaudDNew Participant
asked in Metrics and MAQL

Metric to count periods

Hello,I seek for help because I don’t know if it is just impossible by MAQL or if I spent hours doing something wrong. Can you please help me ?We have a dataset like the one below. The users are registered to a specific training course. Each registration have a starting date. The end can be null or set to a specific date.Training Course User Registration Start (Shared Date) Registration End Onboarding A 2022-12-01 2023-12-31 Onboarding B 2023-07-01 null Onboarding C 2024-01-01 null Onboarding D 2023-12-01 2024-02-2024 Onboarding E 2022-12-01 null  I want to have a metric to calculate the number of open registrations. It must count a registration if his end date is null or above the minimum date in the filter, and the start date must be lower than the maximum date in the filter. It can give something like this : (Date(Registration End) >= Start_Date OR Date(Registration End) = (empty value)) AND Date(Registration Start) <= End_Date

0
RenaudD
1 hour ago
Welcome to the GoodData Community!Cookie settings