To GoodData homepage

Solved

34 Topics

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
3 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
5 months ago
P
Preetham ThangammaKnown Participant
asked in About GoodData

how to concatenate the attributes in GOOD DATA?

Hi,     I need to  concatenate the two attribute columns in GOOD DATA but I am unable to do it. Please help me do it  Thank you

1
Julius Kos
GoodData Employee
5 months ago
Lokeshwar
LokeshwarNew Participant
asked in Dashboards and Reports

how data filters interact with dashboards

how data filters interact with dashboardshttps://www.gooddata.com/docs/cloud/create-dashboards/drilling-in-dashboards/set-drill-into-dashboard/#SetDrillintoDashboard-DatefiltersI am unable understand the content in the below screenshot, it is from the above link,Could you please elaborate with pictures, if possible?Thank you  

2
Lokeshwar
6 months ago
Lokeshwar
LokeshwarNew Participant
asked in Dashboards and Reports

filter the secondary filter based on value selected at the primary filter

Assume I have category and sub category columnsI wish to use both of them as insight level filtersNow, when i select a specific value in category filter i want to see sub category values which are related only to that category value  that is selected.But as of now, Good data is showing all the values of sub category that related and unrelated to the category selected.Please let me know, how can i achieve my requirement?

3
Julius Kos
GoodData Employee
6 months ago
M
Mark PetersonNew Participant
asked in Dashboards and Reports

Changing Title of Sum and RollUp headers

Hi, just wondering if anyone knows whether its possible to customise the Column or Row header name for the Aggregate values (ie. Sum, Avg, Min, Max, Rollup, etc).  In my example, ideally I’d like to display the Header as “Total Sales”, instead of Rollup(Total)Thanks in advance. 

3
Julius Kos
GoodData Employee
6 months ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

how to display the metrics in the y-axis in bar chart

Hi,    I created the bar chart where all the values are facts and i want to display the fact names in the y-axis.How to do that?Please find the attached image for the reference. Thank you

1
Julius Kos
GoodData Employee
7 months ago
yogi
yogiNew Participant
asked in GoodData.UI

Pagination on Table visual

How to creae table visual with pagination in good data

3
Joseph Heun
GoodData Employee
8 months ago
bc1
bc1New Participant
asked in Metrics and MAQL

Displaying data within a timeframe

I have an attribute called Date Completed, which I can display no problem and an attribute with my current task status - I am able to see as of today is this task done or not, I am also able to see which month a task was marked completed. I am looking for a way to count tasks every month that are “open” aka in any status other than completed or do not have a date completed.

2
Julius Kos
GoodData Employee
8 months ago
hanka
hankaKnown Participant
asked in Data models

Dates and time zones

Hello!I was reading docs regarding custom time zones as well as custom time dimensions, and I’m still not sure how to deal best with users different time zones and proper display of dates.Most of our users are in Pacific Standard Time zone, however, our data are stored in UTC format. Because by default there’s no support for timestamps, we’re sending only dates to GoodData. But this causes some dates are displayed differently in GoodData and in the main application. For example Apr 21, 2023 - 6:13pm Pacific time displayed in the app is already 22/04/2023 in GoodData (as it’s UTC).One solution I see is to normalize dates from UTC to timezone that should be used in a given workspace for data upload. That would work well if all workspace users were in the same time zone.Would there be any good solution that could work for a workspace that can be used by users in different time zones? So they could see base date displayed in their desired zone? I don’t see how custom time dimension could h

5
Moises Morales
GoodData Employee
10 months ago
D
DarinaNew Participant
asked in Data sources

Permanently deleting the whole dataset

Hello! I need to permanently delete a dataset (a previously uploaded .csv file). How do I make that happen?Is the red "Delete" button in the "Manage" -> "Data Sets" -> <data set> section (see screenshot below) sufficient for this purpose? Or is there another way to do it? 

