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 MAQL106
Data modeling & IntegrationData models35 Data sources68
Development & AdministrationGoodData.UI38 Administration86 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Search

Solved

40 Topics

Recently active

Most views Most replies

Douglas PaivaNew Participant

asked in About GoodData

Workspaces migration to GoodData from different domain

Hello community!I would like you to help me with a question... We use GoodData with one URL (domain), but due to the migration we are making to the infrastructure of the company that acquired us, we need to migrate to GoodData with a different URL. Would it be possible to migrate the Workspaces / Dashboards to the new URL?

Mark PetersonNew Participant

asked in Dashboards and Reports

Changing Start of Week to Monday

Has anyone successfully changed the Start of Week in Insights and Dashboards to reflect a Mon-Sun week instead of the default Sun-Sat. I’ve updated the two configuration settings and the user account setting (as per article below) to reflect Monday as the start Day but all insights insist on staying as Sun-Sat.https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/change-date-format/

MarketaParticipating Frequently

asked in Metrics and MAQL

Diff between Start Date and End Data

Hi, I am trying to do a diff between end and start date, I am trying this formula in metric: SELECT SUM(SELECT DATETIME_DIFF({label/startdate2.day}, {label/enddate2.day}) BY {dataset/flights}), and it doesnt show any error, but when I am trying to visualize, I am getting error trace: d9781182e7f70bd623d858893b240c73 { "title": "Bad Request", "status": 400, "detail": "A result cache error has occurred during the calculation of the result", "resultId": "db07993fb7512eae09bf975606466e10c948704c", "reason": "General error", "traceId": "d9781182e7f70bd623d858893b240c73"}

erik-planeraParticipating Frequently

asked in Administration

Workspace limits

Hello, is there a limit on the number of workspaces allowed?

apalliniNew Participant

asked in Metrics and MAQL

Sum all table values in the row

Hi all, I am trying to get the Budget Sum in my row, but until now withour success. Essentially, based on the picture, I would like to see the SUM of the column Budget on each row. I tried SELECT SUM(Budget) and SELECT RUNSUM(Budget) but I only receive the row value and not the total of all rows.. Any suggestion? Thank you,Andrea

kaviKnown Participant

asked in Metrics and MAQL

Existing Metrics are not working

Hi, My current project is to create a unified workspace—a single workspace used by several clients. I had the opportunity to upgrade the current data model to include a new primary key in gooddata during that procedure. I noticed that some of the current metrics are not functioning and are displaying an error as I have given below after updating the data model.It would be more helpful if I get the quick and valuable response. Thanks,Kavi

kaviKnown Participant

asked in Data sources

Failures in CSV Downloader

Hi, After 5th of this month we have noticed schedules which are using XLSX format files as source are failing in CSV Downloader. Is this due to the release End of Life: CSV UploaderRef; https://support.gooddata.com/hc/en-us/articles/21503229759763-GoodData-Platform-October-5-2023 Thanks,Kavi

kaviKnown Participant

asked in Dashboards and Reports

Distribute the locked visuals from development master workspace to all the client workspaces

Hi,We are using LCM technology in our system.We have locked the some visuals that are designed in analyze tab in development master workspace. Now I’m able to distribute the visuals to all the client workspaces but unable to lock them in client workspaces using LCM(even after running release and rollout bricks). Is there any settings to enable this option? If yes, can you please provide the supporting documents.Kindly help me out on this. Thanks,Kavi

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

How to apply the column in insight only for single facts in the metrics

Hello, i am creating an insight where the ‘year(Reporteddate)’ in the columns has to be applied only for the ‘Sum of Claims Opened’ in the metrics as shown in the attachment.How to do that?

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

Order by in Bar chart in Good data

Hello, please do let me know how to sort the month values in descending order in bar chart Thank you

kmcdavidNew Participant

asked in Metrics and MAQL

Calculating Days Open/days past due

I’m trying to build metrics for days open and days past due. I tried following a similar thread however, its not working quite right. I used the following to calculate days open and I was able to create a report but it did not filter out any completed processes and I was unable to filter the results at all.Similarly I tried to follow the thread for days past due, creating the metric below, but when trying to create a report for it, it said I couldn’t because it would create nonsensical results. Am I missing something or is this not possible to do?

AdamVNew Participant

asked in Dashboards and Reports

Insight aggregation by week

Hi all,I'm trying to aggregate an insight by weeks. When I move the relevant date to the X-axis, it only offers aggregate by week (Sun-Sat), not the week (Mon-Sun) option. See the attached print screen.I changed my settings to have Monday as the first day of week. But still no luck.Where can I change the weeks starting on Monday for individual insights?Thanks!Adam

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

INSIGHT design in the image

Hello, i have a reference insight and i don’t know how the ‘Policy Count - SP year ago’ in the metrics are calculated and why the same column is unchangeable as in to view the calculations done for the same column.Please do help me to solve this issue to create a same insight in another workspace and consider the attached image too!! Thank you

