To GoodData homepage

Replies posted by Petr Olmer

7 Replies

K
Keith FinnNew Participant
asked in Administration

Can I use my own hostname for GoodData?

@NickK — GoodData.CN is something you deploy and manage, so there’s no reason for us to interfere with your hostname. 

7
N
3 years ago
K
Keith FinnNew Participant
asked in Administration

Can I use my own hostname for GoodData?

Nick - to quickly clarify, the original question & answer (posted 9 months ago) is about our hosted platform where by default you run it on a subdomain of gooddata.com but can white label it (as an add-on). You are very much correct this would not make sense with GoodData.CN!

7
N
3 years ago
A
AshleighNew Participant
asked in Metrics and MAQL

Difficulty creating new MAQL metric based on Customer Segment

Hi @Ashleigh,You need to first identify all the customers that have at least one “New” order and then to sum all their orders. Here’s the metric:SELECT SUM(Amount) WHERE (SELECT COUNT(Order Id) BY Customer Id WHERE Customer Type = New) > 0Please note “New” has to be selected from the Attribute Values, so it will show up as orange like here: 

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

Struggling with MAQL (aggregation and filtering)

Hi @Allan Talver,The WITHOUT PF needs to be applied to the outer MAX metric as well. Your metric should work when you move it at the very end of the metric:SELECT MAX(SELECT SUM(Workdays) BY Employee) BY Company ALL OTHER WITHOUT PF EXCEPT Date (Worked Date)Depending on your exact model, you may need to include the Company in your report. Another solution (if you don’t have holiday calendars) can be to count working days as days where at least one Employee from the company was working (something like SELECT COUNT(Date (Worked Date)) BY Company, Date (Worked Date), ALL OTHER WHERE (SELECT SUM(Workdays)) > 0).

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

Results locked by attribute

Hi @Manu Meic,You have to create a custom metric and use the BY ALL statement.If the metric returning 3 and 2 looks like SELECT SUM(Sales), the metric returning 5 would be SELECT SUM(Sales) BY ALL Store. 

1
Petr Olmer
GoodData Employee
3 years ago
T
tramtbtranNew Participant
asked in Data models

Why do some items disappear from Data Catalog?

Hi @tramtbtran – it’s helpful to watch the arrows between the datasets. For example, when I put “Approver” to a new insight, I can use “Status DIQ”, “Invoice No”, or “Markup Amount” in the same insight. The arrow goes from Approver to Markup Amount, so I can slice Markup Amount by Approver.However, when I use “Status DIQ”, I cannot slice it by “Category Name”, so “Category name” becomes hidden. In the same way, when I use “Category Name”, “Status DIQ” is not available.See Understanding the Logical Data Model, chapter “Reading the model”, for more examples.

1
Petr Olmer
GoodData Employee
3 years ago
L
GoodData Employee
Leilani GreerGoodData Employee
asked in Data models

Programatically building the LDM

You can also use Ruby SDK to create your model programmatically. There are functions like add_dataset, add_fact, etc. The function blueprint reads LDM from an existing workspace so you can modify it and post it back. See https://sdk.gooddata.com/gooddata-ruby-doc/docs/creating_project_from_blueprint.html

2
Petr Olmer
GoodData Employee
3 years ago
Welcome to the GoodData Community!Cookie settings