To GoodData homepage

Recently active topics

32 Topics

Jay Finegan
Jay FineganNew Participant
asked in Metrics and MAQL

RUNSUM doesn't seem to like intermittent data

GoodData Enterprise;Metrics in play include:# Incidents_Recordable: SELECT IFNULL(COUNT(incidentID),0) WHERE isRecordable=1 AND Date (Event) BETWEEN _Timeline_Start AND _Timeline_EndYTD Recordables: SELECT IFNULL(RUNSUM(# Incidents_Recordable), 0) BY Month (Event) WHERE Date (Event) BETWEEN _Timeline_Start AND _Timeline_End Here is the data table where the issue manifests itself:The highligted elements in the data table show the YTD count dropping to zero, rather than preserving the YTD from the previous period. Cleveland, for example, should remain a 2 through March and April, as the YTD count was 2 at the end fo February. I’ll note that if Cleveland had an incident in May (outside the range of the image), the YTD count would (and does) correctly reflect the value of 3. Analysis shows that these “gaps” occur whenever a month has no incidents (and there is at least 1 incident in a predecessor month). It is clear that the RUNSUM function works correctly when there is an essentially cont

5
B
2 days ago
P
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? 

3
P
3 days ago
umernasirr
umernasirrParticipating Frequently
asked in Data sources

There are no tables in the database while connecting to Snowflake DB

Hey GoodData team, I am trying to connect to snowflake from GoodData as a data source. I have successfully connected the two, but not getting any tables in our schema. What could be the problem here, I’ve tried the following Schema Names while connecting: `OP_DEV, PUBLIC, INFORMATION_SCHEMA, op_dev, public, information_schema ` All of them show the same error “There are no tables in the database”. Could you help me out on this, as we’ve been trying to get GoodData and snowflake running for a while now, thank you.     

7
Joseph Heun
GoodData Employee
3 days ago
D
Moderator
Documentation TeamModerator
published in Data sources

Use AWS PrivateLink with GoodData Cloud

We are now able to set up AWS PrivateLink with GoodData Cloud. If you have an AWS account that runs an Amazon Redshift database, you can privately tunnel your data directly to your GoodData analytics.If you want to set up AWS PrivateLink with GoodData, you need to first set up a VPC Endpoint Service on your AWS account. Once you do that, you will get a “service name” that you can provide to us, so that we can finalize setting up your instance of GoodData Cloud to use the private link.This article describes how to set up the VPC Endpoint Service on your AWS account.You need to do the following two steps: Reach out to GoodData support, letting us know you want to set up PrivateLink.We will provide you with your GoodData account ID. You will need this ID for when you are setting up your VPC endpoint. Create a load balancer, see below. Create VPC endpoint service, see below. Pass the name of your VPC endpoint service to us, we will finalize setting up the AWS PrivateLink connection o

501
JaE
5 days ago
umernasirr
umernasirrParticipating Frequently
asked in Data sources

Issues with connecting to Snowflake DB

Hi GoodData, I are having issues with connecting our Gooddata with snowflake as a data source. Following is the error that pops up whenever I are trying to connect, the credentials are all correct I have verified it multiple times. If I change the credentials, it gives me an error about invalid url.Could you help us out on this issue?  Thanks and Regards,Umer Nasir

9
umernasirr
5 days ago
N
Nicolas JACOBNew Participant
asked in Administration

How a user can change its language

Hello,How can a user change its language ? I cannot find the option anymore in the “Account” page.  It used to be here (see picuture in our user documentation) but I cannot find it anymore... Is there another way to do this ? I need that my users see Good Data in french. This support link seems to indicate that a platform setting is required. But I do not find anything for this. Thanks in advance and Best Regards

7
Moises Morales
GoodData Employee
6 days ago
itzzyaseen
itzzyaseenNew Participant
asked in Data sources

Failed to obtain JDBC Connection

Background task failed: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host xxx.xx.xx.xx, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".): Cannot create PoolableConnectionFactory (The TCP/IP connection to the host xxx.xx.xx.xx, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".): The TCP/IP connection to the host xxx.xx.xx.xx, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is runn

6
Martin Burian
Community Manager
7 days ago
N
NickKKnown Participant
asked in Dashboards and Reports

GoodData.CN Internal Server Error

Hi!We’ve encountered some strange error and we cannot find any way to identify the problem.We’ve using GoodData.CN development edition in docker container.The issue comes up after a minute or so after opening “Analyze” tab:We can’t do anything after that.Here are the logs from the server:ts="2021-06-30 08:17:07.585" level=ERROR msg="Failed to start computation" logger=com.gooddata.tiger.grpc.client.aqe.AqeClient thread=grpc-default-executor-6 spanId=13ea4090fa414b5e traceId=13ea4090fa414b5e exc="errorType=com.gooddata.tiger.grpc.error.GrpcPropagatedServerException, message=UNKNOWN: ,<no detail> at com.gooddata.tiger.grpc.error.ErrorPropagationKt.convertFromUnknownException(ErrorPropagation.kt:108) Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: Error has been observed at the following site(s): |_ checkpoint ⇢ Handler com.gooddata.tiger.afm.controller.ElementsController#processElementsRequest(String, String, ElementsOrder, boolean, boolean, String, int, int,

