To GoodData homepage

Solved

512 Topics

deedeedudu
deedeeduduNew Participant
asked in Metrics and MAQL

Metric with BY ALL condition is not working properly

Hi,I created a metric as following:SELECT SUM(Contacts)/ (SELECT SUM(Contacts) BY ALL Country)I have data like followingCountry Contacts Brazil 20 NULL 30   30 Argentina 20  and other countriesI then select a filter to show Top 10 and in another filter i de-select (empty value) as i don’t want to show them in the Top 10 report but instead of giving % for Brazil as 20% (20/100), it would give 50% (20/40)

2
deedeedudu
24 days ago
D
dluParticipating Frequently
asked in Administration

How to verify GoodData.CN installation on AWS EKS?

Hi. We are evaluating the possibility of hosting GoodData.CN on AWS EKS ourselves. I have tried to follow the instructions on https://www.gooddata.com/docs/cloud-native/3.3/deploy-and-install/cloud-native/ as close as I can, while deviating “a little” when it did not work.I have tried the simple cases without many things in https://www.gooddata.com/docs/cloud-native/3.3/deploy-and-install/cloud-native/considerations/, like DNS or TLS configurations. I am trying to get a simple case working and then possibly adding those considerations later.Here are my stepsCreated an AWS EKS cluster Kubernetes 1.28 4 AvailabilityZones 6 t3.large instances Installed Kubernetes Dashboard Installed AWS Load Balancer Controller following instructions on https://docs.aws.amazon.com/eks/latest/userguide/aws-load-balancer-controller.html. Verified by installing https://raw.githubusercontent.com/kubernetes-sigs/aws-load-balancer-controller/v2.7.1/docs/examples/2048/2048_full.yaml For Nginx Ingress Controll

22
D
2 months ago
T
tomashochKnown Participant
asked in Dashboards and Reports

Hide irrelevant values in dependent filters on dashboards

Dear Community,first, I would like to mention that we are really happy with recent feature - dependent filters. However, we would need to use in combination with User Data Filter (UDF).Here is our use-case:We have two dimensional datasets:Product Product GroupOne Product Group can have many Products, (1:N relationship). We need to limit Products for each user in entire workspace. We use User Data Filter for that and filter specific list of Products for each user (user group). Here is the issue:When we use both dimensions - Product, Product Group, as filters on dashboard a set them as dependent filters between each other then user can see only subset of Products based on the UDF. That’s great and desired behaviour. However, user still can see all Product Groups unless he select any Product. We want to display only these Product Groups in filter, which contains available Products based on the Products defined in UDF.Is it possible? Only option we can see right now is also limit Product G

2
Joseph Heun
GoodData Employee
3 months ago
Douglas Paiva
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?

1
Michael Ullock
GoodData Employee
3 months ago
CRowlett
CRowlettNew Participant
asked in Data sources

Workspace / User Data Filter Predicate Pushdown

Hi GoodData Community --With regard to Workspace / User Data Filters, it’s not clear to me where this filtering takes place.  Are these predicates pushed down to the underlying data source or does the SQL execution engine perform this filtering after retrieval?

3
Iva Gasparekova
GoodData Employee
3 months ago
hanka
hankaKnown Participant
asked in Dashboards and Reports

Strange behaviour of filters

Hi,When I’m following `Explore from here` option on the dashboard, I don’t see the original insight but instead it seems that it’s a copy of it, as it’s untitled. What’s strange, it uses additional filters that the original insight does not have.Also, when editing the dashboard I go the insights configuration, I can see those obsolete filters listed there and I’m able to check or uncheck them.Where those ghost filters are coming from? What can be done to get rid of them? Best,Hanna

1
Moises Morales
GoodData Employee
4 months ago
M
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/ 

1
Michael Ullock
GoodData Employee
4 months ago
ashok
ashokKnown Participant
asked in Administration

Issue with Upgrading GoodData.CN from Version 2.3.2 to 2.4.0

