To GoodData homepage

Knowledge base
AnalyticsDashboards and Reports - KB articles8 Metrics and MAQL - KB articles23
Data modeling & IntegrationData models - KB articles9 Data sources - KB articles9
Development & AdministrationGoodData.UI - KB articles12 Administration - KB articles18 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData13
AnalyticsDashboards and Reports161 Metrics and MAQL108
Data modeling & IntegrationData models35 Data sources69
Development & AdministrationGoodData.UI38 Administration86 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Search

Replies posted by Francisco Antunes

23 Replies

Oldest first

Newest first

Mark PetersonNew Participant

asked in Metrics and MAQL

Is it possible to create a Metric for the "last known value"

Hi Mark, In this case, I think the MAX function would achieve the results you are looking for. As our support article MAX describes, this function can be used to display the maximum value. How exactly you implement this function will depend on how your Logical Data Model is set up. In its most basic form, you’d be looking at a query like so:SELECT [desired value] WHERE MAX(Date)This would display only the most recent entry (i.e., the one where the Date value is the maximum). You can also refer to this Classic article Finding Min and Max Dates Using Date Arithmetic. It is for an older version of the product, so some aspects of the UI may be different than what you are used to, but the logic there still checks out. In order to create a solution that better matches your data, please give us a bit more information about how it is configured in GoodData. A more in-depth explanation of how your data is set up, or a screenshot of your LDM, would be most helpful in this case. Best regards,Fran

Mark PetersonNew Participant

asked in Metrics and MAQL

Is it possible to create a Metric for the "last known value"

I would also like to suggest some additional reading, to help you better understand how Dates work in GoodData. See below:Dates and Times - This article has a comprehensive explanation on how GoodData handles Date values and how it structures them in the LDM (Logical Data Model). Filters in the GoodData Platform - This one contains information about using Filters in GoodData (including filtering using Dates). I would also suggest checking out the following GoodData Community posts raised by other users, with interesting questions about using Dates in our product: How can I custom a attribute or metric in Date format? Data update I hope these are helpful! Let us know if you would need any more help. All the best,Francisco

hankaKnown Participant

asked in Data models

CSV data upload and big datasets

Hi Hanna,Thank you for reaching out with this! Let’s talk about the CSV header limit.Although GoodData’s Platform Limits do specify a 250 column limit for CSVs, this is actually not a hard limit. It is the official supported limit but the platform is able to load larger column numbers. Nevertheless, it is not a recommended action, as we do not guarantee that it will work consistently and will not be able to provide support if it fails (other than recommending to follow the official limit). In other words, you may surpass the 250 header limit, but it is not a supported action.Please note that increasing the width of a loaded dataset also increases the loaded data volume and processing times. This may lead to the breach of some of the other platform limits described in the article I shared above (and some of those are indeed hard limits), as well as negatively impact performance. The best practice is to attempt to optimize how your data is structured and loaded, to avoid such issues. I w

kaviKnown Participant

asked in Metrics and MAQL

Migrate Computed Attributes between Workspaces

Hi Kavi,Thanks for putting this in. Thank you for the screenshot and the detailed description of your steps, too. They were much appreciated! I was able to reproduce the exact message you got on my own testing environment.The Poll message you got occurs when you copy the JSON structure but instead of pasting it on the Target workspace (Step 4), you pasted it on the Source workspace itself. Please take a second look at Step 4 of the article and make sure that you update the endpoint there to match the Target (in this case, PROD) workspace ID. The scripts should generate correctly then.Let me know if this does not resolve your issue and we’ll continue to investigate. Best,Francisco

kaviKnown Participant

asked in Metrics and MAQL

Migrate Computed Attributes between Workspaces

Hi Kavi,Thank you for confirming you were pasting on the correct workspace! I did some additional checking from my end.The endpoint you are using on the Target workspace, “projectmodelDiff”, produces a script based on the differences between the two projects (in their computed attributes). The output you received (which I replicated by using the Source workspace twice) means that the tool found no difference between the two workspaces; thus, it cannot create a script to amend these differences.Would you kindly provide a bit more detail about the task at hand? What kind of changes you are trying to propagate? Have you use this feature successfully in the past? Has anything changed in your environment?Could you please confirm the computed attributes are not already present on the target workspace, too, just to be sure?Also, note that the procedure from the article is not required if you have the LCM features enabled on your environment, as the LCM bricks already migrate the computed att

kaviKnown Participant

asked in Metrics and MAQL

Migrate Computed Attributes between Workspaces

Hi Kavi,Thank you for the additional details and for confirming that the Diff might not be accurate, in this case.At this point in the case we will need some more specific information to continue investigating, so it’s best for us to proceed elsewhere. We will be in touch with you directly via email very soon with the next steps. Thank you!Francisco

GSawdyParticipating Frequently

asked in Dashboards and Reports

Table visual won't convert to chart

Hello,Thanks for putting this in. I see that you’ve built an insight that works as a table, when the main metric is sliced by both Campaign and Date; However, when you switch it to a Bar chart and remove the Campaign attribute, the insight breaks.As the CASE article explains, using CASE without an Aggregation container makes it unable to be sliced by attributes from other dimensionalities. I believe that is the case here, since the Date attribute is from a different dimension as the rest of the metric. This also explains why the insight works when also sliced by Campaign (it is in the same dimension as the components of the metric).The solution would be to encase the entire metric inside a SUM aggregation, to enable it to be sliced by attributes from other dimensionalities. The article I shared above explains how to do this in more detail, in the How to Use CASE Correctly section.Please try implementing the solution above and let us know if it works! Best,Francisco

GSawdyParticipating Frequently

asked in Dashboards and Reports

Table visual won't convert to chart

Hello,Thank you for the additional information. I see that placing the metric inside a SUM aggregation did not resolve the issue.I would like to suggest a different approach for trying to connect this metric to the desired dimensionality. It is called Explicit Lifting. The article is from our Legacy documentation, and as such some of the screenshots will be out-of-date for your case, but the procedure itself is still valid. The idea is that we can use the BY keyword to connect the metric to a dimensionality that it wouldn’t be able to use otherwise. The exact implementation will depend on your LCM, but I would suggest trying out adding BY Campaign , for example, at the end of the metric. Make sure to keep the SUM aggregation. If the solution above also does not work, would you mind sending us a couple of additional screenshots?Please take a screenshot of how the insight looks on the Analytical Designer when you switch to the bar chart (we’d like to see how the visual ‘breaks’) Please

GSawdyParticipating Frequently

asked in Dashboards and Reports

Table visual won't convert to chart

Hi,Thank you for the screenshots and additional context. In this case, the best path forward would be for us to check your workspace directly and troubleshoot the insight from there.We will contact you via email directly very soon with the next steps! Best,Francisco

kaviKnown Participant

asked in Data sources

When I'm trying to run the ADS Integrator I'm getting an error called Error Code: 404 Not Found

Hi Kavi, Thank you for sending this in. I’m sorry to hear about your troubles with the ADS Integrator.With the information you provided I was able to locate the error logs for this particular issue. Although the 404 error you received isn’t very detailed, I traced back the request and have some suspicions.The error logs I found indicate missing configuration files, which could indicate some inconsistency between the output of the CSV Downloader and the expected input of the ADS Integrator. Were any changes done recently on any step of the ADD pipeline, or on the ADS instance? If so, a possible solution would be to delete all the files created by the CSV Downloader (batches, metadata, caghe), running it again to re-create them and then trying the ADS Integrator once again. Such a “clean-up” has resolved similar issues in the past. Please give that a shot and let us know if the issue persists or evolves. Best regards,Francisco Antunes

yogiNew Participant

asked in GoodData.UI

feasibility to navigate to custom url from a table visual.

Hello Yogi,I assume that you built or embedded this visualization via the GoodData UI SDK, correct? If so, it is indeed feasible to set up Drilling to URL, but it does not work out-of-the-box (i.e., via the UI like in Set Drill into URL for GD Cloud) and needs to be implemented. When using Drill to URL on an embedded visualization, the appropriate events are still emitted, but no action is taken. You’d need to use the eventHandlers prop documented here to listen to them and apply a custom action (redirect to another dashboard, redirect to another URL).Here's a recently added example in the Component Gallery that describes how to do that I’d also recommend taking a look at the Gooddata.UI SDK article DrillableItems for some additional info. Best,Francisco Antunes

