To GoodData homepage

Replies posted by Jakub

11 Replies

G
GSawdyParticipating Frequently
asked in Dashboards and Reports

Conditional format headline visual comparison percentage

Hi,see here: https://help.gooddata.com/doc/growth/en/how-to-get-started-with-gooddata/share-gooddata/embedding-dashboards/ or https://sdk.gooddata.com/gooddata-ui/docs/embed_dashboard.html .Please raise a separate new question once the topic is marked as Solved. Thanks,Jakub

8
J
GoodData Employee
1 year ago
K
kaviKnown Participant
asked in Metrics and MAQL

Accept the date while year starts with 0

 Hi,and thank you for the confirmation. You can create a custom date dimension and redefine the range but we do not recommend to go outside of range 1900 - 2100 Second link I provided contains relevant info:Extended Date DimensionsBy default, the urn:custom_v2:date date dimension template contains data for the Gregorian calendar from 01/01/1900 to 12/31/2050. You can extend date dimensions in custom calendars beyond the default to cover dates from 01/01/1900 to 12/31/2100. However, wider defined ranges may result in slower performance. To improve performance when using custom date dimensions, do not use unnecessary ranges outside of your data and analytical use cases. For example, if you only need to analyze 2010 to 2030, keep your custom dimension between those dates.If you need to cover dates up to 12/31/2100 but you want to avoid potentials performance issues, you can download urn_custom_v2_date_2100.csv.zip. This date dimension template contains dates from 01/01/1950 to 12/31/2100.

5
K
1 year ago
K
kaviKnown Participant
asked in Metrics and MAQL

Accept the date while year starts with 0

Hi Kavi, Using the date dimensions has some rules for both range (1900-2050 ) and formatas specified here: https://help.gooddata.com/doc/enterprise/en/data-integration/data-preparation-and-distribution/load-csv-files-to-your-workspace/csv-file-requirements/#CSVFileRequirements-SupportedDateFormats https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/manage-custom-date-dimensions/ there is also an existing article here on community: Can you tell us little bit more about the use case and also confirm which product do you use ? (above links are related to the GoodData Platform) Thanks,Jakub

5
K
1 year ago
M
Ma'ayanNew Participant
asked in Metrics and MAQL

Rollup Methodology

Hi,I will just add that same idea as Joe describes above between Sum and Rollup applies to Average as your original question was focused on the difference there. Basically average is simple function working with values in report and rollup works with underlying data and considers the metric. (e.g. you avoid counting average from averages) Allow me to add a link to our documentation with further clarification:https://help.gooddata.com/classic/en/dashboards-and-insights/reports/working-with-tables/aggregate-table-data(the documentation I used is for our older UI so the screenshots do not match with your experience but the description is valid)Hopefully it will answer your question but feel free to follow up with some example of yours if needed.Best,Jakub

4
Joseph Heun
GoodData Employee
2 years ago
S
Sankar SandipNew Participant
asked in Dashboards and Reports

GoodData embedded analytics on public web

Hi,Just an additional comment to this topic to avoid confusion with other users reading this post. While it is technically possible it still is not part of our supported features. Our platform requires the user to be logged in. Ideal scenario is to implement single sign on to make the authentication painless.(other than that users can schedule emails and export attachments which can be shared outside of the platform)Best,Jakub 

4
Josh Collins
2 years ago
A
Ajeet RaiNew Participant
asked in Data sources

BigQuery : Data distribution worker failed. Reason: All projects failed to load.

Hi,just adding few more lines to the above. Timeout can be received also because of certain limits on either BQ or GD side.You can always check our Platform Limits to make sure your ETL or any of the other processes/tasks outlined there will run smoothly. You can do a quick workaround by splitting the load and retrying it manually.Regards,Jakub 

4
J
GoodData Employee
2 years ago
V
Vasiliy OstrovskyKnown Participant
asked in Dashboards and Reports

Dashboard filters in GoodData CN

Hi, I already answered this on Slack so just let me just repeat my response also for other community members. Your model should have a standalone dataset for Employer details, another one for Departments etc. Because ideally you do not want to have any duplicities in. Once you have the datasets you can create logical connections between them based on their relations. This will help you to have the filtering exactly as you need. Right here on the Community we already have nice article with an example.  (plus you can register to the GoodData University where all the necessary rules are explained).

2
J
GoodData Employee
2 years ago
G
giripurnamaNew Participant
asked in Metrics and MAQL

MAQL check past date

Hi,I noticed you already raised this question on our Slack so I will just recycle the answer provided by my colleague Zuzana: depends how exactly the metric is going to be used and with what kind of context. But in general you can create metric like this:SELECT IF (select count (Date (Ticket Created)) WHERE Date (Ticket Created)=THIS-3)=1 THEN 1 ELSE 0 ENDWhich takes Today date minus 3 days and then it is wrapped in IF condition to get also the other dates but these will be zeroes, only 3 days back is 1. This can be also changed to display YES or NO, e.g. by using metric formatting. e.g.[=0]NO;[=1]YES;Would that fit the use case? Basically you can review our help articles on date arithmetic, using THIS syntax and conditional formatting.https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/date-attribute-arithmetichttps://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-query-language/ma

1
J
GoodData Employee
2 years ago
S
sethjbrParticipating Frequently
asked in Data sources

New Data button vs. Load Button

Hi Seth,I am very sorry to hear that. With the removed datasets now it is hard to confirm what exactly happened. (Usually I suggest a restore of the project to previous state but it is not part of the freemium offering) Since you are planning to use it long term maybe the rebuild and consideration of full logical data model (not just ad-hoc csv uploads for short term analysis) would make more sense.Our Product team is informed about your case so be assured your feedback is heard.  And pls allow me to add few words on previous comment. The way how we map the source columns in the modeller and differ between attributes and facts is explained in this doc. (Basically to fully achieve the capabilities of the product you want to always prepare the model (connect all the datasets) and datasources and build the insights on it.) Outside of freemium we also offer backup/restores in case the customer need an urgent rollback to previous state.There are also many capabilities for advanced filtering

14
Andrey
GoodData Employee
3 years ago
S
sethjbrParticipating Frequently
asked in Data sources

New Data button vs. Load Button

Hi Seth,I was in touch with our Product team and I sent you a message from original ticket. Please review the model in your project and let me know if my manual update in the project helped. The datasets should be fully visible.Best Regards,Jakub

14
Andrey
GoodData Employee
3 years ago
A
Anonymous
asked in Dashboards and Reports

How does GoodData cache reports?

Hi Frank, The GoodData Platform employs multiple types of caching and it is all part of our analytical product.You can find “multi-level caching” mentioned in our documentation. It ensures that response times are minimized as much as possible, and the logical data model provides an abstraction layer that ensures database independence.Here is an extract from XAE engine documentation:“The Extensible Analytics Engine performs a number of query optimizations for processing and execution. Based on a series of mathematical operations, individual queries are partitioned horizontally by project and broken down into smaller, more efficient queries, the results of which are cached for future use. XAE inspects each calculation for sub-queries existing in caches across the entire multi-tenant platform, optimizing for performance and freshness of results.” Now simply said thanks to the above the projects can run faster. A report called from cache is much faster than an un-cached report. You can tes

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