Dear GDCN Team,I am writing to report an issue with upgrading our GoodData.CN instance from version 2.3.2 to the latest version, 2.4.0.Issue Details:- Current Version: GoodData.CN 2.3.2- Desired Version: GoodData.CN 2.4.0Problem Description:I have attempted to perform the upgrade from GoodData.CN version 2.3.2 to 2.4.0 using the provided upgrade instructions. However, we have encountered unexpected errors during the Apache Pulsar upgrade process, preventing us from successfully completing the update.Error screenshot:  Important Note:Initial troubleshooting has been done over Slack with Robert Moucha; however, the issue remains persistent.Steps Taken:- Updated the kubectl and Helm.- Ran a Helm package to detect the K8s PDB API’s provided by RobertEnvironment Details:- Environment Type:EKS / K8s - 1.24 Thank you for your prompt attention to this matter. We appreciate your assistance in resolving this issue and look forward to a swift resolution Best regards,Ashok

5
ashok
4 months ago
M
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"}

4
M
4 months ago
erik-planera
erik-planeraParticipating Frequently
asked in Data sources

Mongo in embedded analytics?

Hello, I see documentation indicating support for Mongo BI connector. However, I cannot see a way to add that as a data source. How can I configure it?This is specifically for embedded analytics.Thanks,Erik

5
Julius Kos
GoodData Employee
4 months ago
erik-planera
erik-planeraParticipating Frequently
asked in Metrics and MAQL

Query two rows with arbitrary ids

Hello -I am trying to figure out if it is possible in an Insight to do math against two arbitrary rows in a dataset. Say for instance I have a “projects” dataset and I want to do a time diff of project create time(date) against two projects selectable by a user. We would need a dropdown to pick two different ids from a list to compare against. We can’t use a filter with two selections in, because the math would be backwards depending on order (if it was even possible to do it).I could write a SQL query to do this, but it requires two variables to be passed in.Thanks

3
Moises Morales
GoodData Employee
4 months ago
erik-planera
erik-planeraParticipating Frequently
asked in Metrics and MAQL

SQL dataset query failure

Hello - I am trying to get SQL datasets to work, but every query I try returns a failure. In this case here, I even tried converting an existing (working) dataset to SQL, and that fails as well. 

3
Moises Morales
GoodData Employee
4 months ago
secutech
secutechNew Participant
asked in Metrics and MAQL

metric

HelloI want to revise my MAQL query so that it counts only 75% of the allocations and then multiplies that number by $177. For example I want the 75% of the 2088 hrs (2088hrs is 261 days) but it want to count only 75% which is 1566hrs * $ 177.How the query should look like  

1
Moises Morales
GoodData Employee
5 months ago
erik-planera
erik-planeraParticipating Frequently
asked in Administration

Workspace limits

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

4
erik-planera
5 months ago
A
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

1
Michael Ullock
GoodData Employee
5 months ago
P
Preetham ThangammaKnown Participant
asked in About GoodData

Regarding the insight changes

Hello,In the attached image, initially the IS4W-Earned Premium was set to 'IS4W' category but now when I check, it is set to 'NONE' in the insight. How is that possible? Same thing happened last month as well, and I changed it to 'IS4W' category. And all the users have viewer permission except me.Only I am the admin. Please let me know the solution as soon as possible.

1
Joseph Heun
GoodData Employee
5 months ago
M
MarketaParticipating Frequently
asked in Dashboards and Reports

Nemožnost vybrat proměnnou pokud nastavena jako "123" jako Metriku, lze pouze při jejím nastavení jako "ABC"

Mám dotaz ohledně sledování impressions v GoodData. V současné době dokážu dohledat proměnou impressions pouze v případě, že jsou nastaveny jako typ "ABC". Pokud je nastavím jako typ "123", nejsem schopna je dohledat. Nicméně, potřebovala bych je nastavit jako typ "1234", abych mohla analyzovat data uvnitř nich - konkrétně, abych mohla počítat čísla uvnitř těchto impressions, nikoli pouze jejich celkový počet. Je možné toto nastavení nějak provést?

6
M
5 months ago
P
Preetham ThangammaKnown Participant
asked in Metrics and MAQL

How to display from 1 to 10 in the order which is an attribute column?

Hi,   Please let me know how to display from 1 to 10 in the correct order because in the attachment 10 is displaying after 1 which is incorrect. And this is an attribute column. Thank You

5
Iva Gasparekova
GoodData Employee
5 months ago
Ondrej Hynes
Ondrej HynesNew Participant
asked in Administration

Link to selected dashbard for OAuth2 autorization

