Hello All, I am working on a Dashboard that breaks down the Part on a Job and shows all Jobs where the PartNum equals the Mtl Parts of the top-level. Here is an example:
To make it look better, I created a Calc field and put the Mtl Parts into a String_Agg, but in doing so, the filtering between grids broke. How can I get the subscribing grid to read what is in the string so that it populates with Jobs where the PartNum = any of the Mtl Parts in the string?
So is the bottom grid driving the dashboard?
You are listing out all the jobs that make material parts and want to see what jobs need those parts and what SO’s contain those parts made from the manufactured material parts in the bottom grid?
And you are getting multiple lines per Job in the bottom grid as those jobs have multiple material lines?
Can you use IN as a condition in the filtering? You could concatenate the parts to a string using a comma as the delimiter and then the subscribing grid shows rows where part IN (stringOfCommaSeperatedParts).
I believe the top grid is driving. Clicking an SO Line populates next grid with Jobs for the SO Part. Clicking on a Job on the Jobs of SO Part grid populates the next grid with Jobs for the Mtl Part list on the line on the grid before.
You are correct on the multiple lines and that is what I was trying to limit. I do not think I can use IN condition, at least through the Dashboard filters. The only options available are these:
I could maybe do an IN condition in Application Studio, but I haven’t attempted yet.
