To GoodData homepage

Dashboards and Reports

Dashboards and Reports

  • 149 Topics
  • 434 Replies

149 Topics

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

24
Martin Burian
Community Manager
8 months ago
Z
zmazulaKnown Participant
asked in Dashboards and Reports

New dashboard/insight bug in a child workspace

Hi Gooddata,We faced with a dashboard/insight creation bug in a child workspace (Gooddata.CN 1.7). We created a simple parent-child structure with data filtering (column filtered by a value) and have dashboards/insights in the parent and those works well with filtered data:parent child child child Unfortunately, when you choose a child workspace (even if you’re an admin or user with ANALYZE permission) and try to add a new dashboard then drag&drop an insight from the “New Item” on the left then the screen below appears for 1 sec after it disappears and the parent workspace will be loaded into some kind of embedded window. You can do this multiple times and there will be more and more embedded windows there and you couldn’t go back just with a full page reload. Images attached.We haven’t found any error messages neither on backend and frontend. Could you please investigate this bug?  ThanksZoltan   

15
U
GoodData Employee
1 year ago
jamesjenkins
jamesjenkinsKnown Participant
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)”.

10
jamesjenkins
7 months ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

How to use order by in the table insight

Hi,  i want to order by Month name column where i want January in the first row,February in the second row and March in the third row.how to do that.please find the attached image for the sameThank you

9
Moises Morales
GoodData Employee
7 months ago
V
Vasiliy OstrovskyKnown Participant
asked in Dashboards and Reports

Incorrect filtering of running sums

Hi! I’m facing following problemWhen I choose Sum in measures and set date filter to All time, I get these data When I set data filter to This year I get the same data but filtered by year 2021. And it looks right. When I choose Running sum in measures and set date filter to All time, I get running sums groupped by years. It’s still right When I try to filter running sums by This year I expect to get running sum filtererd by ths year, in this expample - 1327. But  I get the Sum (not Running sum) - 51. Is there a way to get what I expect? 

9
V
2 years ago
G
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?

8
J
GoodData Employee
7 months ago
mares
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 

8
mares
10 months ago
Q
qian zhengInspiring
asked in Dashboards and Reports

How to integrate PGP using python

Hello teamI am currently trying to encrypting the message using PGPY library on python side so we can generate the claim for front end to use to integrate dashboard through pgp SSO. However I am stuck at the `sign` stage , all the signed message seems not able to be decrypted on Gooddata side, error: The error message is Cannot decrypt SSO message from sso provider=pgp-test.polyai-test.<hidden> Invalid sessionIdError code='sso.decrypt'Request id='aN3MEuAqWGt8SSrK:woOj0utfTAwppYz4' Look like pgpy only support clearSign by looking at the source code. ( At least that’s what I think why Gooddata cannot decrypt it) I wonder if there is any suggestion on how to encrypt the message using python instead of using gnupg ? That will be super helpful ! Thanks so much

8
Jan Kos
GoodData Employee
1 year ago
G
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   

7
Iva Gasparekova
GoodData Employee
7 months ago
Breck
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.

7
Joseph Heun
GoodData Employee
7 months ago
jamesjenkins
jamesjenkinsKnown Participant
asked in Dashboards and Reports

Creating insight error message

Whenever I try to add a new insight onto a dashboard I keep getting this error message: electric-wasp.trial.cloud.gooddata.com refused to connect. Does anyone have any ideas how to resolve this? I have tried multiple devices and browsers  

7
J
5 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
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
3 months ago
Z
ZafarNew Participant
asked in Dashboards and Reports

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

7
G
Community Manager
1 year ago
nathanliu
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?

7
Michael Ullock
GoodData Employee
11 months ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

Create Paragraph,Table and other formats in single insight

Hello,Can you please let me know if it is possible to create a single insight like the attached format.If yes, Please do explain me how!!@Mansi  @Martin R Thank you

7
P
10 months ago
G
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  

6
Moises Morales
GoodData Employee
7 months ago
hanka
hankaKnown Participant
asked in Dashboards and Reports

Automated migration of dashboards / insights to use new attributes

Hello!As I have updated my data model a bit, I’d like now to migrate all the dashboards to use new attributes in place of the old ones.What can be done to automate it, at least partially?https://help.gooddata.com/doc/enterprise/en/workspace-and-user-administration/managing-workspace-data-and-data-access/manage-attributes/find-where-an-attribute-is-used/ article shows the usage of `https://secure.gooddata.com/gdc/WORKSPACE_ID/usedby2` endpoint, so I can check which old attributes are used where. Unfortunately I couldn’t find any documentation page describing which categories of the returned entities means what. Some are self descriptive, but not all.So, knowing how my old attributes are used, and to which attributes they should be changed instead, what are the options, preferably via Ruby SDK or grey pages endpoints, to update existing dashboards/insights/metrics, so it doesn’t have to be made manually? Best,Hanna 

6
Marek Horvát
GoodData Employee
5 months ago
nathanliu
nathanliuParticipating Frequently
asked in Dashboards and Reports

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?

6
Moises Morales
GoodData Employee
1 year ago
Edip_TH
Edip_THNew Participant
asked in Dashboards and Reports

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?

6
Edip_TH
1 year ago
M
MarketaParticipating Frequently
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?

6
M
5 days ago
tylervaleo
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!

6
Joseph Heun
GoodData Employee
11 months ago
hanka
hankaKnown 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

6
hanka
8 months ago
K
Konstantin KomissarchikNew Participant
asked in Dashboards and Reports

More than two columns in a dashboard

Is it possible to customize the dashboard layout to allow more than two insights on one row? The dashboard editor is limiting to two per row. For my usecase, I am trying to have about half a dozen horizontal bar chart insights on one row, to show different slices of data all at once. 

5
Moises Morales
GoodData Employee
1 year ago
J
JamesParticipating Frequently
asked in Dashboards and Reports

Column Chart Truncated In Dashboard

I’ve created a perfect column chart insight, with a column for each hour. However, when I visualise it in a dashboard, it’s cut off a 3pm. Is there a way to fix this? Even when I drag the insight to cover more space, it’s the same issue…  

5
Iva Gasparekova
GoodData Employee
3 years ago
Welcome to the GoodData Community!Cookie settings