Dashboards and Reports
Dashboards and Reports
- 125 Topics
- 342 Replies
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
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
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.
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
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!
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
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
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
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!
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.
Using setFilterContext with our id instead of Gooddata Id
Hi,We are trying to implement filters on GoodData report using setFilterContext but while sending payload it goes as /gdc/md/qpi84tpgks8tqp880r0k8wvzhxe7z2vw/obj/21015/elements?id=13 where id = 13 is the id in goodData, but instead we want to use id that we have in our system (19 is that ID of the same element in our data base) ,How to implement it ?Thanks!
How to categorise fields according to table in analyze view
I saw in the intro video that we can categorise the fields according to the table. For example:My fields are not showing up like this. It looks like they are all part of one table. This makes it very difficult to build reports, as we have many fields between several tables. How do I categorise them as above?
Embedding Dashboard iframe issues CN
Sometimes you may encounter issues when embedding from an iframe. It will work when accessing the domain/workspace directly but the embedded authentication will result in a 401 error. In this case you may want to consult the following documentation: https://help.gooddata.com/doc/enterprise/en/additional-resources/troubleshooting/embedding-issues If you are accessing any resource (even in an iframe) from any SSL secured site, you need that resource to be SSL secured as well. For Chrome browsers Version 79, you can enforce the SameSite check. To do so, go to chrome://flags/ and enable the SameSite by default cookies. If you are working with GoodData.CN Set env variable of your GoodData.CN container like this:SPRING_SECURITY_OAUTH2_CLIENT_COOKIES_SAMESITE=NoneRestart the container, and it should be working
Can graph/variables be updated via an embedded dashboard?
Hi, I manage to embed the dashboard but i can only view the dashboards which i created on Gooddata platform.Is there any way i can change or edit the graph/data of dashboard via Embed Dashboard or API call or with some Code or graph/data can only be changed or added via Gooddata platform?Thanks
Geo Chart - in the dashboard does not maintain regional focus
I have built a Geo Chart where I have used the Map configuration to default the viewpoint to Asia - and have further focused in on South East Asia. However, when I push it into the dashboard the view is fixed on the full world view. Is there something that I might be doing incorrectly?
Cannot select single day
HelloWe and our clients have noticed it is no longer possible to select the same start and end date on the static range date picker.Previously, we could see data for a single day by selecting the same start and end dates, but this is no longer a possible.Workarounds include typing the date, or selecting the end date before the start date, although this is fiddly and slowly our users are beginning to submit support tickets about this.is this a known issue?
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
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!
BUTTON WITH ACCESS TO ANOTHER TAB
Would it be possible to create a button that, when clicked, would send the user to the screen II tab?This feature already exists when we build a report in table format. but I would like to know if there would be a way to create a button to direct the user.There is a tool available at https://s3.amazonaws.com/gd-images.gooddata.com/customtext/embed.html however it does not have this feature.
Already have an account? Login
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.