To GoodData homepage

Knowledge base
AnalyticsDashboards and Reports - KB articles8 Metrics and MAQL - KB articles23
Data modeling & IntegrationData models - KB articles9 Data sources - KB articles9
Development & AdministrationGoodData.UI - KB articles12 Administration - KB articles18 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData13
AnalyticsDashboards and Reports161 Metrics and MAQL107
Data modeling & IntegrationData models35 Data sources69
Development & AdministrationGoodData.UI38 Administration86 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Search

Replies posted by Vasiliy Ostrovsky

18 Replies

Newest first

Oldest first

Vasiliy OstrovskyKnown Participant

asked in Metrics and MAQL

Some metrics don't work

The metric 1 and metric 2 work aloneBut they don’t work when being put on the same insight The metrics composed in this ways don’t work either: SELECT ({metric/metric_hired} / {metric/metric_total})SELECT TRUNC({metric/metric_hired} / {metric/metric_total}, 4)SELECT TRUNC({metric/metric_hired}, 4) / TRUNC({metric/metric_total}, 4)SELECT(SELECT COUNT({attribute/v_gd_recruiting_ratio.job_posting_candidate_id}) WHERE {label/v_gd_recruiting_ratio.application_status} = "Hired")/(SELECT COUNT({attribute/v_gd_recruiting_ratio.job_posting_candidate_id}) WHERE {label/v_gd_recruiting_ratio.application_status} IN ("Rejected", "Contacted", "Interviewing", "New Applicant", "Offered", "Hired", "Knockout Rejection"))

Vasiliy OstrovskyKnown Participant

asked in Metrics and MAQL

Some metrics don't work

Hi UlkuCould you please also give us an advice how to make this query work?SELECT(SELECT COUNT({attribute/dshb_recruiting_ratio.job_posting_candidate_id}) WHERE {label/dshb_recruiting_ratio.application_status} = "Hired")/COUNT({attribute/dshb_recruiting_ratio.job_posting_candidate_id})Now it doesn’t work

A

Anonymous

published in Metrics and MAQL - KB articles

GoodData.CN: Metrics Management 101

Hi! I’m trying to calculate ratio of sums via API. I have two Sum metrics without names or aliases. Is it possible to assign name to metrics?Then I send this POST request with MAQL: script "SELECT {metric/Sum of Hire amount} / ({metric/Sum of Term amount})" And get the response: "detail": "Some of given referenced 'metrics' entities do not exist.Not existing IDs: StockId(apiId=Sum of Hire amount, scope=WorkspaceObjectScope(organization=default, space=daceb3e88abd4bd5a7af036e9876a837)), StockId(apiId=Sum of Term amount, scope=WorkspaceObjectScope(organization=default, space=daceb3e88abd4bd5a7af036e9876a837))", "status": 400, "title": "Bad Request", "traceId": "750ad93f87abe878"Please, help me to get the desired result.

A

Anonymous

published in Metrics and MAQL - KB articles

GoodData.CN: Metrics Management 101

I’m still getting emply metrics list by running commandC:\Users\vostrovsky>curl -H "Authorization: Bearer YWRtaW46Ym9vdHN0cmFwOmFkbWluMTIz" -X GET https://gooddata-dev.criterionhcm.com/api/entities/workspaces/daceb3e88abd4bd5a7af036e9876a837/metrics{"data":[],"links":{"self":"http://localhost:3000/api/entities/workspaces/daceb3e88abd4bd5a7af036e9876a837/metrics?page=0&size=20","next":"http://localhost:3000/api/entities/workspaces/daceb3e88abd4bd5a7af036e9876a837/metrics?page=1&size=20"}}

A

Anonymous

published in Metrics and MAQL - KB articles

GoodData.CN: Metrics Management 101

What should be the proper MAQL query for the statement including metrics named ‘is_on_cycle’, ‘is_off_cycle’ : SUM(is_off_cycle)/(SUM(is_off_cycle) + SUM(is_on_cycle))?

A

Anonymous

published in Metrics and MAQL - KB articles

GoodData.CN: Metrics Management 101

Hi @Vasiliy Ostrovsky, For headline insights, the selected measure must be defined in the measures list. To accomplish this, your suggested method of creating a new measure via API will work! As for the curl command, could you try something like this instead: curl https://gooddata-dev.criterionhcm.com/api/entities/workspaces/daceb3e88abd4bd5a7af036e9876a837/metrics \ -H "Authorization: Bearer YWRtaW46Ym9vdHN0cmFwOmFkbWluMTIz" -H "Content-Type: application/vnd.gooddata.api+json" \ -H "Accept: application/vnd.gooddata.api+json" \ -X POST \ -d '{ "data": { "id": "metric_test", "type": "metric", "attributes": { "title": "Metric Test", "description": "", "content": { "format": "#,##0", "maql": "SELECT SUM({fact/order_lines.quantity}" } } }}' I believe your posted command is missing some required entities like the request body. Hope this helps! Sheila I got this by running your command