24
Martin Burian
Community Manager
7 days ago
D
Moderator
Documentation TeamModerator

GoodData Platform - March 9, 2023Release Notes - GoodData Platform

Visualization tooltipsVisualization tooltipsYou can now add descriptive tooltips to your visualization to provide additional context for other users.On Dashboards, visualizations can display their descriptions as well. For each instance of a visualization on a dashboard, you can customize the description or hide it from displaying.Learn More:Create InsightsCreate Dashboards

80
D
Moderator
10 days ago
hanka
hankaNew Participant
asked in Dashboards and Reports

Date dimension names in "Date as" select

Hello!I have a funny situation where after adding a date to rows when creating an insight, not all dates in the select have proper names displayed. Our LDM assumes, that apart from regular date fields there are also few custom ones, that our customers can define freely, those are Group Custom Date Field 1-6. Once customers have defined their custom fields, we’re renaming them according to their settings. Here you can see that Group Custom Date Field 1-3 have been renamed to Project Scheduled Date…, Contract Signed Date … and Closeout Date & Time...In the date select, for regular date fields I can see their proper name, however, for those custom ones, there’s original name displayed (Group Custom Date Field 1) instead the one after renaming.What can be done to have date displaying proper name? Another issue is that the name is transformed and consists only of what’s in parenthesis if they are in the name. Here you can see only COM name. What naming conventions have to be met to have

6
hanka
10 days ago
D
Moderator
Documentation TeamModerator

GoodData.CN 2.3.0Release Notes - GoodData.CN

Released March 9th, 2023.New Features Dashboard Sharing and Dashboard Permissions Geo Charts (Pushpins) - New Visualization Type in Analytical Designer Export Dashboards to PDF (Beta) Clearing Cache Manually Show Missing Attribute Values in Visualizations Workspace Object Identifiers Visualization Tooltips Change the Date Format New ShowEmbeddButton Parameter for Iframes New Attributes for User and UseGroup Entities Embedded Analytical Designer Iframe Authentication GoodData.UI Version 8.12 Other Changes Bug Fixes Get the Community Edition Upgrade Guides Upgrade GoodData.CN Community Edition to 2.3 Upgrade GoodData.CN to 2.3 New FeaturesDashboard Sharing and Dashboard PermissionsWe are extending our system of permissions to also cover individual dashboards. Newly created dashboards will be private by default, and you get to choose what users and user groups you share the dashboard with. You also get to control the level of access each individual user or user group has to t

410
D
Moderator
10 days ago
D
Moderator
Documentation TeamModerator

GoodData Cloud - March 9, 2023Release Notes - GoodData Cloud

New Features Geo Charts (Pushpins) - New Visualization Type in Analytical Designer Export Dashboards to PDF (Beta) Clearing Cache Manually Support for AWS PrivateLink Show Missing Attribute Values in Visualizations Support for Databricks Workspace Object Identifiers Visualization Tooltips GoodData.UI Version 8.12 Python SDK Version 1.3 Bug Fixes Upcoming Features and Changes Dashboard Sharing and Dashboard Permissions New FeaturesGeo Charts (Pushpins) - New Visualization Type in Analytical DesignerAnalytical Designer now offers a new type of visualizations - Geo charts (pushpins).Geo charts with pushpins show data points as bubbles. They use location coordinates to display your data distributed on a world map. You can change the size and the color shade of the pushpins based on metric values.In the configuration, you can select which part of the map will be displayed as default, change the color of the pushpins, adjust the size ratio of the min and max pushpins, or group near

140
D
Moderator
11 days ago
valerieholman
valerieholmanNew Participant
asked in Metrics and MAQL

Format Text

Is there formatting code to ‘wrap text’ in a column heading or an attribute? 

2
valerieholman
11 days ago
D
davidhNew Participant
asked in Data models

Display view

Hi,i am problem with display view from my DB.I configured data source and use non public schema (custom schema name)After connect over data connector to my DB (in Model) - returns back only tables no views. The user has set permission to select from views.If I try the same situation with just the public schema, I see tables and views.Isn't the problem that I have the view in a different schema than the public? Thank you for your answersBest regardsDavid Haškovec

8
Jan Kos
GoodData Employee
13 days ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Null Value - Unanswered Phone Calls missing

I have a table of phone call facts, that includes a foreign key to a users table.  When making dashboards, things have been going well as long as the phone call is answered - because the user_id field is populated and aligns with a worker.  Unfortunately, some calls are not answered so the user_id for that row’s column is null. Once I add the full_name to the insight, all of the rows missing a name due to the foreign key disappear (but are still included in the roll up).  I’ve referenced the how-to guide but something isn’t clicking for me how how to cater this to my call center use-case. Can anyone access my account (admin has access from prior ticket) to tell me what I may be doing wrong?  This is a stopper for our migration.

1
Moises Morales
GoodData Employee
13 days ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

how to filter by 2 different date columns in the insight in Good data

Hi,In the Good Data insight, i want to use filter for effective date and expiration date but after i drag and dropped expiration date, it is not letting me drag and drop effective date as shown in the attached screenshot.So, is it possible to filter by 2 dates in insights in Good Data??

1
Moises Morales
GoodData Employee
13 days ago
P
Preetham ThangammaKnown Participant
asked in About GoodData

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

2
Moises Morales
GoodData Employee
13 days ago
MCHUMPITAZI
MCHUMPITAZINew Participant
asked in About GoodData

Error loading the attached file, please indicate the reason

Error loading the attached file, please indicate the reason

2
Moises Morales
GoodData Employee
13 days ago
K
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?

4
Moises Morales
GoodData Employee
13 days ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Date Time - Date Time

In our lake we store multiple date times, specifically for our use-case a postgress database with columns utilizing timestamp with time zone, nullable. call_start_time: 2023-01-14T16:32:25+00:00call_end_time:  2023-01-14T16:35:16+00:00 We don’t have a calculated column today, nor are we calculating at insert so we’re trying to create a metric that selects the average of call end time - call start time).  Since things may cross over the 24 hour mark and of we want to present data stored in UTC across different timezones, I’m looking for a way to make this work. In SQL it would be something like: SELECT AVG(TIMESTAMPDIFF(SECOND, call_start_time, call_end_time)) AS avg_time_not_answered FROM your_table_name WHERE Interaction_handled = 0; How can I replicate this in Gooddata, secondly, what is the easiest way to change visualization of our data into a selected timezone?

3
Radek Nováček
Community Manager
13 days ago
N
Nicolas JACOBNew Participant
asked in Dashboards and Reports

Opening Dashboard with default filtered value

Hello everybody,I have a dashboard that display data for several Office and can be filtered for these Office, with a Dashboard filter.I would like that the manager of the office can open the dashboard with their Office selected by default. My idea was that it could be done using the Url (/dashboards/#/workspace/xx/dashboard/yy?filter={attr.office.name: “My Office”}) or using user varibale and filter configuration in the Dashbord.  But this do not seem to be possible.Do you see other possibilities that actually works ? Thanks in advance.Best

2
Joseph Heun
GoodData Employee
16 days ago
T
tarik-aimadNew Participant
asked in GoodData.UI

Data too large to compute

HiOur application built with React unable to retrieve result using Gooddata query, due to the fact it reaches the size limit. While investigating the issue, we supposed that the cause can be the number of measures passing on the execution definition (please see the screen below), or the query result count, it raises an error if the data result exceed 100000 rows  Theoretically, our query definition doesn’t exceed the platfom limits in terms of result set, but is it possible to extend the number of result set if needed? Thanks for the support.Kind regardsTarik

7
Jan Rehanek
GoodData Employee
17 days ago
Julius Kos
GoodData Employee
Julius KosGoodData Employee
published in Administration - KB articles

Common SSO issues & tips on GoodData platformF.A.Q.

The purpose of this article is to address some potential problems which you might encounter during the SSO implementation or in the production itself. We have picked the top 10 topics raised by our customers.  1. How do I connect SSO with GoodData? What kind of SSO provider should I choose? Are you considering implementing Single-sign-on (SSO) within your domain, but don’t know where to start and what type of SSO provider setup would suit your needs? For that, we have created a very useful community article called Getting started with SSO that will help you to explore all the SSO scenarios which GoodData supports and pick up the best possible option for your use-case.  2. GoodData Support assistance is neededIf you struggle to troubleshoot your SSO production issues, or you are stuck in your implementation - GoodData Support Team is always here to help you. However, we strongly recommend you to include some basic necessary information when contacting us. This way you will increase our

300
Julius Kos
GoodData Employee
18 days ago
M
martymooseNew Participant
asked in Dashboards and Reports

Too many rows in insights

I have 2.3 million rows in a view.    The insight builder wont let me add attributes because their are too many. Is good data not capable of have a table with unlimited values using pagination or some other method?

1
Moises Morales
GoodData Employee
20 days ago
tylervaleo
tylervaleoNew Participant
asked in Dashboards and Reports

How do you apply a date filter for one graph but not the other?

Hello there,I noticed in my Kantata instance, there is a Date Filter “Date Filter for Graph” that is applicable to a specific graph on an out of the box dashboard, but not to the larger table below. When adjusting the date range, the bar graph will adjust, but the data in the table below will stay consistent with “To-Date” data. Can you please explain how I would be able to apply this? Screenshot below:  

1
Iva Gasparekova
GoodData Employee
23 days ago
Welcome to the GoodData Community!Cookie settings