To GoodData homepage

Analytics

Analytics

249 Topics

M
MarketaNew Participant
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?

5
Iva Gasparekova
GoodData Employee
10 hours ago
M
MarketaNew Participant
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"}

2
M
6 days 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
6 days 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
9 days 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
13 days 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
22 days 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
1 month ago
M
MarketaNew Participant
asked in Dashboards and Reports

Reached limit of max size of data returned from database

What is best way to fix this error? "Reached limit of max size of data returned from database"  

2
M
1 month 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
1 month 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
1 month 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
1 month ago
aerodinesh
aerodineshNew Participant
asked in Dashboards and Reports

Date dimension is defaulting to UTC+1 timezone

Hello,We have observed that the date dimension when creating insights is defaulting to UTC+1 timezone and even after updating the timezone using - https://analytics.aerosimple.com/gdc/md/smhannp580p8fegqpzl88ah5u6o7irgj/service/timezone it is still not getting reflected.This is causing issues in the reports, can anyone please guide what is needed to be changed here.Thanks.

5
aerodinesh
1 month ago
A
Andres SuttonNew Participant
asked in Metrics and MAQL

Calculate when an invoice is due

I have uploaded our invoice data to GoodData and would like to create a report where I will see when the invoices are due. I have invoice date and expiration days. Is it possible to calculate it and display as date "yyyy-mm-dd"?Example: Invoice date: 2023-01-01 Due: 15 days            Due date: 2023-01-16 Thanks in advance!!Andres

3
Moises Morales
GoodData Employee
1 month ago
T
tomashochKnown Participant
asked in Dashboards and Reports

Unable to navigate to dashboards from list of workspaces (main page)

Dear Community,we are facing the issue of users navigating to the dashboards page from the workspace list page when the user only has VIEW permission for the workspace.    We have a user with VIEW permission for the workspace,     He has access to dashboards in the workspace.When a user logs into the GoodData Cloud website, he is redirected to the page with a list of workspaces. He can see the workspace in the list of workspace, but the item (workspace name) is not clickable. It shows only a tooltip saying that more permissions are needed. So he can’t go to the page with dashboards in the workspace. When he displays dashboards via direct URL, he can see the dashboards.When we assign ANALYZE permission to the user, the workspace name in the list of workspace become clickable and the user is able to go to the page with a list of dashboards.Is there any way how the user with VIEW permissions can go to dasboards page of the workspace after login?Many thanks in advance.Tomas Hoch

2
T
1 month ago
anastasie.pustovalova
anastasie.pustovalovaNew Participant
asked in Dashboards and Reports

attribute filters for the whole dashboard

Dear Community,I would like to set up a metric filter for the whole dashboard. To be more specific - I need to create a dashboard, where the metric is represented by number of packages sold. I want to be able to switch metric to value of packages sold and the whole dashboard would be recalculated accordingly.From what I have understood. KPI Dashboards should allow me to do that, but I don’t see this option in GD Cloud. Is there any workaround please? Anastasie

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

5
Michael Ullock
GoodData Employee
2 months ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

Drill down chart for facts

Hi,         I want to create a drill down chart for values which are all factsi went through the following link but here drill down can be done only for attributes but not facts.Please help at the earliest!!https://help.gooddata.com/doc/free/en/dashboards-and-insights/dashboards/drilling-in-dashboards/drill-down-in-dashboards/

7
Joseph Heun
GoodData Employee
2 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
3 months ago
Patrik Braborec
Community Manager
Patrik BraborecCommunity Manager
published in Dashboards and Reports

How To Create Alerts in GoodDataTutorial

If you wish to set alerts for specific metrics or visualizations in GoodData, this tutorial will guide you through the process of using the GoodData Python SDK. Alerts enhance your monitoring capabilities for critical metrics and automate the notification process, which can assist you in preventing serious issues. With the flexibility of the GoodData Python SDK, you aren't limited to just one predefined solution, so you can customize it to your heart's content.You can check the whole repository here.Prerequisites:GoodData Cloud and GoodData API token S3 bucket SMTP server to send emails (for example, Gmail) What Is Gmail SMTP and How to Use Gmail With My Domain? We reccomend you to use Python virtual environmentYou can still create alerts without an S3 bucket, but your capabilities will be limited. This is because the S3 bucket is used to store information about notifications that have already been sent. Without it, you will receive the same notification repeatedly.Disclaimer:It works

1570
Patrik Braborec
Community Manager
3 months ago
K
kaviKnown Participant
asked in Dashboards and Reports

Failed to download .xlsx file

Hi,High PriorityOne of the Customer found that when they try to download .xlsx files from web Dashboard nothing happens.When reviewing this on a call with them they get a "403 Forbidden" error in the console.403 ForbiddenSteps fallowed by customer: clicking on download .xlsx button Download button still loading but not giving any result But it’s working for other file formats downloads. Please provide the solution.Thanks,Kavi

3
Francisco Antunes
GoodData Employee
3 months ago
K
kaviKnown Participant
asked in Dashboards and Reports

Year filter selection in KPI dashboards

Hi,Is there a way to select entire year in date filter with single click in KPI Dashboard.Like shown below in DashboardsThanks,Kavi

5
Joseph Heun
GoodData Employee
3 months ago
T
tomashochKnown Participant
asked in Dashboards and Reports

Private Insigth

Dear Community, I would like to ask you, is it possible to make Insight private for one user within the workspace? I haven’t found any option (including GoodData API) how to make it inaccessible for other users in the workspace. Even users who can edit dashboards can see all Insights as possible visualizations for the dashboard. The user of one of our customers would like to do some exploratory stuff and create some personal visualizations (insights), but he does not want to pollute the workspace with unfinished or incorrect Insights. Thank you for your help in advance, Tomas Hoch

4
Joseph Heun
GoodData Employee
3 months ago
K
kaviKnown Participant
asked in Dashboards and Reports

Show state names instead of coordinates using geo pushpin field

Hi, I’ve added the Geo Pushpin field to the existing data model as mentioned in the below linkhttps://www.gooddata.com/blog/using-geo-charts-gooddata-technical-overview/I can make geo charts in the analyze tab, but when I try to display them in table view, I get coordinate numbers rather than state names.  can someone please point me to a resource that would explain the process. Thanks,Kavi

7
M
GoodData Employee
4 months ago
anastasie.pustovalova
anastasie.pustovalovaNew Participant
asked in Metrics and MAQL

Grouping attribute values and then using the group to filter data

Hello,I need to create a groups which consist of atribute values. Then I want to use this group as a filter for my dashboard. How do I do that? Example:attribute=regionsnew attribute=states (groups of regions)filter = filters dashboard by states Thank you

4
anastasie.pustovalova
4 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
4 months ago
Welcome to the GoodData Community!Cookie settings