A

Anonymous

published in Metrics and MAQL - KB articles

GoodData.CN: Metrics Management 101

Why do I receive empty data sending this request?curl -H "Authorization: Bearer YWRtaW46Ym9vdHN0cmFwOmFkbWluMTIz" https://gooddata-dev.criterionhcm.com/api/entities/workspaces/daceb3e88abd4bd5a7af036e9876a837/metrics \

A

Anonymous

published in Metrics and MAQL - KB articles

GoodData.CN: Metrics Management 101

Thank you, Sheila! And do I need to know measures IDs in order to perform simple calculation?In fact I need to show value of M1/(M1+M2) as a headline (not within a table). Should I use the API request or is there a more simple way?

Vasiliy OstrovskyKnown Participant

asked in Dashboards and Reports

Incorrect filtering of running sums

Hi Vasiliy, Just under your two metrics, there is "+" button for creation of Calculated measure: There you can select a "Ratio" calculation of your two metrics: More complex measures would require certain knowledge of MAQL and such measures can be built via API, as mentioned by Michael before. You can find some examples here and you can also check this article below: Thank you, Iva!I calculated desired measure (0.54 in the example below) but I need to show only this amount as headline (not within table). How is it possible to do?

A

Anonymous

published in Metrics and MAQL - KB articles

GoodData.CN: Metrics Management 101

How looks full POST request for adding this metric?"data": { "id": "revenue_lost", "type": "metric", "attributes": { "title": "Revenue Lost", "description": "", "content": { "format": "$#,##0", "maql": "SELECT {metric/order_amount} WHERE {label/order_lines.order_status} in (\"Canceled\",\"Returned\")" } } }

Vasiliy OstrovskyKnown Participant

asked in Dashboards and Reports

Incorrect filtering of running sums

Hi!Could you please provide me an example or tutorial how can I calculate division of these two metrics using GoodData.CN?

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

Insight can’t get data from successfully published dataset. We are also encountering UI issues.

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

HiI’m still encoutering problems with insights.The dashboard https://gooddata-dev.criterionhcm.com/dashboards/#/project/daceb3e88abd4bd5a7af036e9876a837/dashboard/dbec2742-0423-498a-979d-5af79037c52c shows the items partiallyAnd if I try to open an insight for editingI get this error

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

But I still can’t see them on the dashboard Hi Vasiliy, Isn’t it possible that you don’t have any data for this month (that started today)? By default the insights and KPIs on Dashboard are filtered by date filter if you did not explicitly disconnected them in the dashboard widget configuration. How can I explicitly disconnect default filtering by date in the dashboard widget configuration?

NickKKnown Participant

posted in Dashboards and Reports

GoodData.CN Internal Server Error

Hi DanielaI removed unused datasets here https://gooddata-dev.criterionhcm.com/dashboards/#/project/daceb3e88abd4bd5a7af036e9876a837/dashboard/dbec2742-0423-498a-979d-5af79037c52cNow I can see the mesures in Analyze tab But I still can’t see them on the dashboard

Vasiliy OstrovskyKnown Participant

asked in Dashboards and Reports

Incorrect filtering of running sums

Hi Vasiliy, please see the following article which will guide you though creating metrics:https://help.gooddata.com/pages/viewpage.action?pageId=86788051 Best regards, M. Ullock I’m using GoodData.CN. Is the Custom Metric Editor available for GoodData.CN?

Vasiliy OstrovskyKnown Participant

asked in Dashboards and Reports

Incorrect filtering of running sums

Hi Vasiliy, please see the following article which will guide you though creating metrics:https://help.gooddata.com/pages/viewpage.action?pageId=86788051 Best regards, M. Ullock Why can’t I see the Manage tab in my interface?

Vasiliy OstrovskyKnown Participant

asked in Dashboards and Reports

Incorrect filtering of running sums

Hi Vasiliy, this is actually the expected behaviour and is working as designed. If you would like show the complete total - As in your use-case "1327", your metric would look like this: SELECT RUNSUM (<Your-Fact>) WITHOUT PF Here is some additional articles that you may find useful:https://help.gooddata.com/pages/viewpage.action?pageId=86795471https://help.gooddata.com/pages/viewpage.action?pageId=86795498 Regards, M. Ullock Where should I write this query here? SELECT RUNSUM (<Your-Fact>) WITHOUT PF

Powered by Gainsight

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

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