2
D
10 months ago
A
aboucNew Participant
asked in Dashboards and Reports

Line Chart for Tracking Remaining Budget Week Over Week

I’m looking to use the line chart to create a budget burndown report in Kantata that works in the following way.X AxisWeekly timeline based on Project Start Date and Project End Date Week = Sunday - SaturdayY Axis Target burndown trend line based on Project Hours Estimate / number of weeks between Project Start Date and Project End Date Trend line beginning with Project Hours Estimate, populating week over week with Hours Remaining Begin with Project Hours Estimate (total available hours) Each week, add a data point based on Remaining Hours Bonus if this can be combo chart with a weekly column to display hours used each week. 

1
Julius Kos
GoodData Employee
11 months ago
jamesjenkins
jamesjenkinsKnown Participant
asked in Data sources

Connecting Google BigQuery Dataset to GoodData

I have created a dataset in BigQuery and am trying to work out how to connect this to a model in GoodData. I have authorised the correct permissions on service keys and connected them ok, however I keep getting the error “Refresh data source failed. Server-side problem. Contact Support” whenever I try to add the data source. Any help is appreciated.

2
jamesjenkins
1 year ago
Virgil
VirgilNew Participant
asked in Data sources

bigQuery multilevel data (json)

We connected to bigquery where we have the data imported following wayhttps://prnt.sc/bjL3_rN6kTLjactivityLevel 2 statusLevel 2 authorization_dateLevel 2 reception_dateLevel 2 received_dateLevel 2 controlled_dateLevel 2 refunded_datebut in gooddata we only see level 1 data such as activity which clearly is not working :))https://prnt.sc/IRbYP9g3PmBchow can we drill down?

1
Julius Kos
GoodData Employee
1 year ago
M
martymooseNew Participant
asked in Dashboards and Reports

Checkboxes / Multiple Select by row in tables?

Is there a way to have checkboxes in each row of a table that allows you to select a row one by one?   

1
Julius Kos
GoodData Employee
1 year ago
henrique santos
henrique santosNew Participant
asked in Administration

Error not mapped by error notifications

Hello, I recently set up email notifications from analytics.totvs in case of "failure" but the case of the following image is not notified, does it fit something other than failure? 

7
Julius Kos
GoodData Employee
1 year ago
Douglas Paiva
Douglas PaivaNew Participant
asked in Metrics and MAQL

Use more than 4 decimal places

Hello guys!Could you help me? I have to calculate the value of the cost x amount of information in our database. I'm having difficulties because the cost has more than 4 decimal places, as shown in the image below. I've tried using the Property templates, but without success.Note: It is set to float

1
Julius Kos
GoodData Employee
1 year ago
amandagohmeikuen
amandagohmeikuenNew Participant
asked in Dashboards and Reports

Sorting Order Does not Work for Insights with metrics

Hello, is there a way I can sort the x-axis value correctly when a metric is present? Currently, it is sorting based on metrics value.  

1
Julius Kos
GoodData Employee
1 year ago
M
MashaKnown Participant
asked in Data models

Moving attributes between datasets

Hello,I have a question about possibility of moving attributes between datasets.Let's say i want to move an attribute Account name from Subscription fact table to Performance dimension table at the LDM level. It seems possible operationally (using a “move” button) but I cannot see how can I map it properly when it lands in the Performance dimension table. Seems like I cannot tell that the data source for this specific column should be another source table (Subscription fact table in this case). If so, what is the purpose behind  a “move” button?My general context is to test how can/can’t I modify my LDM in case any Insights/Dashboards already exist on top of the LDM. And is there any recommended scenario for the approach when I want to populate my workspace with data incrementally?Thank you,  

10
M
1 year ago
GabrielGreco
GabrielGrecoNew Participant
asked in Metrics and MAQL

See MAQL codes made by "Analyze"

Hey!So, I would like to know if there is any way to see the MAQL code made up by the drag & drop analyze. I created a insight using the drag & drop tool but I need to see the Metric code (SELECT) that was generated by the tool to use at other projects. Thanks!

