To GoodData homepage

Metrics and MAQL

Metrics and MAQL

  • 86 Topics
  • 267 Replies

86 Topics

B
B. LoganNew Participant
asked in Metrics and MAQL

Issue plotting RUNSUM without data at regular intervals

Hello,I’m attempting to plot fees + expenses to date by week to show project expenditure against budget. I’m using the following metric definition to create this specific trend. SELECT RUNSUM(IFNULL(Time Entry: Fees In Cents/Currency: Base Unit, 0)) + RUNSUM(IFNULL(Expense: Amount In Cents/Currency: Base Unit, 0)) with PF except Date (Shared)This works as expected when there is data every week, however not all projects will have expenses each week. When there is intermittent data, RUNSUM doesn’t graph correctly. Essentially there are holes in the graph, and as soon as there is data again the graph will continue, but leave a gap. This issue is not corrected by the “ifnull” statement in the metric definition. For example, the yellow trend below is fees + expenses to date, the green trend is fees to date. Fees to date is shown correctly because there are fees already entered for the week of Sun 3/19/2023, but there are no expenses yet so the yellow trend line stops at the previous week. I

1
Moises Morales
GoodData Employee
1 day ago
L
LenaKnown Participant
asked in Metrics and MAQL

Are there any ways to display the current date in an insight?

Hi guys,I want to display a custom metric that is the current date + 90 days. I have a custom metric isAnd on the report it is displaying as a number, are there any ways to convert it to date format? Thanks for your help,Lena  

1
Moises Morales
GoodData Employee
9 months ago
Adamkeith
AdamkeithNew Participant
asked in Metrics and MAQL

Data Type Conversion

We want to create a 'Helper Column', which is a New metric from an existing fact in the underlying data model. See attached (MAL).1. When the insight is loaded into the Matrix/table, it reflects as an integer. Does GoodData Not support Format Date? (See attached).   

1
Michael Ullock
GoodData Employee
9 months ago
romanzdk
romanzdkNew Participant
asked in Metrics and MAQL

GoodData - fixed value over time

Is it possible to carry one last value in time (T2) over to previous times? In Tableau I would use LOD "FIXED" expression..I already tried all the PARENT filters WITH/WITHOUT EXCEPT.. Nothing works..Input:| Time | Value || -------- | -------------- || T-1    | 7            || T0   | 8            || T1   | 9            || T2   | 10            |Wanted output:| Time | Value | Result || -------- | -------------- | ------ || T-1    | 7            | 10 || T0   | 8            | 10 || T1   | 9            | 10 || T2   | 10            | 10 |

1
Jan Kos
GoodData Employee
6 months ago
GuilhermeNascimento26
GuilhermeNascimento26New Participant
asked in Metrics and MAQL

Show first date, filtering by branch

Good afternoonI'm trying to show the first issue date of a given document, filtering by branch.Does anyone know if it's possible?

1
Moises Morales
GoodData Employee
4 months ago
Thiago Ferreira
Thiago FerreiraNew Participant
asked in Metrics and MAQL

Diference between dates

Good morning, Is there any way to count the difference in days of two dates without counting holidays?

1
Moises Morales
GoodData Employee
4 months ago
Douglas Paiva
Douglas PaivaNew Participant
asked in Metrics and MAQL

Use more than 4 decimal places

Hello guys!Could you help me? I have to calculate the value of the cost x amount of information in our database. I'm having difficulties because the cost has more than 4 decimal places, as shown in the image below. I've tried using the Property templates, but without success.Note: It is set to float

1
Julius Kos
GoodData Employee
3 months ago
scott.jacobsen
scott.jacobsenParticipating Frequently
asked in Metrics and MAQL

How do you count records with effective dates

If I have a `users` table with effective dates, so the columns like this:id, start_date, end_dateAnd I want to count the users that were active anytime in a filtered date range in sql I would just doselect count(distinct(id)) from users where start_date <= {end of range} and end_date > {start of range}The values {end of range} and {start of range} would be based on whatever date filter the user selected in the dashboard - for example if they selected YTD {start of range} would be 2023-01-01 and end of range would be 2023-02-20I can’t figure out how to do this in the metrics editor though. Is it possible?

1
Moises Morales
GoodData Employee
1 month ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Null Value - Unanswered Phone Calls missing

I have a table of phone call facts, that includes a foreign key to a users table.  When making dashboards, things have been going well as long as the phone call is answered - because the user_id field is populated and aligns with a worker.  Unfortunately, some calls are not answered so the user_id for that row’s column is null. Once I add the full_name to the insight, all of the rows missing a name due to the foreign key disappear (but are still included in the roll up).  I’ve referenced the how-to guide but something isn’t clicking for me how how to cater this to my call center use-case. Can anyone access my account (admin has access from prior ticket) to tell me what I may be doing wrong?  This is a stopper for our migration.

1
Moises Morales
GoodData Employee
15 days 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

840
K
GoodData Employee
1 year 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

590
K
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings