On dashboards when building a panel I did a join from 2 different forms. The LOBID and active_online are from the join form, the other 4 fields are from the 1st form. The fields are joined through LOB.
My issue is some of the data is repeating itself as you can see in the picture attached.
I want only one 14 to be displayed instead of a whole column of them. (also just so you know there are other values in these columns and they repeat as well.)
It could be an issue with my join. right now iām using a left outer join in this format:
FROM
1st form
LEFT OUTER JOIN join form
ON (
1st form
.LOB
= join form
.LOB
)