3
Julius Kos
GoodData Employee
1 year ago
J
JeffCatNew Participant
asked in Metrics and MAQL

Color format HH:MM:SS

Is there a way to color format HH:MM:SS?I’m looking for a way to evaluate this and color format accordinglyI’d like to do something like this:[<3600][red]{[>=3600]{{{3600||00}}}:{{{60|60|00}}}:{{{|60.|00}}};[<3600]{{{3600||00}}}:{{{60|60|00}}}:{{{|60.|00}}};[>=0]{{{60|60|00}}}:{{{|60.|00}}};[<0]-{{{60|60|00}}}:{{{|60.|00}}};};[<18000][Yellow]{[>=3600]{{{3600||00}}}:{{{60|60|00}}}:{{{|60.|00}}};[<3600]{{{3600||00}}}:{{{60|60|00}}}:{{{|60.|00}}};[>=0]{{{60|60|00}}}:{{{|60.|00}}};[<0]-{{{60|60|00}}}:{{{|60.|00}}};};[<36000][green]{[>=3600]{{{3600||00}}}:{{{60|60|00}}}:{{{|60.|00}}};[<3600]{{{3600||00}}}:{{{60|60|00}}}:{{{|60.|00}}};[>=0]{{{60|60|00}}}:{{{|60.|00}}};[<0]-{{{60|60|00}}}:{{{|60.|00}}};};

2
J
1 year ago
M
MashaKnown Participant
asked in Dashboards and Reports

Definitions and distributions location

Hello,I was wondering maybe someone can advise what is the best place to keep the definitions (something like a readme file or a internal knowledge base)?Attributes and facts are listed in “Manage” tab and have a description field which is great. But some general assumptions (like how the data was pre-calculated before getting into data model or what is out of the scope) also needs to be defined and described sometimes but I cannot find where can it be done. I also wanted to ask whether there’s a way to enable a possibility to dive into attributes and facts descriptions directly from the dashboards or insights?Thanks! 

4
M
1 year ago
M
MashaKnown Participant
asked in Metrics and MAQL

Working with metrics

Hello,I have a question regarding the working with metrics topic. I have read through documentation related to this topic but it's still unclear to me why Attributes become unavailable when I pick a metric that I created. I'm trying the basic concept of creating a metric by summing up 2 facts from different fact tables of the data model. Both tables are related to one dimension table (that stores all attributes) as 1:N.The interesting part for me is that if I'm using these same 2 facts separately, most of the attributes remain available.  Please see the screenshots below. 

7
Julius Kos
GoodData Employee
1 year ago
felix
felixNew Participant
asked in Dashboards and Reports

GoodSuccess Insights

Can the following two insights be created out of the box while using GoodSuccess Tracking?- Is it possible to have a chart that shows me which insight was created by whom (independent of being shared with others)?- Is it possible to create User Groups to track the usage of GoodData per specific department?       Example would be Employee A works in Finance whereas Employee B works in Sales —> I might only be interested in the activity of the finance employee. Is there a way to classify our invited users in such a way for further analysis? Thanks in advance! Best regards,Felix

1
Julius Kos
GoodData Employee
1 year ago
gunit
gunitNew Participant
asked in SDKs and APIs

Where can I fund filter IDs for raw Report export?

Hi there,We have a dashboard with a report, but we also want to export report’s data and use a part of it in our internal BI tool. This page https://help.gooddata.com/doc/enterprise/en/expand-your-gooddata-platform/api-reference#operation/exportRawReport suggests that raw export can be filtered. I am trying to understand where can I find filter_id for this: { "uri": "/gdc/md/{project_id}/obj/{filter_id}", "constraint": { "type": "interval", "from": "2015-07-01", "to": "2015-07-10" } }Any help is greatly appreciated!

1
Julius Kos
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings