To GoodData homepage

Replies posted by michal

10 Replies

Jacques Sham
GoodData Employee
Jacques ShamGoodData Employee
published in Metrics and MAQL - KB articles

Running Total Function in GoodData Platform (Sum vs Runsum)

Hi @John , form your screenshot I assume in the second column you have plain SUM of revenue (revenue being in your data or somehow calculated as a simple metric) and the third column should be YTD of this revenue, correct? Assuming you do not have any data for the future, this metric for the YTD should work: SELECT SUM(Revenue) BY Year (Date) WHERE Year (Date) = THIS WITH PF EXCEPT Date (Date) This metric should give you YTD for current year and it will also work if you use a date filter to just filer out the current month. Here is how it works:the SUM(Revenue) BY Year makes sure it sums the data for the whole year even if you split the result by month (technically it assigns the SUM value for whole year to each month of the year) the WHERE Year = THIS filters out any data from different years and the WITH PF EXCEPT Date (meaning “with parent filter except date”) disables the effect of any external date filter to this particular metric (just this metric, other metrics in the same i

3376
M
GoodData Employee
8 months ago
K
kaviKnown Participant
asked in Dashboards and Reports

Show state names instead of coordinates using geo pushpin field

Hi kavi, if I understand it correctly, you are using both the new Analyze and the legacy PixelPerfect experience and in both cases you are using the geocharts and therefore you need the text label to be marked as US State code, right? There is actually one way how you can make the desired label to be displayed by default in a table (and elsewhere) without the need to add additional label.  To do so, you need to make the desired label “default one” in the modeller for that attribute. Then when user selects the attribute (either in Analyze or in Pixel Perfect) it will always display this label as default and it does not matter whether it is marked as Text or US State Code.  It will also make this label displayed by the Analyze geochart (which you otherwise can not choose). This change should not affect any of your dataloads or mappings, they remain the same.  To do this:go to the edit mode of the modeller and click “More -> View Details” in your dataset there in the Field (first) tab

7
M
GoodData Employee
8 months ago
jamesjenkins
jamesjenkinsKnown Participant
asked in Metrics and MAQL

Average age from date of birth

Hi James, please try this code, it should work. SELECT AVG( (SELECT DATETIME_DIFF( {DateOfBirth - Year{label/DateOfBirth.year}, THIS(YEAR) ) BY {dataset/your_dataset} ))the last error message is complaining about missing aggregation so we need to wrap the function to AVG - you had it in your original code.And I also added the “BY dataset” part. It might not be needed in insights with the primary key from the dataset where the date exists, but it might not work if you would just use it alone (i.e. to display AVG age as a headline) or some other attribute. The “BY dataset” in the inner metric - in your case please use the identifier of the dataset in your model - will ensure that this metric can be also used alone or with non-key attribute. Technically any Date in GoodData is a separate dimension dataset which can be referenced from other datasets, so by this we are telling the system to use the date in connection with your dataset.

6
jamesjenkins
8 months ago
L
Luis CarricoNew Participant
asked in Administration

Users Brick - "Cannot reach url" error

Given the parameter names in your configuration like ${analytics-configuration.username}, I assume you are using data sources. If the same/similar configuration works for the provisioning brick and fails with “Cannot reach the url” for user brick, I would suggest to double check that you have the user brick deployed with the data source (analytics-configuration in this case).The parameters from the data sources are only propagated to the schedule if the data source is explicitly mentioned in the deployment of the process. If not, the schedule would not be getting the value of the datasource parameters and I believe that might be causing this issue.You can check if it is deployed with the data source(s) in the Data Integration Console UI if you click “Redeploy” button next to the process. Right under the “COMPONENT” there should be “additional data sources” section with your data source selected.If the data source is not there, you can add it.NOTE - If you don’t see the “additional data

4
L
9 months ago
mares
maresParticipating Frequently
asked in Dashboards and Reports

Start End Date bar chart by Months

Hi @mares, I am afraid that you are right that GoodData currently does not handle this type of transformation in MAQL. As you already found out, each date is treated as separate date dimension and in each insight you need to specify which date dimension to use. In your case you can view your data by start date or end date, but what you really want is to view it by some third date something like “continuous subscription date” and this is not in your data model. So to display this type of visualization in GoodData, you would need to slightly modify your model and do some data pre-transformation (either physical in ETL or in a view under your dataset). You would be aiming to something like this::display_month subscribed_user_id unique_row_id jan-22 1 1 feb-22 1 2 mar-22 1 3 apr-22 1 4 ...     jan-22 2 5 feb-22 2 6 mar-22 2 7  That means pre-calculate data in SQL so that for each month for which a user has an active subscription, there is a row

8
mares
1 year ago
N
nikoParticipating Frequently
asked in Data models

Using "event" dataset

Hi Niko, thanks for the detailed description.From your database diagram, do I understand it correctly that the project_phase actually has two different relations:current phase in which the project is right now (represented by the project_phase_id in project table) historical phase which a particular project entered or left at a particular moment (represented by the project_phase_id in the project_phase_events table) If you would model it the way you did initially (with the orange triangle), if you would let’s say want to count number of projects entering “phase A” in January, the system would not know how to filter by the “Phase”. It could mean two completely different things:Projects which are currently in phase A (join project_phases to projects and filter there) Projects that entered phase A historically in January (join project_phases to project_phase_events and filter there) no matter in which phase they are currently.In GoodData in this kind of relationships, each relation (direc

9
N
1 year ago
K
Keith FinnNew Participant
asked in Administration

Changing of domain admin

UPDATE: since September 9 2021, it is now possible to have multiple domain admins in GoodData domain. And to add new domain  (if you have access to the existing domain admin), you no longer need to contact GD support. You can list the domain admins, add and remove the domain admin role with an API as described here: https://help.gooddata.com/api#/reference/domain-administrators.

2
M
GoodData Employee
2 years ago
T
Tom HarrisNew Participant
asked in Data sources

What is difference between ADS and other cloud data warehouses you support?

Hi Tom, great question.GoodData tries to offer analytic solution for various types of organizations. Some of them have their own cloud data warehouses and data processing tools and GoodData offer those to prepare their data using those tools and load them GoodData workspaces directly. For those who do not have this option or can not use it for any reason, GoodData is offering the ADS option. With ADS comes a set of tools to download data from various sources and integrate the data into ADS as well as perform a data transformation using SQL. Because the ADS is collocated at the same data center as GoodData workspaces, the connection betweeen those two is very fast. Apart from the storage and transformation piece of the “end-to-end” data pipeline you can utilize the ADS also for other analytical operations. And one interesting piece might be also pricing, unlike many of the cloud data warehouses, currently ADS is not charged per query or time consumed. 

1
M
GoodData Employee
3 years ago
R
Robin BoltonNew Participant
posted in Solution architecture

Benchmarking in GoodData

Hello Robin, yes this is good approach - this is exactly how you do benchmarks in GoodData - add a new dataset into which you load aggregated data from all the customers and connect this dataset to the rest of your model by a “shared dimensions” - those by which you want to benchmark. This will allow you as well as your users with ad-hoc permission to use the benchmark data.A few notes to it for some best practices:Usually the facts in the benchmark dataset are similar to the facts in the standard datasets. It is good practice to make it clear from the name whether it is benchmark or actual value (i.e. prefix the benchmark facts with “Benchmark”) - it helps you and the users who have self service rights to better understand which is which for example in the Analytical designer or Metric editor when there is not immediately clear from the name, which dataset the fact is from. (i.e. Benchmark Duration - minutes). If your benchmark values are the same for all your clients and you are load

2
R
3 years ago
P
Philip OwensNew Participant
asked in Administration

Do I need a white-labeled domain to be able to embed a dashboard?

For just embedding dashboards, you do not need to have CORS or whitelabeled domain. You can easily embed from standard gooddata domain.However GoodData is using cookies and in case of embedding, these cookies will be considered as third-party cookies, and some browsers might block third-party cookies by default. To resolve this, whitelabeled domain with top level domain matching the one of your application into which the dashbaord is emebdded is needed (so the cookies are not treated as third-party). Read more about this here https://support.gooddata.com/hc/en-us/articles/215781937-Known-Issue-Blocking-Cookies-May-Make-Embedded-GoodData-Inaccessible 

2
M
GoodData Employee
3 years ago
Welcome to the GoodData Community!Cookie settings