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 GoodData14
AnalyticsDashboards and Reports161 Metrics and MAQL108
Data modeling & IntegrationData models35 Data sources69
Development & AdministrationGoodData.UI38 Administration86 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Search

Replies posted by Moises Morales

179 Replies

Newest first

Oldest first

anastasie.pustovalova

asked in Dashboards and Reports

Malfunctioning data export (xls) from 100 % stacked graphs

Hello @anastasie.pustovalova, my apologies for the late reply, this fell between the cracks. I am afraid that exporting the stacked are chart this way is really not desired if you wish to get the resulting tabular report to behave the same way, this is because the data in a stacked area chart or any other chart for that matter may behave differently than a regular table depending on the way it is broken down, formatted, etc.All in all, XLSX exports work best with tabular insights, therefore, could you try creating a table insight instead and export it? Are you still having issues with the resulting export? If you wish to export a stacked area chart, it is better if you use the PDF format. -Moises

anastasie.pustovalova

asked in Dashboards and Reports

Malfunctioning data export (xls) from 100 % stacked graphs

If you wish to remove the formatting, it can be done from the insight metric format menu as specified in the documentation: https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/analytical-designer/work-with-metrics/format-numbers/#FormatNumbers-Definecustomnumberformats

anastasie.pustovalova

asked in Dashboards and Reports

Malfunctioning data export (xls) from 100 % stacked graphs

You’re welcome. Please note the insight format is also applied to the exported file.

anastasie.pustovalova

asked in Dashboards and Reports

Malfunctioning data export (xls) from 100 % stacked graphs

Hello Anastasie, Exporting a visualization in XLSX format will always show the underlying data in tabular format. If you wish to see the graph instead, you will need to place the insight in a KPI dashbaord and then export it in PDF format. More details about the export options can be found in our documentation here: https://www.gooddata.com/docs/cloud/create-dashboards/export/#pdf -Moises

kaviKnown Participant

asked in Dashboards and Reports

recover the deleted workspaces

Hello, Information about our Data Backup policy can be found in our documentation here: https://help.gooddata.com/doc/enterprise/en/expand-your-gooddata-platform/gooddata-platform-overview/data-backup/. We are able to retrieve a deleted workspace up to 44 days after its deletion date. Please note that the service is available as an addon for Growth customers. -Moises

Kyle LNew Participant

asked in Metrics and MAQL

SUM producing error in metric, but not table

Hello Kyle, Generally speaking you always have to start your metric with the SELECT statement. If you are still having issues, could you please send your metric definition over here? What is the error that you are getting? Could you also let us know the product that you are using? Is it GoodData Cloud? I also recommend taking a look at the MAQL course available for free in our University portal: GoodData University -Moises

CRowlettNew Participant

asked in Data sources

Workspace / User Data Filter Predicate Pushdown

Hello, No ETL is needed on GoodData Cloud nor do we push any changes to your data in your data source when using workspace / User Data Filters. These filters are applied “on the fly”. Are you having any issue with the implementation? -Moises

hankaKnown Participant

asked in Dashboards and Reports

Strange behaviour of filters

Hello Hanna, The "Explore from here" option will show you a preview of how the insight looks in Analytical Designer. This means that the filters you see there are the ones originally applied to it, and the filters placed in the dashboard will not appear in this preview. This is designed so that users can freely experiment with it as they see fit.Please note that when placing the insight on a dashboard, you have the option to allow the dashboard filters to affect it. You can adjust this behavior by entering "edit" mode and selecting the insight configuration menu. From this edit menu, you can also make changes to the insight itself, and these changes will be saved permanently. -Moises

erik-planeraParticipating Frequently

asked in Metrics and MAQL

Query two rows with arbitrary ids

You’re welcome. Date time diff is documented here: https://www.gooddata.com/docs/cloud/create-metrics/maql/time-arithmetics/datetime-diff/, but please note that the function only works with timestamp or date columns. In this case, I believe you should have to work with facts instead so you can calculate the difference between two periods of time and then slice it by an attribute, for example, “Project”. The filter in the dashboard should work as expected. Please note that I am not familiar with your data, but in general, this is how it works. I would recommend checking the following resource to get familiar with MAQL : https://university.gooddata.com/getting-started-with-maql. -Moises

erik-planeraParticipating Frequently

asked in Metrics and MAQL

SQL dataset query failure

Sorry to hear that, are you using a fully qualified path as exemplified in my previous comment? If so, could you please send over the new Trace ID?

erik-planeraParticipating Frequently

asked in Metrics and MAQL

Query two rows with arbitrary ids

Hi Erik, Using variables in the platform queries is not possible. You could create a standard query that would calculate the time diff for all projects, then add it to a dashboard via an insight and use a dashboard filter for the project attribute so the user can select either and then the insight will show the corresponding value. More details about attribute filters can be found in our documentation here: https://www.gooddata.com/docs/cloud/create-dashboards/attribute-filters-dashboards/. -Moises

