Get complete data from another table

Jesus Villegas shared this question 8 months 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

Comments (4)

photo
1

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

photo
1

Hi Jesus,

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

Thanks,

Eric

photo
1

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

photo
1

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