anastasie.pustovalova

asked in Metrics and MAQL

Grouping attribute values and then using the group to filter data

Hello Anastasie,I understand what you would like to do here. I’m afraid that it is not possible to configure that on GoodData’s end; that would have to be set up on your Source Data by creating an additional attribute (i.e., a new column) and assigning the values there.Using your example, imagine you have on your source data a table with the columns Region City id To be able to filter by States would be necessary to add this value as a column to the table, assigning a state to each row, so that it would consist of:State Region City id Thus creating a new Attribute on the Dataset corresponding to this table, which you could use to filter your insights and dashboards. The filters rely on the existence of the attribute they are filtering in the Datasets. In fact, I would argue that a group of attributes is just another attribute, with different granularity. The article Filters in the GoodData Platform has some additional information about using filters in GoodData, feel free

anastasie.pustovalova

asked in Metrics and MAQL

Grouping attribute values and then using the group to filter data

Hi Anastasie,In such a case, you would be working with a Many-to-Many relationship (i.e., regions have multiple cities in them, but cities may also be assigned to multiple regions). It can be complex to configure, but our article Many-to-Many in Logical Data Models is a good starting point for the different ways of setting it up. Please take a look there. But the short of it is that the Regions would have to be in a different Dataset, connected to the original one with a M:N relationship. Francisco

kaviKnown Participant

asked in Dashboards and Reports

Show state names instead of coordinates using geo pushpin field

Hi Kavi,Thanks for sending this in. The community article you linked is indeed correct. You may also refer to our documentation here. It is also recommended to check out the GoodData University course about the subject. In this particular case, the problem you are encountering is most likely caused by using the incorrect Label. You see, the Coordinates you use for pushpins are added as Labels to an existing attribute (usually City or State, for example). When you change the visualization type, it’s important to make sure that you select the correct label for the attribute in the Analytical Designer, using the Display as… selector: Please check out the resources I shared and try using different labels to get the results to look the way you’d prefer them to! Best,Francisco

kaviKnown Participant

asked in Dashboards and Reports

Show state names instead of coordinates using geo pushpin field

Hi Kavi,The label type US States (2-letter code) was used on Geo Charts for the legacy Pixel Perfect UI; it doesn’t really interact with the new UI and the Analytical Designer, unfortunately.As such, if you have the Recipient State codes or names in your Source Data, please try changing the label type for Recipient_State to Text, like it is on your Scenario 1. It should allow you to select it in other visualizations.You can make that change by going to Manage > Attributes; then, select the Recipient_State attribute and Edit on the US States label. Give that a shot and let us know if it works out. Francisco

kaviKnown Participant

asked in Dashboards and Reports

Show state names instead of coordinates using geo pushpin field

Hi Kavi,Thanks for trying it out, I’m sorry to hear it didn’t work out. It’s also a good confirmation that the US States works in the new geo charts too, I stand corrected on that one.Since you’re using the US States label on the actual geo chart, and renaming it breaks that particular visualization, the solution here would be to add a new Text label to the attribute (with the corresponding column on the source data), so you can use it in Tables too. Creating a new attribute from scratch would work as well.Another option would be to edit the GeoChart insight and see if you can change the US State label there to Coordinates instead (but then, if you mouse over the state it would show the coordinates instead of the state name), thus freeing the other label to be used as a Text. Best,Francisco

kaviKnown Participant

asked in Dashboards and Reports

Failed to download .xlsx file

Hi Kavi,Out of the box, exporting Reports to XSLX is done either from a drop down menu on the report, in the dashboard, or from the Reports section of the GoodData workspace, as described in this article. The download button you are using seems to be a custom implementation. Can you describe how it works? Is it a drill-to-download button?Is this affecting only a single user, or multiple people? Is it confined to this particular Dashboard/button or affecting the XSLX exports for the entire workspace?You described that downloading other formats (which I assume have their own buttons) works correctly. I would suggest starting by reviewing the button widget for the XSLX download itself first to make sure there are no issues there (say, a mistake in the URL). I would also suggest trying to download the report using the instructions on the article I linked above, to see if it’s working there. Lastly, please note that GoodData is unable to export GeoCharts and Key Metric widgets to XSLX, as p