erik-planeraParticipating Frequently

asked in Metrics and MAQL

SQL dataset query failure

Hi Erik, The query is failing because the table “organizations” cannot be found. Note that data source managers (Drill and Dremio) utilize multi-element paths to database objects, requiring the use of fully qualified paths when creating SQL-based datasets. For example: SELECT employee_id, employee_nameFROM dremio_default.public.employee_table; -Moises

secutechNew Participant

asked in Metrics and MAQL

metric

Hello, if the MAQL query logic is correct, then you could create a new query to make the arithmetic operations. For example, SELECT (SELECT new_metric * 0.75) * 177. I believe you are correct by using THIS, although you may need to define it as THIS - 260 days to count the previous 261 days. Also, please note that the THIS macro will work in the context of the date dimension you define in the metric, in your example I see you are using Week, but you should be working with days instead. Could you please try adjusting your metric? If this does not help, please let us know the new error you are getting. -Moises

Ondrej HynesNew Participant

asked in Administration

Link to selected dashbard for OAuth2 autorization

Hi Ondrej, This would need to be set on your OIDC provider settings when configuring the redirection URIs. For example, see: Using OAuth 2.0 for Web Server Applications | Authorization | Google for Developers, https://www.googlecloudcommunity.com/gc/Apigee/multiple-callback-URI-for-OAuth2/td-p/176489I hope this helps. -Moises

MarketaParticipating Frequently

asked in Dashboards and Reports

Reached limit of max size of data returned from database

The error is commonly caused by queries returning too much data, exceeding the GoodData Cloud Limits. They could be related to the Cache issues as well, but I would start by checking that none of the limits are being breached. I would also advise checking on Improving Database Performance as needed. -Moises

giripurnamaNew Participant

asked in Data sources

How to get data from database Gooddata.CN

Hi Giripurnama, If you are unable to list the tables, then I would start by checking your user access rights. For example, for Bigquery you have to configure them as stated in our documentation: Create a Google BigQuery Data Source | GoodData Cloud You can find a guide for the other data sources in our documentation here: Create Data Sources | GoodData Cloud Also, please make sure that you have specified the correct Schema. Thanks, -Moises

Jan RehanekGoodData Employee

published in Administration - KB articles

Getting started with SSOTutorial

SAML and PGP SSO authentication methods are not supported on GoodData Cloud, but you can configure instead your OIDC provider as covered in this article:

Andres SuttonNew Participant

asked in Metrics and MAQL

Calculate when an invoice is due

It's unfortunately not possible to convert this number to date formatting. We usually recommend using this number for date arithmetic in order to analyze, for example, the duration between two events. I'm sorry that this wasn't the answer you were hoping for.

Andres SuttonNew Participant

asked in Metrics and MAQL

Calculate when an invoice is due

Hi Andres, Could you please send your metric so I can review it?Thanks, -Moises

SmullerNew Participant

asked in Dashboards and Reports

Freeze column or row

I understand this would be ideal as well. Let me highlight this internally so we can consider freezing a column or row in tabular insights in our product improvements. Thank you for bringing this to our attention. -Moises

SmullerNew Participant

asked in Dashboards and Reports

Freeze column or row

I see you are working with KPI dashboards. This is not possible at the moment, but depending on the metrics you are working with, it may be useful if you switch the metrics to the rows instead of the columns.-Moises

umernasirrKnown Participant

asked in Administration

GoodData.CN and Auth0 silent login not working

I see you are following a tutorial for GoodData CN, but in our records it shows that you are working with GoodData Cloud, while the two products share many of the features, what you are trying to implement here may not be possible in GoodData Cloud. Could you please confirm first which product are you using so we can provide further guidance? Thanks. -Moises

Luis CarricoNew Participant

asked in Administration

Users Brick - "Cannot reach url" error

Hi Luis, the “cannot reach url” error usually implies there is a misconfiguration in the resource the brick is trying to query the data from. Are you using any kind of white listing by any chance or did anything change recently in your data base settings? I would advise checking your user access rights and IP whitelisting settings. You can find more details in this documentation: GoodData IP Addresses and IP Whitelisting | GoodData Free. If you are still having issues, feel free to send the error / request ID from the log. -Moises

Thiago Vivian RibeiroNew Participant

asked in Metrics and MAQL

Help with RUNSUM

Thanks for clarifying. Unfortunately I must repeat the same answer provided previously. It's unfortunately not possible to use the runsum metric on a non date attribute, it's only possible if you have a table and you right click on the attribute, This is because a running sum can only be calculated along a date attribute (e.g. running sum of revenue to create a MTD). I recommend creating the new metric based on this.

Thiago Vivian RibeiroNew Participant

asked in Metrics and MAQL

Help with RUNSUM

I see you are working with our Pixel Perfect UI, in that case you can simply right click the %REP column and get the running sum of it as shown below. You can also rename the new column.

1
2
3
4
...
8

Page 1 / 8

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 E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

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