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 articles11 Administration - KB articles15 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData24
AnalyticsDashboards and Reports112 Metrics and MAQL87
Data modeling & IntegrationData models31 Data sources57
Development & AdministrationGoodData.UI32 Administration71 Solution architecture6 SDKs and APIs21
GoodData For FreshdeskNews & Updates3 Got a question?10 General Information1

Ask your question
Login

Community
Analytics
Dashboards and Reports

Dashboards and Reports

Dashboards and Reports

112 Topics
287 Replies

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

112 Topics

Newest first

Recently active Most replies Most views

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

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

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?

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

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

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:

AdamVNew Participant

asked in Dashboards and Reports

Insight aggregation by week

Hi all,I'm trying to aggregate an insight by weeks. When I move the relevant date to the X-axis, it only offers aggregate by week (Sun-Sat), not the week (Mon-Sun) option. See the attached print screen.I changed my settings to have Monday as the first day of week. But still no luck.Where can I change the weeks starting on Monday for individual insights?Thanks!Adam

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?

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

INSIGHT design in the image

Hello, i have a reference insight and i don’t know how the ‘Policy Count - SP year ago’ in the metrics are calculated and why the same column is unchangeable as in to view the calculations done for the same column.Please do help me to solve this issue to create a same insight in another workspace and consider the attached image too!! Thank you

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

where does the data (empty value) column value appears from in the insight?

Hello, can u please let me know why 'empty value' is dispalyed in the attached image. i thought because of null value in the source that is the sql table but there is no null value in the sql table for featureid column!! Thank you

maresParticipating Frequently

asked in Dashboards and Reports

Start End Date bar chart by Months

Hi Folks !I'm reviewing GoodData, and of course I'm here cause I have some really basic questions.To make the example easy, I'have a data set with 3 fields user, start end date (subscriptions base data). I'm trying to build a simple chart in which each MM-YY as (X axis) and count the active subscriptions (Y axis). user start end 1 jan-22 dec-22 2 jan-22 mar-22 result would be (bar char): 2 2 2 1 1 jan-22 feb-22 march-22 apr-22 … rest of months ... The issue I'm encountering is that GoodData is associating the date with only 1 date field either start or end. How can achieve this?I read date-attribute-arithmetic, if I understood correctly that won't solve my query, as it calculates the duration by a given granularity

henrique santosNew Participant

asked in Dashboards and Reports

How to resolve some records showing empty value on a analytics.totvs report?

Hello, I recently created a report that shows an empty value (valor vazio) in two specific columns of some records, even if this data exists in the database and is in the CSV used in the ETL process, does anyone have any idea what it could be? Thanks anyway.

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

How to add more than 20 rows in Good Data Insight??

Hello, I am creating an insight which has more than 30 columns and i have to display all the columns in the insight but Good Data Application is letting me add only 20 columns as shown in the attachment.can you please let me know how to add all the 30+ columns in the insight in Good DataThank you

tylervaleoNew Participant

asked in Dashboards and Reports

Can we Sum or RunSUM based for columns in a table?

I’m trying to replicate a report, and would rather not create a metric for the SUM of 4 metrics I created if there is a sum feature I can use for each column that is built in. Not sure if there is a way to SUM the columns like there is with SUMing the Rows as shown below: Any help is always apprecaited!

nathanliuParticipating Frequently

asked in Dashboards and Reports

Text Selection?

Hi, not sure if this is just me, but I am unable to select text in tables that are on dashboards. If I edit the insight, I can select text but cannot directly from the dashboard. We use this a lot for selecting session ids, is this a bug or feature?

nisujju1987New Participant

asked in Dashboards and Reports

Dashboard embedding via iframe and prefiltering data

Hi,We are trying to embed the dashboard via iframe and trying to attempt the pre filtering when fetching it but its still not clear how this should be done. Below steps was followed. Can you please check and let us know if something wrong was done.We have a Test dashboard which has different customer region(attribute) as you can see in first image. Aim is to get iframe/url of the dashboard prefiltered with data of only South region. For this we set the tag on the Customer Region with tag value as south which can be seen in second image. After this we use the includeObjectsWithTags=[south] in embedded url link to get the dashboard with prefiltered south region data only but this didn’t worked. Here is the detailed link https://nitesh.on.gooddata.com/dashboards/embedded/#/workspace/c1o9hnzy7lwdckb8h6hhmc9pzkdm8nip/da[…]ue&includeObjectsWithTags=[south]&setHeight=700Can you please suggest us what we could be doing wrong here and how this could be achieved? Please let me know if yo

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

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

Regarding the order by for attribute column in Good data platform

Hello, I am trying to use orderby for the Monthdiff column as shown in the image but since it is an attribute column,it is not working as an int value but if i convert the value to int,the column in analyze will not accept it.please do let me know how to orderby the monthdiff attribute column like int where it should display values like 12,24,36,48 and so on not like 108,12,128,132 and so on.Also i want to delete the row displaying ‘sum of cwp’ as well as marked in the attached image.please do help with it too!! Thank you

MashaKnown Participant

asked in Dashboards and Reports

KPI alerts

Hello, could you please let me know if it’s only possible to create KPI alerts based on metrics that are being calculated within GD and exist as metrics? Here’s an example - let’s say I want to track open to visit rate (O/V) as well as raw visits number. Can I create KPIs and alerts for both or only or O/V? If i cannot create a KPI and alert for such raw metric as visits, is there any way in GD I can track it and be alerted if that number falls/raises?Thank you!

tylervaleoNew Participant

asked in Dashboards and Reports

Embed Filter Title selection

Can someone assist with the proper embed code in order to have the selection of a filter populate as the top of a dashboard tab, similarly to screenshot below, where “[Admin] | XYZ” populates because it is selected from the Project Filter. I’m hoping to use something similar with a different filter, but I’m not sure how to create the code.The current web content address for my example is:https://s3.amazonaws.com/gd-images.gooddata.com/customtext/magic.html?text=%FILTER_TITLE(attr.workspace.id)%&font=Open%20Sans&gfont=Open%20Sans&size=21&color=777777&fontweight=500I’m assuming that is has something to do with that %FILTER_TITLE(attr.workspace.id) but I’m not sure how to set it up for a different filter.

Preetham ThangammaKnown Participant

asked in Dashboards and Reports

Regarding Export pdf in Good data

Hello,As i want to Export the dashboard data to pdf in good data but it is exporting only the data found on the screen for the table insight.Please do let me know how to export the entire data in the table insight into pdf.Thank YouPreetham Thangamma K

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

Page 1 / 5

Powered by inSided

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