Hi Team, I’m noticing that all fact-type fields f...
# gooddata-cloud
v
Hi Team, I’m noticing that all fact-type fields from the datasets Custom Profile Responses and Custom Profile Global Responses are disappearing whenever I attempt to pull fields from other datasets in the same visualization. Dev environment Could you please investigate this behavior and advise on a resolution or possible workaround?
m
Hi Vivek, this behavior is likely caused by how the datasets are related in your data model and if there’s no valid path between the facts in those datasets and the others you’re adding into the same visualisation. When its not a valid path, it automatically hides fact / attributes to avoid producing incorrect or misleading results. There are some good tips in the following article to help with this here: https://university.gooddata.com/tutorials/data-modeling/
v
Ok Thanks, Michael
Hi Michael, I’m working on a scenario where I want to visualize the applicants whose profile age falls between 20–30 years. However, I’m unable to do so—when I bring in “Applicant Name” from the Application dataset, the fact titled “What is your age” from Custom Profile Responses disappears. The datasets Application and Profile are connected via a many-to-one (N:1) relationship, and Custom Profile Responses is also linked to Profile. Despite this, only the facts from Custom Profile Responses disappear—_attributes_ are still visible. Could you help clarify why this might be happening?
j
Hi Vivek, you will need to utilize a BY clause in your metric with the primary key in the Profile dataset as the connection point. We generally refer to building this type of metric as EXPLICIT LIFTING. This will help you make the connections to other data sets and allow those objects to be used in your reporing.
m
Hi Vivek, I am just wondering if you have the chance to check the last update provided by my colleague Joseph. Please, let us know if you need further assistance.
v
Hi Mauricio, I am currently reviewing the documentation on explicit lifting. I will let you know once the issue is resolved.