To GoodData homepage

Knowledge base
AnalyticsDashboards and Reports - KB articles8 Metrics and MAQL - KB articles23
Data modeling & IntegrationData models - KB articles8 Data sources - KB articles9
Development & AdministrationGoodData.UI - KB articles12 Administration - KB articles18 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData26
AnalyticsDashboards and Reports125 Metrics and MAQL90
Data modeling & IntegrationData models34 Data sources58
Development & AdministrationGoodData.UI33 Administration75 Solution architecture6 SDKs and APIs24
GoodData For FreshdeskNews & Updates4 Got a question?10 General Information1

Ask your question
Login

Community
Analytics
Dashboards and Reports

Dashboards and Reports

Dashboards and Reports

125 Topics
342 Replies

When you subscribe we will email you when there is a new topic in this category

125 Topics

Recently active

Most replies Most views Newest first

Douglas PaivaNew Participant

asked in Dashboards and Reports

Percentage of each item based on total

Guys, how are you? I'm trying to create a column that shows the percentage of each item's quantity based on the total sum of quantity. I'm not getting success... if I put the percentage directly in the insight, I can't add another column with integer values. Is there any metric that brings me these values?Attempt to create a metric...SELECT (SELECT SUM(Quantidade) BY Tenant, ALL OTHER WITHOUT PF) / (SELECT SUM(Quantidade))Trying through Analyze- This is the desired column - But when adding the quantity column in integer format, it disables the "show in %" option

Nicolas JACOBParticipating Frequently

asked in Dashboards and Reports

Multiple Date Filter

Hi,I have a question from a customer of us regarding Date filter.They use good data to reporting insurance case, with a opening and a closing date. They want a report (table) where we can set 2 date filter: Case open after X and closed before Y.Unfortunately, it seems not possible to do this with GoodData SaaS : once you put a date filter, you cannot put another one.Do you see a workaround for my customer ?Do you this this could be a possible enhancement or is there technical reasons for not being possible to implement this ? Thanks in advance and Best regardsNicolas

henrique santosNew Participant

asked in Dashboards and Reports

Filter doesn't work

I have a panel with a report that show the number of employees that the company has by gender, and I added a Competence Date filter (date referring to payrolls) but it is not working. "Competence Date" is linked to the "Payroll" dataset, which in turn is linked to the "Employees" dataset. How can I make this filter work?

umernasirrParticipating Frequently

asked in Dashboards and Reports

Not able to see any users/groups when trying to share a dashboard on GoodData.CN

Hi GoodData team, We are facing an issue on our GoodData account https://katon.cloud.gooddata.com/, where we are not able to see any users/groups when trying to share a dashboard. What we want to achieve is to show some users only a set of client workspaces, instead of adding them to the adminGroup and them seeing all workspaces. What could be the issue here? Not able to see any users/groups when trying to share dashboard API call to get all userGroups I’ve added a user into the adfireGroup and I still don’t see it anywhere on GoodData. Thank you and Regards,Umer Nasir

jamesjenkinsParticipating Frequently

asked in Dashboards and Reports

Create a difference column comparing two dates

I have two columns, revenue this week and revenue last week, and I am looking to add a third column which shows the difference between the two. I believe this might be able to be done with a new metric. Does anyone have an idea how to execute this? Cheers

BreckNew Participant

asked in Dashboards and Reports

Daily Management Report

I am trying to make a report that shows the total number of calls/jobs vs the number of calls/jobs with a ticket of at least $189, broken down by team member. I would also like a report showing the total average invoice, broken down by team member. And the MTD/YTD totals, broken down by team member. Additionally, if we can separate all of these by tags such as commercial vs residential. Is there a way to set all of this up? I've been playing around and I think I have found the average invoices and MTD, but that is about it.

kaviParticipating Frequently

asked in Dashboards and Reports

How to lock Analyze visuals

Hi, I would like to lock the Analyze visuals. So, that I can see only save as option for those locked visuals.Can any one help me on how to achieve that. Thanks,Kavi

GSawdyParticipating Frequently

asked in Dashboards and Reports

Remove empty value label

Hello I have a data model, with no apparent empty values in the date field. However when I create visuals or even just a table with the date values (no fact/attribute data) there is always an ‘empty value’ label when no date filters are applied. Is there a way I can exclude the ‘empty value’, which has no data populating it. This is primarily for aesthetics. ThanksGeorge

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.

jamesjenkinsParticipating Frequently

asked in Dashboards and Reports

Converting from string to geo

I have some data that is recognised as geography on bigquery, however when I import into gooddata it is recognised as a string. How can I change it to be geography so that I can use the geo attribute functions within insights? I also have the individual lat and long coordinates imported if it is easier to use them? The combined coordinates are in bigquery in the format “POINT(X.XX X.XX)”.

GSawdyParticipating Frequently

asked in Dashboards and Reports

Table visual won't convert to chart

Hello I have created a conditional metric to calculate revenue (see screenshot below). I want to show the revenue by date in a bar chart and have an attribute campaign filter so I can select the revenue for the specific attribute. I have created a table with the date, the attribute and the metric and it is showing me the revenue by campaign and date. However, when I try to change this to a bar chart, removing the campaign attribute and have only revenue and date, the visual breaks.The campaign attribute and pricing model is based off a different attribute table in my model to the fact table which includes the date.I need a chart to show overall revenue by date, that can be filtered by the campaign. Thanks

GSawdyParticipating Frequently

asked in Dashboards and Reports

Conditional format headline visual comparison percentage

I’ve seen a demo when a headline visual has a comparison versus a previous period, the percentage difference is green/red depending on an increase or decrease vs previous period.How is this conditional formatting implementeD?

ZafarNew Participant

asked in Dashboards and Reports

Embedding dashboard React vs Html

I have embedded two dashboards, one using react app where i have to login manually other is html page where i am logging in using SSO. I can see edit dashboard button on the html page. What's the reason i am seeing this in html but not on react app?

kaviParticipating Frequently

asked in Dashboards and Reports

Error in ADS Integrator

Can any one help me out why below errors are occurring in ADS Integrator.Thanks,Kavi

jamesjenkinsParticipating Frequently

asked in Dashboards and Reports

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.

Jean-Christophe

asked in Dashboards and Reports

Format date as dd/mm

Hi, I’m looking at showing a specific date in a table without the year but only dd/mm. Is there any solution to change the format for that specific date ?date without yearBest regardsJean-Christophe

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?

Mark PetersonNew Participant

asked in Dashboards and Reports

Is there a way of increasing the maximum height of a widget or enabling paginated reports in PDF

When I export a Dashboard to PDF, any long table visualisations is restricted to 24 rows of data. Its fine when using the interactive dashboard because you can just scroll down, but I would have expected it to paginate the results in the PDF export.Any ideas how to get around this limitation?Thanks.

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

how sum the more than two column values in an insight

Hi, can u please let me know how to sum the column values in the attached screenshot

NickKKnown Participant

posted 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,

hankaParticipating Frequently

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

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??

Nicolas JACOBParticipating Frequently

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

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?

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
2
3
4
5

Page 1 / 5

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 GoodData for Freshdesk

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