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 GoodData23
AnalyticsDashboards and Reports111 Metrics and MAQL86
Data modeling & IntegrationData models30 Data sources57
Development & AdministrationGoodData.UI32 Administration71 Solution architecture6 SDKs and APIs20
GoodData For FreshdeskNews & Updates3 Got a question?10 General Information1

Ask your question
Login

Community
Analytics

Analytics

Analytics

197 Topics

Most views

Recently active Most replies Newest first

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

LenaKnown Participant

asked in Metrics and MAQL

How can I custom a attribute or metric in Date format?

Hi,I want to get the latest Date group by a attribute in mm/dd/yyyy format.My code is :select MAX(Date (Ticket Created Date)) BY EntityIDAnd I edit “Metric format” to “mm/dd/yyyy” format, but it doesn’t work.Do you have any better idea?Thanks for your help!

NickKKnown Participant

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

Simone HaasNew Participant

asked in Metrics and MAQL

Calculating how many days are invoices past due

Hello there. I uploaded our invoice data into GoodData and I would like to create a report where I will see how many days are open invoices past due. I do not have this number in my source data, I have just due date. Is it possible to calculate it? Thank you. Simone

A

Anonymous

asked in Dashboards and Reports

How does GoodData cache reports?

Hi, can you please help me to understand if and how GoodData caches reports and dashboards? Is there a way how I can fine tune the caching parameters like frequency, cache invalidation and so on?

TommyGNew Participant

asked in Metrics and MAQL

DateDiff in MAQL?

Hi there everyone,I was just wondering if there is a simple way to perform a DateDiff function in MAQL. More specifically I want to be able to count number of days between Order Date and Today. I will be using Order Status to determine whether the order was completed and this MAQL metric would help me in highlighting those that take too long. Thanks a lot,Tomas

asked in Dashboards and Reports

Embedding web content on dashboards

Can I embed web content in the Analyzer to play for example youtube videos on a dashboard?

dudoffNew Participant

asked in Metrics and MAQL

How do I create a metric with I am trying to count records that have a NULL value

Hi I have a fact that can be Null at times.I can count the records where it is not nullselect count(attribute) where fact > 0.I am trying to count the amount of records that are null.I do not see anything in the MAQL guide for that. Is there a way?I tried fact = 0 even know I know null is not 0.I tried fact <=0 Neither worked.

Sankar SandipNew Participant

asked in Dashboards and Reports

GoodData embedded analytics on public web

Our intention is to have analytics on our public website based on our data. It should include also a report builder. Can GoodData do that?

Leilani GreerGoodData Employee

asked in Dashboards and Reports

Maximum Result Size for Report

Hello, Sometimes I get a response of “TOO MANY DATA POINTS TO DISPLAY”. What is the maximum result size that is supported / recommended for a report?

Leilani GreerGoodData Employee

asked in Metrics and MAQL

Metric vs Measure and Best Practices

What is the difference between Metric and Measures .... Are there best practices around when to use which one ?

JamesParticipating Frequently

asked in Metrics and MAQL

How To Ensure A Metric Available In Analytics Designer

Hi I created a metric based on two values that I’m using in an insight. However, when I use the metric ( a measure that simply chooses which of the other two measures should be shown) I get a message saying “Sorry, We Can’t Display This Insight”. And then when I use other data values, it moves into “unrelated data measures” Do the metrics need to be applied to the LDM? Or do I need to somehow associate the metric with a given dataset? Thanks James

Julia KNew Participant

asked in Metrics and MAQL

Timestamps - I need to calculate how many users were active each minute, having single intervals of their activity

Hello!The problem I’m struggling is how to create an AMR (Average Minute Rating) using MAQL. For simplicity I started with one day period when I want to observe how users activity changes over time (for example minute by minute). So I have data of a form:userID start time - atribute refering to Start time table having M, H, S values as a facts, start time label as a key HH:MM:SS and an atribute start time [min] HH:MM start day - date end time - atribute refering to table with a structure like Start time table already described end day - date activity detailsI was able to build a very inelegant vay to find out how many unique users were active during particular hour (e.g 20:45 HOUR = 20, MINUTE = 45), but with one major drowback which is that I need hour and minute as a variable to do those calculations. Here’s the MAQL form:I need solution that could be visualised - for every minute, automatically. Hoping for your help! I would appreciate any hints :)

Leilani GreerGoodData Employee

asked in Dashboards and Reports

Embedding iframe into dashboard

Can I embed another iframe into the KPI dashboard?