SasalMarconParticipating Frequently

asked in SDKs and APIs

It is made mandatory to include User-Agent header as mentioned in documentation. What is the general header admin mentioned in documention?

I want to automate the process in gooddata using API in node js . It is mentioned that its mandatory to include User-Agent header and I want to use general Admin Header . What is general admin header?

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

How to add more than 20 rows in Good Data Insight??

Hello, I am creating an insight which has more than 30 columns and i have to display all the columns in the insight but Good Data Application is letting me add only 20 columns as shown in the attachment.can you please let me know how to add all the 30+ columns in the insight in Good DataThank you

LenaKnown Participant

asked in Metrics and MAQL

How can I custom a attribute or metric in Date format?

Hi,I want to get the latest Date group by a attribute in mm/dd/yyyy format.My code is :select MAX(Date (Ticket Created Date)) BY EntityIDAnd I edit “Metric format” to “mm/dd/yyyy” format, but it doesn’t work.Do you have any better idea?Thanks for your help!

nathanliuParticipating Frequently

asked in Dashboards and Reports

Text Selection?

Hi, not sure if this is just me, but I am unable to select text in tables that are on dashboards. If I edit the insight, I can select text but cannot directly from the dashboard. We use this a lot for selecting session ids, is this a bug or feature?

tylervaleoNew Participant

asked in Dashboards and Reports

Can we Sum or RunSUM based for columns in a table?

I’m trying to replicate a report, and would rather not create a metric for the SUM of 4 metrics I created if there is a sum feature I can use for each column that is built in. Not sure if there is a way to SUM the columns like there is with SUMing the Rows as shown below: Any help is always apprecaited!

nisujju1987New Participant

asked in Dashboards and Reports

Dashboard embedding via iframe and prefiltering data

Hi,We are trying to embed the dashboard via iframe and trying to attempt the pre filtering when fetching it but its still not clear how this should be done. Below steps was followed. Can you please check and let us know if something wrong was done.We have a Test dashboard which has different customer region(attribute) as you can see in first image. Aim is to get iframe/url of the dashboard prefiltered with data of only South region. For this we set the tag on the Customer Region with tag value as south which can be seen in second image. After this we use the includeObjectsWithTags=[south] in embedded url link to get the dashboard with prefiltered south region data only but this didn’t worked. Here is the detailed link https://nitesh.on.gooddata.com/dashboards/embedded/#/workspace/c1o9hnzy7lwdckb8h6hhmc9pzkdm8nip/da[…]ue&includeObjectsWithTags=[south]&setHeight=700Can you please suggest us what we could be doing wrong here and how this could be achieved? Please let me know if yo

MashaKnown Participant

asked in Dashboards and Reports

KPI alerts

Hello, could you please let me know if it’s only possible to create KPI alerts based on metrics that are being calculated within GD and exist as metrics? Here’s an example - let’s say I want to track open to visit rate (O/V) as well as raw visits number. Can I create KPIs and alerts for both or only or O/V? If i cannot create a KPI and alert for such raw metric as visits, is there any way in GD I can track it and be alerted if that number falls/raises?Thank you!

Samantha ZhangNew Participant

asked in Dashboards and Reports

Deleting a record in dataset

I am trying to delete 1 record and I have run into some problem. When trying to delete a record in the Spending dataset where the order no is = 2021_6734. According to the documentation the query should look something like this to delete the facts:https://help.gooddata.com/pages/viewpage.action?pageId=86796761 DELETE FROM {attr.spending.factsof} WHERE {attr.spending.no} = "2021_6734";When I am running the delete statement I am getting the following error: "error" : {"component" : "DJG","errorClass" : "GDC::Exception::User","message" : "Object \"%s\" doesn't exist.","parameters" : ["attr.spending.factsof"],"requestId" : "hjUDGKYxIf3OuhS:7txqnamxk997mgy0"}} Which object does not exist? I am not sure what the issue is there?

jeferson.nunesParticipating Frequently

asked in Dashboards and Reports

Error copying a tab to a new dashboard

Good Morning!!Yesterday I started getting this error when trying to copy a tab to a new dashboard.I couldn't identify the problem as it was working normally before. Could you let me know what could be happening?Thanks for the help!

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).

resihunterNew Participant

asked in Dashboards and Reports

How to Group on Table

I need to group by state exactly like this. How do I make a table report look like this? When it expands, all the addresses are displayed.

lizaNew Participant

asked in Metrics and MAQL

Can I join data from different tables by date?

Good afternoon!I am trying to build Net Revenue metric. Net Revenue = Gross Revenue - Margin*Gallons where Gross revenue and gallons are not connected in LDM directly. Can I build a table with columns Date, Gross Revenue, Gallons utilizing MAQL? So that amounts are joined together based on the date?I could add Gallons to Gross Revenue at the data transformation step but would like to know if there is a way to construct such table w/o altering data sources.

1
2

Page 1 / 2

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