Hi guys,Is there an option to link user directly into selected dashboard and skip https:\\xxx.cloud.gooddata.com/workspaces in case of OAuth2 autorization?The problem is, that callback url is set to: https://<organization-hostname>/login/oauth2/code/<organization-hostname> from my point of vew.But maybe it can be set up on different level.Thanks for your help.

1
Moises Morales
GoodData Employee
5 months ago
G
Guillaume LavergneNew Participant
asked in Dashboards and Reports

Needs advice on a new project

Hello,My name is Guillaume Lavergne and i’m a french student in computer science. I recently entered a new company on internship and i need advices on my newest project.On our symfony website, we want to embed a BI tool that can help our customers to get the data they want. For that, they need to have access to the dashboard maker interface directly on our website. The dashboard made will then be embed by API.This project is complicated because, after this part is developped and functionnal, i will have to make other changes to go further with the tool. For exemple, i’ll have to add an IA that allows the graphs to have an automatic interpretation like “in 5 years you’ll have a probleme here” etc.Do you think GoodData can be a great tool to achieve all of these goals ? Do we have to make an account by customers (because each one have their own database) , or can i have one user that connects to multiple databases ?I know these questions may have been answered a lot of time but i dont fi

2
Gabriel
6 months ago
K
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

1
Michael Ullock
GoodData Employee
6 months ago
T
tomashochKnown Participant
asked in GoodData.UI

Drilldown does not work in embeded dashboard

Dear Community,We have trouble with drill down functionality in our embedded dashboard.We are embedding dashboard into our website via React SDK v9.2.0. Implementation is very simple - <Dashboard dashboard={idRef(dashboardId)} /> We configured drill down to another dashboard in dashboard modeler in GoodData website. Drill down to another dashboard works in GoodData website. But it does not work in embedded dashboard.So it seems, we miss something in configuration of embedded dashboard, do we?Links from React UI documentation led me to this:https://help.gooddata.com/doc/growth/en/expand-your-gooddata-platform/gooddata-integration-into-your-application/embed-gooddata-elements-into-your-applications/setting-up-events-for-drilling-in-embedded-analytical-designer-and-dashboards/#SettingupEventsforDrillinginEmbeddedAnalyticalDesignerandDashboards-DrillEventingversusDrillintoDashboardIt’s under GD Platform documentation, so I’m not sure if is it relevant for Cloud too? Also it seems to

12
T
6 months ago
Smuller
SmullerNew Participant
asked in Dashboards and Reports

Freeze column or row

I liked like to freeze a column so that when I scroll across that row follows allowing me to easily reference it. 

4
T
6 months ago
aliakbar
aliakbarNew Participant
asked in SDKs and APIs

Problem occurs when provisioning clients. Error: 409 Conflict while running a brick

Hi, I am using goodata, amazon RDS and Redshift.I have added the user in Redshift and I am super admin in both redshift and gooddata.Now when I try to run a brick it gives me this error:```Problem occurs when provisioning clients. Error: 409 Conflict```Next, I added a new user as I thought the user already existed with different credientials and identities but again the same error occured.Can someone help me to troubleshoot it? This is the script I am running : ```{ "segments_filter": ["PRODUCTION"], "redshift_client": { "connection": { "url": "${Production.url}", "authentication": { "basic": { "userName": "${Production.username}", "password": "${Production.password}" } }, "database": "${Production.database}", "schema": "workspaces" } }, "input_source": { "type": "redshift", "query": "SELECT * FROM workspaces WHERE active = true;" }}``` Thanks in advance! 

1
Julius Kos
GoodData Employee
6 months ago
Jay Finegan
Jay FineganParticipating Frequently
asked in Metrics and MAQL

Counting records by metric

A common hypothesis is that employees with less experience are involved in more accidents. As the following image shows, I can identify specific incidents within a given time frame, I can compute the employee’s length of service (time delta between the date-of-hire and the event date), and I can properly assign the incident to a length-of-service bucket. WHat I am struggliung with is how to count the incidents in each bucket. For this example, I would like to be able to show a bar or pie chart which shows bucket ==> count:0 ==> 22 ==> 55 ==> 210 ==> 125 ==> 3Any ideas?

6
Francisco Antunes
GoodData Employee
6 months ago
Welcome to the GoodData Community!Cookie settings