To GoodData homepage

Metrics and MAQL

Metrics and MAQL

  • 86 Topics
  • 267 Replies

86 Topics

A
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 ‘£

3
A
2 years ago
A
Allan TalverNew Participant
asked in Metrics and MAQL

Struggling with MAQL (aggregation and filtering)

Hello,I have:A fact named Workday (values 1 and 0). The dimensions attached to the fact: Company, Employee, Date. Companies are essentially our subsidiaries in different countries where different holidays are applicable, resulting in differences in maximum available Workdays.In my report I want to see metrics:A: the number of Workdays per Employee in a selected time period B: number of MAX Workdays any Employee had in the sae Company and in the same time period (basically how many workdays were available if a specific employee had worked on all possible days) C: % of A/BI am struggling to create a metric for B where I want to find the maximum number of Workdays any Employee in the same Company had within a chosen time period.The closest to what I need is when I define the metric B as follows:SELECT MAX(SELECT SUM(Workdays) BY Employee WITHOUT PF EXCEPT Date (Worked Date)) BY Company ALL OTHERHowever, as soon as I filter the report for any subgroup (specific employee, team, etc.) the

1
Petr Olmer
GoodData Employee
2 years ago
M
Manu MeicNew Participant
asked in Metrics and MAQL

Results locked by attribute

Hello! I’m having a problem trying to lock the agregation level in a result. I have a report showing : store, articule, sales and stock. I need that the sales metric doesn’t change despite the store.For example: if one articule had 3 sales in one store and 2 sales in other one, the report should show 5 sales no mather what store I am looking. 

1
Petr Olmer
GoodData Employee
2 years ago
D
dudoffNew Participant
asked in Metrics and MAQL

How do I create a metric with I am trying to count records that have a NULL value

Hi I have a fact that can be Null at times.I can count the records where it is not nullselect count(attribute) where fact > 0.I am trying to count the amount of records that are null.I do not see anything in the MAQL guide for that. Is there a way?I tried fact = 0 even know I know null is not 0.I tried fact <=0 Neither worked.  

1
Iva Gasparekova
GoodData Employee
2 years ago
S
suseteNew Participant
asked in Metrics and MAQL

How to get data from a specific table not in a child table? For example, all Users without any Skill?

How to get data from a specific table not in a child table? For example, all Users without any Skill?

1
Michael Ullock
GoodData Employee
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Cannot pull multiple Date dimensions into one Insight

Here is my Logical Data Model:For each WorkOrder have Ticket Created Date, Wo Created Date,… dimensions, when I add Ticket Created Date dimension then I can not use  Wo Created Date or others in the same insight. I have to work around that I created a view to convert other Dates to text to display on the report (Ticket Created Date Text, Wo Created Date text,...).Do we have any solution or better ways of this? Please help me.Thank you so much!

4
L
2 years ago
S
Simone HaasNew Participant
asked in Metrics and MAQL

Calculating how many days are invoices past due

Hello there. I uploaded our invoice data into GoodData and I would like to create a report where I will see how many days are open invoices past due. I do not have this number in my source data, I have just due date. Is it possible to calculate it? Thank you. Simone

2
S
2 years ago
J
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 

2
Pavel
2 years ago
L
GoodData Employee
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 ?

2
Pavel
2 years ago
K
Keith FinnNew Participant
asked in Metrics and MAQL

Metric visibility

My colleague created a metric, but I can't find it. Any idea why?

1
Iva Gasparekova
GoodData Employee
2 years ago
M
Mason PriceNew Participant
asked in Metrics and MAQL

How to create reusable MAQL metrics/measures for Analytical Designer?

I would like to create some reusable MAQL metrics/measures using my data, but there are just very basic aggregations available in the Analytical designer. How can I use MAQL in there and make the metric/measure reusable?

1
Martin Burian
Community Manager
2 years ago
Welcome to the GoodData Community!Cookie settings