Augusto SilvaNew Participant

asked in Metrics and MAQL

Building of an MAQL for Rolling Average

We have a table with several records where we need to perform the moving average of the last 90 days considering only grouping by one column (fluxo_id_card).If we don't consider the rolling avarage, the calculation is performed as follows:But what happens is that we need to display these results in a month-to-month progression, where each month we view the average of the last 90 days.For the Rolling average, the basic syntax is:But we don’t have a certain number of lines that each card would occupy, and that Rows Between does not currently support the COUNT function.How can we adapt this calculation to the new context without changing the original table in the model?

Ulku KijasevGoodData Employee

published in Dashboards and Reports

Data Permissions, Variable Filters and User Permissions and Custom Roles in GeneralArticle

Data Permissions If you want to restrict the access of your data in a workspace, to some of your users then you can use data permissions. The data permissions are set based on values of the attribute. Think of that, you want to create a report to display the invoice item quantity and the sum of prices on country and product basis. And you want to restrict the display of invoice item data based on the user's country. The users will be able to see invoice items only corresponding to their country to achieve confidentiality. Then the report should filter the data based on the attribute value of the Country attribute. The data permissions are hidden from the user, the user does not know that the data is filtered and can not change the data permission. The value of the attribute corresponding to that user, is passed as a hidden parameter with each query to the database. And the data permission is applied to all of the workspace. In order to understand data permissions better we can give an

Leilani GreerGoodData Employee

asked in Dashboards and Reports

Can I limit which insights or reports can be edited by users

Hello, Is there a way to allow my customers to only edit specific insights or reports when utilizing my gooddata whitelabeled domain?

plaubeKnown Participant

asked in Metrics and MAQL

How to use date metric into next filter metric - MAQL

Hello, please help me. Table Aid_table_a INTa_date DATE I would like to find rows for LAST MONTH a_date.

asked in Dashboards and Reports

Embedding KPIs

Can KPIs and insights be embedded directly instead of the whole dashboard?

Robin BoltonNew Participant

asked in Dashboards and Reports

Embedding Analytical Designer

Analytical Designer is really nice tool for ad-hoc analysis. Is there a way how to incorporate it to our web application? Thank you.

Leilani GreerGoodData Employee

asked in Dashboards and Reports

Question on tables in both Analytical Designer and Pixel Perfect Reports

Can tables support pagination ?, column level search?, URLs in cells, banded rows & columns?" If you can specify the answers between PP Reports and Analytical Designer that would be great!

PD5Known Participant

asked in Metrics and MAQL

How to filter by 2 different dates

I have a data model with orders and refunds in separate tables. I would like to use MAQL to create a metric showing the sum of all the order totals, less the sum of all the refund totals for a particular date and/or date range. The problem is that the two tables are using different dates. The orders table has “date the order was created” and the refunds table has “date the refund was created”. This is fairly simple in pure SQL using 2 sub-queried, Is there a way of making this work in an MAQL query? Edit: I should also mention that the order refunds table is linked to the orders table via the order id which complicates things further.

jeny.mNew Participant

asked in Metrics and MAQL

Null column

Hello, Can we create a custom column with a null value? On our dashboard, customers would be extracting the report(table) and some columns should be left as null as they will be the one who will fill them with values.

Allan TalverNew Participant

asked in Metrics and MAQL

Linking two unrelated datasets in MAQL

Hello,I am attempting and failing to write some MAQL queries.I have two datasets with the following fields (model simplified from the real world case, which has many more attributes for contracts):Contracts Vendor name Contract currency Contract value in contract currency Exchange Rates Currency Date Rate The Exchange Rates are stored as a rate between the respective currency and our company main currency. The exchange rate for the main currency being stored as 1.I need to build a report which shows list of contracts (by vendors) with several metrics, including contract value:in our company base currency in the currency selected in a dropdown selector of the dashboard (the exchange rate for the current date should be used for conversion)I have been trying to build the metrics, but I have not succeeded yet. I have started with creating a metric which would get the current day exchange rate for each contract:SELECT SUM( SELECT SUM(Rate) BY Date, Currency ALL OTHER )BY ALL OTHEREXC

Linda JInspiring

asked in Metrics and MAQL

Date Math

Hello -I am trying to create a metric for a date last yearfor example my selected date filter is 2/01/2021 - I want the answer to be 2/01/2020 I also would like to be able to subtract months as well so 02/01/2021 would be 01/01/2021 Thank you

1
2
3
4
...
8

Page 1 / 8

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