kaviKnown Participant

asked in Dashboards and Reports

Failed to download .xlsx file

Hi Kavi,Thank you for the extra info. Given that the download button is distributed via LCM and that all other instances of the same widget are functioning correctly, I think we can set aside any issues with the configuration of the button itself for now.I am curious about how the error occurs in this workspace. Are you able to reproduce it yourself? You mention that it affects one customer in one workspace - is this a single user, or all users on the workspace?Here are a few ideas:Try checking the affected users, to ensure they have the rights to access the Report that is being downloaded (I would assume they do, if the other buttons for the same report work too, but it is good to confirm). Depending on how frequently you run the LCM, it could be possible that the configuration of the workspace was changed between runs, which could break the feature. Has the Rollout brick been run since the issue started? It could be a good way to ensure that the workspace is conforming to the standar

Jay FineganParticipating Frequently

asked in Metrics and MAQL

Counting records by metric

Hi Jay, Thanks for reaching out!I appreciate the thorough explanation and the screenshot. I think I understand what you are looking to achieve here. Basically, you want to have a Pie/Bar chart showing the total number of injuries (each one defined by Injury ID), viewed by the Length of Service. In this case, I think the solution would be to create a Pie/Bar chart where the Metric is the COUNT(Injury ID), Viewed by Length of Service. The results should be the count of injury per Length bucket. Please give that a shot and let me know if it works out! Best,Francisco

Jay FineganParticipating Frequently

asked in Metrics and MAQL

Counting records by metric

Thanks for the extra info! Indeed, that would not work out. I gave it some thought, and here’s the idea I came up with:Create a separate metric counting the Incident ID for each result or range of results from the Length of Service metric. Something like this:SELECT COUNT (Incident ID) WHERE (SELECT Length of Service by Bucket BY Incident ID) = 1 orSELECT COUNT (Incident ID) WHERE (SELECT Length of Service by Bucket BY Incident ID) BETWEEN 5 AND 10 You’d end up with 4/5 such metrics (which is the downside of this method), one for each result range (defined by the WHERE conditional). Then, add all of them to the Metrics section of your Pie chart. I tested it on my end, and it should get you the results you are looking for! Let me know if that one works out better! Francisco

Jay FineganParticipating Frequently

asked in Metrics and MAQL

Counting records by metric

I’m sorry to hear it didn’t work out. Having Length-of-Service as an attribute would resolve this, for sure.Feel free to let us know if you have any further questions, or run into any trouble while implementing this. Best,Francisco

deedeeduduNew Participant

asked in Metrics and MAQL

Metric with BY ALL condition is not working properly

Hello there!Thanks for the explanation, I was able to re-create this scenario on my end and have a solution to propose.In this case, the problem is that the filter you are using to select the countries also interferes with the calculations - the metric calculates the Total customers based on what’s currently on the visualization (so if you only select Brazil and Argentina, it will consider the total Sum of Contacts to be 40, not 100).The solution is to use the WITHOUT PF keywords to make it so the filter selection doesn’t interfere with the calculations. This way, even after removing countries from the visualization, the ratio will be calculated against the total number of Countries. It still allows you to use a TOP filter, as well, from what I tested.Let me know if that works out! Best regards,Francisco Antunes - GoodData Support

RenaudDNew Participant

asked in Metrics and MAQL

Metric to count periods

Hello Renaud,Thanks for reaching out with this question. It was very neatly laid out, and the example Table illustrated perfectly what you’re hoping to achieve here! In fact, the logic behind the query you wrote is quite accurate to get these results - we only need to adapt the syntax to work with MAQL.The solution involves utilizing the MAX Function in combination with the Date dimension that you’ll use to filter out your Insight. It’s explained in detail in the article Finding Min and Max Dates Using Date Arithmetic, but here’s an example solution for your use-case:You’d start by creating a couple of metrics that you’ll use to define MAX(Date) and MIN(Date) - which, when used with a Date Filter, will result in the last date on the filter and first date on the filter, respectively. It’d be something like:SELECT MAX (Date(Registration_End)) andSELECT MIN (Date(Registration_End))We’re using Date(Registration_End) because that’s the dimension that really affects the logic - even when the

Powered by Gainsight

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

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