New Topic
CommunityTopicQuestionIntegration
Following
photo
Eric Hagfors
Yellowfin Support Team
Assigned
Properties
Category Integration
Product Version 7.3

Get complete data from another table

Jesus Villegas shared this question 5 years ago
Answered

I have 2 views

The main view contains most of the fields I need in my report but it has Field-A which contains only a portion of the total value I need for this field, the complete information I need for Field-A is in the 2nd view.

When I look at this field directly on the second view I get a number like 80K, but when I do a join with inner, outter or other type to get the same 80K number I need, I never get this number.

Which would be the way to get this number correct for this field in View1?


Thank you.

Jesus

1 The same question

Replies (4)

photo
1
Eric Hagfors ● 5 years ago

Hi Jesus,

Thanks for reaching out to support with your issue.


I'm not following your report setup entirely, but it sounds like data is not passing from your view as expected.


here's a couple things to try:1. Mark the affected table as mandatory in the View Builder -


e518f3766dea95e2faa63dffda3d265b

2. Disable view optimization in the View Settings -


8eb59464156447b6c2bd78632736a5fa

Do either of these options help render the report as desired?

Thanks,

Eric

Reply
photo
1
Eric Hagfors ● 5 years ago

Hi Jesus,

Just wanted to check in; were you still experiencing this issue?

Thanks,

Eric

Reply
photo
1
Jesus Villegas ● 5 years ago

It was solved by the remedy team, creating a field in remedy where somehow the field mantains the value even after the filters.


Regards,

Jesus

Reply
photo
1
Eric Hagfors ● 5 years ago

Thanks for the response Jesus, glad to hear you were able to get things working as expected. I will go ahead and mark this question as answered; feel welcome to reach out with further issues.

Best,

Eric

Reply
Leave a Comment
 
Attach a file