I have a dashboard that is using 2 queries JobOp and JobMtl. i want to be able to enter the job number 1 time and it show me relevant data in each query.
Whats the best way to show both sets of data but only enter the job once, but i want to see it as separate data sets.
on the first query in the dashboard, publish the job number.
on the second query, filter by the published job number from the first.
1 Like
I did that, and then realized that wont work for this dashboard. im using it to find exceptions where an op or mtl isnt complete. so if i publish and all ops are good and some material isnt, i would miss those mtl records.
OK… then the way to do this is to do it with a THREE pane dashboard:
- pane one is the list of Job Headers… this could also list a count of operations and materials if you like. Publish the job number from this view.
- pane two is the operations. FILTERED on the published job above. This panecould have two different tabs. one for Exceptions and one for all.
- pane 3 is for the materials. FILTERED on the published job above.
You can still add a tracker view that would allow manual entry of the jobs.
1 Like