Dashboard Help

I have a baq I wrote that has clock-in date, labor qty, week of, and what we call Rate, for the past 2 weeks, current production, and today. What I am wanting to do is have a tab for the JCDept then all the operations underneath it. How would I do this? I will have like 5 main tabs, with the several operations in each, and inside the operations tab I will have the summed data of Past 2 weeks, today, and current production.

I’ve gotten this far with the Past 2 weeks portion:

image

Ideally it would be:
JCDept Tab
Operations
the ca, da, asm, etc you see in the pic.

You would use publish and subscribe. In your parent BAQ properties, there are checkboxes to publish values. Then in your child BAQ’s you would use the dashboard filters to filter by those published values.

image

image

This creates the tabs as well?

No, this just makes it so that the first query selects the data for what you want to see on your other tabs.

Your parent query has something like a list of job numbers.
The child queries can filter by the job number that is selected on the parent query.

This may not be what you are trying to do, but your explanation isn’t that clear.

As far as multiple rows of tabs. You can’t do that with just a dashboard. You have to customize an actual screen. Some people grab a UD screen and clear it out from the the UD stuff. But its not really trivial.

Very sorry, I am trying. Let me try again.

In the pic I posted I have CA, DA, etc. What I want to see in the first set of tabs, which would be above the CA, DA, etc, is the JCDept. For us that is Pnt, Pan, Asm. Once you click on one of those, you will then see the Operation that is associated with that JCDept. Once you then click the operation tab, you will then see a series of screens showing the summed data of Past 2 week, today, and current production (which would be the Ca, DA, etc).

The baq for the summed data is done. I am just not sure how to get the tabs for the JCDept or Operations.

I’m assuming that you are looking for tabs like this? Where there are tabs under other tabs?

You can’t do that in a dashboard without customization. You can either just publish a dashboard with just the parent BAQ then customize to add the other embedded dashbaord, or use a UD screen to make it.

My suggestion would be instead of tabs, just have a BAQ (or pair of BAQ’s if they are related) that lists the JC depts and Operations. Then use publish subscribe.

1 Like

Yes, that is correct. Gotcha. I went into the customization side and could figure out how to add a panel. So didn’t know if there was another way of doing it. Know of any videos where this is explained a bit? I’d like to learn.